Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 18, 2012 09:13 PM by tcha143b
Dec 18, 2012 07:17 PM|LINK
How do I connect to a Sql Server DB located on a separate server that is part of the same network and what would the connection string look like in the web.config file?
Dec 18, 2012 08:43 PM|LINK
You should be able to find the connectionstring you want from this site:
Dec 18, 2012 09:13 PM|LINK
Thank you. I used this pattern that I found on that site for the correct connectionstring
"Provider=sqloledb;Data Source=22.214.171.124,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=myUsername;Password=myPassword;"