SQL Server Error Msg 10054, Level 20, State 0, Line 0
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.)
Some possible causes are as below
- The server has been restarted, this will close the existing connections.
- Someone has killed the SPID that is being used.
- Network Failure
- SQL Services restarted
RESOLUTION: Just hit F5 or (ALT + X) to re-run your query. SSMS will determine it is
no longer connected and then prompt you to reconnect it will put you back into
the same database.
Otherwise reconnect to
SSMS and re execute the query.
Comments
Post a Comment
Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You