how my connection string should be if i want to access remote(within out local network) sql sever from a win form?
Printable View
how my connection string should be if i want to access remote(within out local network) sql sever from a win form?
Hey,
Have a look at the connectionstrings link in my signature, you should be able to find the answer there.
Hope that helps!!
Gary
i am able to connect this database from aspx web page.
i have connection string saved in the web config file.
Hey,
Were you asking a question there?
Gary
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;");
Hey,
So which part of that is not discussed here:
http://www.connectionstrings.com/sql-server-2005#1
Gary
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?
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
thanks you so much for replying, i ma going to try it