Are there any other causes of this error that are NOT related to initial setup?

Posted by LordScree on Server Fault See other posts from Server Fault or by LordScree
Published on 2012-04-03T10:21:03Z Indexed on 2012/04/03 11:33 UTC
Read the original article Hit count: 172

I'm trying to diagnose an issue at a customer site. They are receiving the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server

I've seen this a few times, but only during the initial setup - it's often caused by one of the following:

  • The database server is turned off
  • The network connection between the database server and the application is closed or somehow blocked (e.g. a firewall)
  • The SQL Server instance is not set up to receive remote connections from the application server (e.g. TCP is turned off, remote connections are disabled, or the "SQL Server Browser" service is stopped/disabled)

However, if I assume that no configuration changes have been made, I'm trying to postulate on what the reason might be for getting this error at a random point after the initial setup. My initial thought is:

  • SQL Server machine has run out of resources (e.g. RAM) and is unable to accept new requests from the application server

Is this a valid theory? What other possible causes are there of this error that are not related to the initial setup of the server / application connection? Or is it simply impossible that this error could occur without a configuration change having been made (either on the SQL Server side, application side, or somewhere in-between (network))?

NOTE: I believe this question differs from the plethora of questions related to this error message because the application and server have been talking to each other quite happily until now (most, if not all, other questions seem to relate to initial setup).

© Server Fault or respective owner

Related posts about sql-server

Related posts about connection