how to retrieve the data from the another server

Jayant Kumar12y ago

Your connection String is correct, If you are using local machine for database server, you can use ".", "127.0.0.1" or "localhost" all are same,

If you computer has sql server express edition is installed then by default the name of the database server instance is SQLEXPRESS otherwise you can also put only the server name.

One Workaround, you can at first check whether you are able to connect SQL SERVER by putting VALUED-HO1E64NO\SQLEXPRESS in server name, uid and password

thanks- Jayant

saurabh mittal12y ago

Hi

if you are using Local server than no need to give ip address just put this between connection
string in web.config file.

providerName="System.Data.SqlClient"/>

thanks

selvi subramanian12y ago

its for a local server ah sir.

Sanjeeb Lenka12y ago

hi,

yes that one is the ip address of the server you have to give to connect to that server

selvi subramanian12y ago

sir 127.0.0.0 whats this sir its a ip address ah

saurabh mittal12y ago

Hi
you can write this :