MSSQLSERVER_2

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
Event ID 2
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name
Message Text An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

Explanation

SQL Server did not respond to the client request because the server is probably not started.

User Action

Make sure that the server is started.

See Also

Manage the Database Engine Services
Configure Client Protocols
Network Protocols and Network Libraries
Client Network Configuration
Configure Client Protocols
Enable or Disable a Server Network Protocol