Post reply

How do I put the Server back into multi user mode?

  • April 29, 2008 at 8:11 am

    #121930

    I put the sqlserver in single user mode to restore the master, now I cannot put it back to multi user mode. I used the -m in the startup to put server into single user mode it worked I restored the master, I restarted the sql server, I was then going to restore the msdb by putting that database in single user mode then recover I get a error stating (server) is in single user mode. How do I put the Server back into multi user mode?

    Thanks

  • April 29, 2008 at 8:39 am

    #808404

    have you made sure that the sql agent is not started, if it is then that will be using your single connection and stopping you from using it.

    If you want to take the single user switch off then you can do that through the configuration manager, services, properties, advanced, startup parameters. take the -m off.

  • April 29, 2008 at 8:53 am

    #808424

    As my Zoo keeper friend mentioned, remove the -m parameter and you should be ok.

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

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