March 3, 2010 at 6:55 pm
I'm working on a database offline tonight and I set it into single user mode.
I'm logged on as "sa".
Now, I can't access the database. Can anyone give me any idea how to make the database accessible?
Thanks,
LC
March 3, 2010 at 9:05 pm
Connect to SQL as SA (to any database) and kill the connection to your database. You should be able to connect - you would be the "single" user using the database.
March 4, 2010 at 2:20 am
crainlee2 (3/3/2010)
I'm working on a database offline tonight and I set it into single user mode.I'm logged on as "sa".
Now, I can't access the database. Can anyone give me any idea how to make the database accessible?
Thanks,
LC
stop the sql service and restart it, it should resolve the issue. and before you restart remove the parameter from startup parameters list if it has been specified there otherwise if sql was started in single user mode using cmd, closing the cmd will resolve the issue.
nexxt time onwards, be sure you stop sql server agent and other dependent services which connect to sql before you put sql in single user mode because the moment sql starts these services take the first available connection.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
March 4, 2010 at 7:24 am
Gentlemen,
Thank you for your advice. It worked.
LC
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply