Menu

Want to work with us? We're on the lookout for a talented Digital Project Manager.

We're hiring

SQL Server Frustration Again

Web Bureau


19 January 2011 by Web Bureau

SQL Server Connection Issue After Reboot:

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

Explanation

The SQL Server client cannot connect to the server. This error could occur because either the firewall on the server has refused the connection or the server is not configured to accept remote connections.
  
--------------------------------------------------------------------------------------------------------------

RESOLUTION:

Make sure that you have configured the firewall on server instance of SQL Server to accept connections.

Use the SQL Server Surface Area Configuration tool to allow SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.

Grow your businessStart a project with us today.