Getting an error like this after you start SQL in single user mode can be frustrating:
This happens to me sometimes when I am attempting to reset passwords of instances. Here are the steps you can take to get by this error (“Run as Administrator” should be selected for all command below) :
- Stop the SQL Server Service:
1net stop MSSQLSERVER - Start the SQL Server Service using the switches below. The service will not fully start and the “service is starting…” message will remain in the command window. Once this message is displayed you can move on to step 3:
1net start MSSQLSERVER /c /m /T3608 - Either open Management Studio and connect to the instance, or open a new CMD window to use SQLCMD.
- Once you’ve completed the necessary changes the SQL Server Service will need to be forcibly stopped. Either end the process in task manager or use the following command in the windows CMD window:
1taskkill /IM sqlservr.exe /F - Now SQL can be started normally.