How to connect server and make changes when sql server started in single user mode?

  • I started sql server in single user mode.

    My question is how to connect to sql server and make changes using that single user quote?

    Thank you so much.

  • Generally I use sqlcmd from the command line to do it and I use a batch script to start the instance in single usermode and then immediately connect to it. I do this because if an application connects faster than you, you have to shutdown and try again. However, you can connect with SSMS as long as the Object Explorer isn't connected to the server. You do this by clicking cancel on the first connect dialog when SSMS opens. Object Explorer is its own connection and each query window is a connection, so you have to disconnect the object explorer connections to get a query window connection to the single user mode instance.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply