locked
SIngle User Mode: Message RRS feed

  • Question

  • Team,

    I have a weird question. Whenever the SQL Server is put into Single user mode as sysdba why do we get this message?

    Server is in single user mode. Only one administrator can connect at this time?

    As a sysdba we shouldnt get this message as we are the administrators right?

    Regards,

    Krish!

    Tuesday, March 13, 2012 5:15 PM

Answers

  • Hi skrishnamu,

    Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

    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.

    • Proposed as answer by Papy Normand Sunday, March 18, 2012 8:58 PM
    • Marked as answer by Maggie Luo Wednesday, March 28, 2012 8:48 AM
    Thursday, March 15, 2012 2:08 PM
  • Affirmative. But the goal is to lock out everybody and everything from the database so that DBA tasks can be performed.

    Kalman Toth SQL SERVER & BI TRAINING

    • Proposed as answer by Papy Normand Sunday, March 18, 2012 8:58 PM
    • Marked as answer by Maggie Luo Wednesday, March 28, 2012 8:48 AM
    Friday, March 16, 2012 4:25 PM

All replies

  •  SQL Server Agent may got in ahead of you. Stop it prior to switching modes:

    http://www.sqlusa.com/bestpractices/singleuser/


    Kalman Toth SQL SERVER & BI TRAINING


    • Edited by Kalman Toth Tuesday, March 13, 2012 7:44 PM
    Tuesday, March 13, 2012 7:39 PM
  • Thanks for your response. So you mean to say we need to stop Agent and then in the startup parameters set to -m and then this message shouldnt popup?

    Regards,

    Krish!

    Thursday, March 15, 2012 9:56 AM
  • Hi skrishnamu,

    Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking it.

    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.

    • Proposed as answer by Papy Normand Sunday, March 18, 2012 8:58 PM
    • Marked as answer by Maggie Luo Wednesday, March 28, 2012 8:48 AM
    Thursday, March 15, 2012 2:08 PM
  • You can still get in using DAC(dedicated admin connection) even if someone else (SQLAgent or other DBA) already acquired that single session.
    Friday, March 16, 2012 3:14 AM
  • Affirmative. But the goal is to lock out everybody and everything from the database so that DBA tasks can be performed.

    Kalman Toth SQL SERVER & BI TRAINING

    • Proposed as answer by Papy Normand Sunday, March 18, 2012 8:58 PM
    • Marked as answer by Maggie Luo Wednesday, March 28, 2012 8:48 AM
    Friday, March 16, 2012 4:25 PM