locked
Shutdown in Progress on MS SQL 2008 RRS feed

  • Question

  • Good Day...

     

    I was wondering why my applications connecting to SQL server 2008 (64bit) gets an error message. "Shutdow in Progress".

     

    Monday, November 21, 2011 3:11 AM

Answers

  • I would assume that this is because someone has initiated a shutdown process, for instance with the SHUTDOWN command. The shutdown process has then not be able to complete because it is waiting for some operation to complete, for instance a rollback.

    You should be able to get more information by looking in the SQL Server errorlog.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by Maggie Luo Tuesday, November 29, 2011 6:34 AM
    Monday, November 21, 2011 10:29 PM
  • Hi Jeff,

    SQL Server is in the process of shutting down. During shutdown only members of the sysadmin fixed server role can make new connections. A shutdown may be initiated by a person or by a program such as cluster administrator, or the shutdown may be the result of problems such as an unhandled exception.

    User Action:
    Wait for the SQL Server shutdown to complete, and then restart SQL Server. Once SQL Server is restarted, try your connection again. If you must connect to SQL Server before the shutdown is complete, you can try to connect with a member of the sysadmin role; this will only succeed until a certain point in the shutdown process is reached. 

    If the shutdown was unexpected, review the SQL Server error logs and the event logs for related messages that can help to determine the cause of the shutdown.

    For more information about shutdown, see "Stopping SQL Server" and "SHUTDOWN" in Books Online.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Maggie Luo Tuesday, November 29, 2011 6:34 AM
    Tuesday, November 22, 2011 6:32 AM

All replies

  • Can you post a full error message? http://support.microsoft.com/kb/301642
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, November 21, 2011 7:44 AM
  • I would assume that this is because someone has initiated a shutdown process, for instance with the SHUTDOWN command. The shutdown process has then not be able to complete because it is waiting for some operation to complete, for instance a rollback.

    You should be able to get more information by looking in the SQL Server errorlog.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by Maggie Luo Tuesday, November 29, 2011 6:34 AM
    Monday, November 21, 2011 10:29 PM
  • Hi Jeff,

    SQL Server is in the process of shutting down. During shutdown only members of the sysadmin fixed server role can make new connections. A shutdown may be initiated by a person or by a program such as cluster administrator, or the shutdown may be the result of problems such as an unhandled exception.

    User Action:
    Wait for the SQL Server shutdown to complete, and then restart SQL Server. Once SQL Server is restarted, try your connection again. If you must connect to SQL Server before the shutdown is complete, you can try to connect with a member of the sysadmin role; this will only succeed until a certain point in the shutdown process is reached. 

    If the shutdown was unexpected, review the SQL Server error logs and the event logs for related messages that can help to determine the cause of the shutdown.

    For more information about shutdown, see "Stopping SQL Server" and "SHUTDOWN" in Books Online.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Maggie Luo Tuesday, November 29, 2011 6:34 AM
    Tuesday, November 22, 2011 6:32 AM