I am getting an SqlException
in the logs of .NET 3.5 app, I am looking for the corresponding number (value of the property SqlException.Number
).
System.Data.SqlClient.SqlException: A transport-level error has occurred
when receiving results from the server. (provider: TCP Provider, error: 0
- The specified network name is no longer available.) at
System.Data.SqlClient.SqlConnection.OnError
I am also getting error such as:
System.Data.SqlClient.SqlException: 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.
Does anyone know how to properly catch those exceptions? (you can also post your answer here)