MSSQLSERVER_2
Applies to:
SQL 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