I have started SQL Server in single user mode like this:
When I try to connect to it with
SQLCMD -E, I get the following error:
Msg 18461, Level 14, State 1, Server SERVERNAME, Line 1 Login failed to user 'USER\Name'. Reason: Server is in single user mode. Only one administrator can connect at this time.
The user I am logged onto the server as is a domain administrator.
Before I tried this, the user I am logged on as had nothing to do with this SQL server. (I am in fact, trying to create a new SA as we don't know what the current password is)
It seems that even if I do:
I am still getting the above error. I am not sure if there are other
SQLCMD calls happening from elsewhere.