September 30, 2011 at 12:00 pm
We have a SQL 2008 R2 instance where the Master db seems to be in single_user mode. I say it that way because the SSMS GUI and sys.databases report Master to be in single_user, but at the same time sp_who2 shows multiple connections to Master.
An attempt to Alter Master to a different state results in "Option 'MULTI_USER' cannot be set in database 'master'" Restarting the instance has no effect.
Has anyone seen this before? thanks
September 30, 2011 at 12:17 pm
Ken Davis (9/30/2011)
We have a SQL 2008 R2 instance where the Master db seems to be in single_user mode. I say it that way because the SSMS GUI and sys.databases report Master to be in single_user, but at the same time sp_who2 shows multiple connections to Master.An attempt to Alter Master to a different state results in "Option 'MULTI_USER' cannot be set in database 'master'" Restarting the instance has no effect.
Has anyone seen this before? thanks
what's the errorlog look like?
this sounds similar to this thread:http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/47e5e584-b35a-45d1-9d75-709425583867
September 30, 2011 at 12:26 pm
It's completely clean. Nothing out of the ordinary.
September 30, 2011 at 12:28 pm
Ken Davis (9/30/2011)
It's completely clean. Nothing out of the ordinary.
can you post the error log from the point of a startup? the server isnt starting in single user mode right?
did you do an upgrade recently or something like that? what preceded this problem?
October 1, 2011 at 12:00 pm
you probably have a start-up parameter that should not be there. Post the errorlog as already requested, 99% chance the explanation will be in there.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply