Connection string to remote db ?

pauldrq

New Member
What is the connection string for a web server connecting to a sqlserver db sitting in another machine ?<BR><BR>This is for local :<BR> server=(local);uid=id;pwd=pw;database=Northwind;<BR><BR>Can I use IP adress ?<BR> server=(remote IP addr);uid=id;pwd=pw;database=Northwind;<BR>or<BR> server=(remote machine name);uid=id;pwd=pw;database=Northwind;<BR><BR>Thanks in advance,<BR><BR>http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForSQLServer<BR><BR>Look down to "For SQL Server running on a remote computer"publishing a user name and password, is it a good idea? What will be connection string for a web server connecting to a sqlserver using NT Authentication security.<BR>
 
Back
Top