Sometime you may get the below error while connecting to SQL Server:
.Net SqlClient Data Provider: Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)
Generally this error occurs when connection to SQL server is forcible closed due to some reasons. Some possible reasons are:
.Net SqlClient Data Provider: Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)
Generally this error occurs when connection to SQL server is forcible closed due to some reasons. Some possible reasons are:
- KILL Command is issued by any other user.
- SQL Server Service is restarted / Stopped
- When the connection was IDLE for a long time
- The database to which the connection is connected to is restored
No comments:
Post a Comment