At first I thought starting SQL Server in Single user mode is easy in Windows 2008 fail-over cluster. But I was wrong, If I just add ‘;-m’ in start-up parameter and starts it, the SQL server will start in single user mode via cluster. But we wont be able to log in. The cluster service logs in before us. And so we might see an error like below.
Login failed for user ‘Domain\user’. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: xx.xx.xx.xx]
Now what do we do? Below is how I overcame this problem.
- Take the SQL Server cluster group offline.
- Now just make the Disk and the cluster virtual name alone online for the SQl Server Cluster group.
- start command prompt with admin rights and type below command.
- net start “SQL Server (instancename)” /m
- Open a command prompt with “Run as Administrator” option and now you can login to SQL Server via sqlcmd with any account that has access to SQL Server or an account that has admin rights on the Operating System.
Hope this helped !