I need to restore the MASTER database from the current backup.
Here is what I did.
from the command prompt
net stop sqlserveragent
net stop mssqlserver
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr -c -m
now the SQL Server is in single user mode.
At this point I dont have any user connections to the database.
When I try to access the MASTER database from EM it says "Login failed.Only one administrator is allowed in single user mode "...
I cant figure out who has logged in???
Before I did all this stuff I changed the STARTUP parameters from the EM connection and included -m ...
now even after restarting the service SQL Server still boots in SINGLE USER MODE.
There is no way I can access it now.