Locked out of my SQL Server.
Posted on 2007-04-09
I have MSSQL Server running on a Windows Server 2003 environment. The main DB we use to run our entire business went to single user mode for some reason. The fix should be simple, just switch back to multi-user mode. However...when I try to do anything (view tables, users, go to properties) I get the following message:
Error 22285: [SQL-DMO]Database 'GM001' is already open and can only have one user at a time.
This is problematic since I need to get to properties to change back to multi-user mode.