Click here to Skip to main content
13,730,915 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.


and
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.
Posted 2-Apr-12 19:33pm
Updated 2-Apr-12 20:11pm
v2

1 solution

Rate this: bad
 
good
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 http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/b9a7b2fb-0f41-4eef-a183-70c8a4f6c9c9[^]

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

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
Web01-2016 | 2.8.180920.1 | Last Updated 3 Apr 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

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