MSSQLSERVER_10060

New: 12 December 2006

Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

10060

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

Message Text

An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not 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.

User Action

To resolve this error, try one of the following actions:

  • 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.

See Also

Other Resources

How to: Configure a Firewall for SQL Server Access
Opening Ports in the Firewall
Connecting to SQL Server over the Internet
Getting Started with the Database Engine
How to: Configure Client Protocols (SQL Server Configuration Manager)
Network Protocols and Network Libraries
Default Client Connection Behavior
Configuring Client Network Protocols
Configuring Server Network Protocols and Net-Libraries

Help and Information

Getting SQL Server 2005 Assistance