SIngle User Mode: Message

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!

Answer 1

 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

Answer 2

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!

Answer 3

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.

Answer 4

You can still get in using DAC(dedicated admin connection) even if someone else (SQLAgent or other DBA) already acquired that single session.

Answer 5

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