Click here to Skip to main content
13,895,898 members
Rate this:
Please Sign up or sign in to vote.
While executing sql queries i am getting below mentioned error message
Msg 6005, Level 14, State 2, Line 1
SHUTDOWN is in progress.

after sometimes like

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.)

Please do let me know how to fix.

Thanks in advance.
Updated 2-Apr-12 20:11pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

The SQL server is shutting down. Re-run the query after server restart is complete.

There could be a scenario where your SQL server may take some time to shutdown. It could be waiting for rollback of transactions to complete. Please read the link[^]

If your SQL server is not a PROD instance, and you choose not to wait for rollback to complete you can kill the sqlserver.exe, or stop and restart the SQL Server windows service.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.190306.1 | Last Updated 3 Apr 2012
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100