restoring master db on Clusted SQL Server

[janeRL]

Hi,

I was trying to restore master db on Clustered SQL Server. As required for master db restore I put SQL server in single user mode (by adding -m parameter). Now I can't get to the SQL Server Enterprise manager on the server, it gives me "Server is in single user mode. Only one administrator can connect at this time". So I locked myself out and I can't connect to the SQL Server anymore. How can I get to not single user mode now and what is the right way to restore master DB on Clustered SQL server, so it doesn't get locked out?
Thank you,

Jane

PS: I tried to run sqlservr.exe with no parameters, it didn't resolve the issue.

 

[JayKusch]

Hmmmm... Give this a try in Query Analyzer:

EXEC sp_dboption 'Master', 'Single User', 'False'


Thanks

J. Kusch

 

[janeRL]

Well, the problem is I can't login into Query Analyzer.
Any other ideas?
Thanks,

Jane

 

[dafdba]

I think you should stop the SQL Server cluster resource (unmark the restart option to prevent a switch of nodes when you stop SQL Server) and stop the SQL Server service on the active node. Now it should be possible to start SQL Server on the active node in single user mode and restore the master DB.