0

We are troubleshooting a weird issue with our SQL Server 2008 server. The application server runs a windows service that makes a DB connection via a connection string in its config file, and we end up with tons of the standard 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.' errors in the event log.

  1. We have tried installing SSMS on the application server and connecting to the particular DB with those particular credentials works FINE.
  2. Firewall is off on both sides.
  3. TCP/IP protocol is enabled (and we use IP and custom port to force tcp).

We are stumped why it doesn't work via the app and need some pointers!

We have many SQL servers setup in our development and production environments and this particular setup doesnt appear to be any different.

CONNECTION STRING:

<add name="myConnectionString" connectionString="Server=MYSERVERDB1; Database=MYDB; Network=DBMSSOCN; Address=192.168.20.161,2061; User Id=MYDBusr_vn;Password=blue123;Asynchronous Processing=True;Application Name=MYService;" providerName="System.Data.SqlClient" />
4
  • Can you post connection strings?
    – squillman
    Apr 2, 2014 at 15:07
  • Updated with connection string.
    – tresstylez
    Apr 2, 2014 at 15:34
  • Can you also post the connection settings from SMSS?
    – MichelZ
    Apr 2, 2014 at 16:05
  • Sure, where exactly do I find the SSMS connection settings to copy/paste?
    – tresstylez
    Apr 2, 2014 at 16:11

0

You must log in to answer this question.

Browse other questions tagged .