Connect to SQL Server from win form over LAN

[Garry_Meax]

how my connection string should be if i want to access remote(within out local network) sql sever from a win form?

[gep13]

Hey,

Have a look at the connectionstrings link in my signature, you should be able to find the answer there.

Hope that helps!!

Gary

[Garry_Meax]

i am able to connect this database from aspx web page.

i have connection string saved in the web config file.

[gep13]

Hey,

Were you asking a question there?

Gary

[Garry_Meax]

sorry, i like to know is this ok,

strConnection = ("Driver={SQL Server};Server=xxx.xxx.x.xx;"
"Trusted_Connection=no;"
"Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;");

[gep13]

Hey,

So which part of that is not discussed here:

http://www.connectionstrings.com/sql-server-2005#1

Gary

[Garry_Meax]

i used this one:

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

but still i am getting remote connection not allowed error.

from surface area configuration i have enabled remote connection(TCP/IP and named pipes)

added sqlserver.exe to windows firewall.

why am i still unable to connect to db?

[gep13]

Hey,

Have you also checked this section of the connectionstrings website?

http://www.connectionstrings.com/Art...twork-protocol

Also, are you getting an error returned? If so, what is it?

Gary

[Garry_Meax]

thanks you so much for replying, i ma going to try it