Home » SQL Server Error : -2

SQL Server Error : -2

sql server DBA 999

SQL Server Error : 2, Severity: 0. An error has occurred while establishing

SQL Server Error : 2 Details

SQL Server Error: 2 Severity: 0 Event Logged or not: No Description: 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) Severity 0 Description: Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.

Reading sql server error log location from SQL Query

Identifying SQL Server … Read the rest

sql server DBA 999

SQL Server Error : -2 Severity: 0. Timeout expired. The timeout period elap

SQL Server Error : -2 Details

SQL Server Error: -2 Severity: 0 Event Logged or not: No Description: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2). Severity 0 Description: Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.

Solution for Resolving the Error

The query timeout to execute. Either the server is not responding or query is very large/big to execute within timeout limit.

Increase time out in Server properties

 

SQL Server Error Code and solution summary

SQL Server Error: -2 … Read the rest