Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 13, 2012 01:41 AM by codeasp
Nov 11, 2012 06:43 PM|LINK
I am connecting a remote sql server database from my asp.net application. Using the connection string in web config file
<add key="SqlConnectionString" value="Data Source=http://p1.mtxinc.com:8234;Database=test;Uid='test';Pwd='test';Network Library =dbmssocn"/>
But i am getting this error:
Nov 12, 2012 02:17 AM|LINK
Can you connect to the SQL instance using Management Studio. Exception is too broad but It may be SQL server is not configured to accept any incoming connections over TCP/UDP. You will need to contact the DBA to make sure the SQL is configured to accept
Nov 12, 2012 03:07 PM|LINK
Same error is coming with connection with sql management studio
Nov 13, 2012 01:41 AM|LINK
Who is the owner of the database? The SQL server should be configured to accept incoming connections via TCP/UDP. If you have access to the SQL server then you can configure it by yourself. Google with keywords "sql server accept remote connections".
If not you have to rely on the owner to open the connection for you.