SQL Server Native Client ODBC Connection Fails

by Michael Heindel   Last Updated March 01, 2017 14:06 PM

I am trying to troubleshoot an issue where some clients can connect and others cannot.

  1. Server and Database is online, Browser started, Named Pipes & TPC/IP enabled
  2. All users use the same SQL Account and Password
  3. Connection to database from SSMS works
  4. Local firewall rules are from GPO and match all clients
  5. Instance is configured to allow remote connections
  6. Server does not have firewall rule blocking any client IP involved

We create a SQL Server Native Client 11 ODBC connection. On some clients the connection comes back with Success and others come back TESTS FAILED!

The full text of the message is Running connectivity tests ... Attempting connection [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [5]. [Microsoft][SQL Server Native Client 11.0]Login Timeout expired [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

Any ideas on why some clients are not able to connect?

Thank You,

Michael



Related Questions


How do I get the Query Timing with sqlcmd?

Updated May 23, 2017 04:06 AM




Sql Server Configuration Manager

Updated June 03, 2017 05:06 AM