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 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?