I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error:
Login failed for user 'LOCALSERVER\Administrator'. Reason: Server is
in single user mode. Only one administrator can connect at this time.
(Microsoft SQL Server, Error: 18461)
I've tried starting it up in Single User mode by both -m"SQLCMD"
and -m"sqlcmd"
and Iv'e even tried to start it up with -m"Microsoft SQL Server Management Studio - Query"
and connecting with the appropriate clients I ALWAYS get this error. I'm 99% sure that nothing else is stealing my connection and when connecting with SSMS I make sure to do the "new query-connect` method to ensure it only uses 1 connection.
Has anyone else had this problem? How do I fix it and login?
Best Answer
Here's a solution I just found to this old issue:
If not started as administrator (as I wasn't), then you'll receive the generic an admin is already connect. Instead of saying you can't connect because you aren't an administrator.
Another confusing error from Microsoft. I suppose the same issue will exist with a sqlcmd too
Regards
Liam