Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 20, 2012 01:29 AM by Amy Peng - MSFT
Nov 18, 2012 11:44 PM|LINK
I have two databases in my vb.net web page. and one databse resides in the same server as a local database (web application and database resides in the same server)
but the second database resides in another server and I am coonecting to this databse using VPN conection via SQL Server Management studio....then how can I coonect to that database programmatically from my web page using vb.net???
I tried something like this:
<add name="LoginEx" connectionString="Data Source=SQL.ex.com;Database=exDb;User ID=exad;Password=exexex;Integrated Security=true" />
but its not getting connected to that server.....Can anyone please help me???
Nov 19, 2012 02:23 AM|LINK
In the "Data Source" , refer Server(System Name or IP address) follows by the Sql Server Name.
Nov 20, 2012 01:29 AM|LINK
Have you configured your sql server to allow remote connect? Try to check it and refer to the following article about how to allow remote connection:
For the connection string, you can try to let Data Source=Ip address of the sql server ;
If you still can not fix this error, please try to show us the error message which occurs when you connect the sql server.