I'm following the MS documentation here to migrate logins from one instance of SQL Server to another as part of the process described here. This involves putting the server into single user mode (which I've done) and then running scripts etc.
However, after restarting in single-user mode (with only the SqlServer service running) I am unable to log-in using either my Windows account or sa
credentials. I get the error:
Failed to connect to <servername>
Login failed for user 'sa'. Reason: Server is in single user mode.
Only one administrator can connect at this time. (Microsoft SSQL Server, Error: 18461)
After restarting the server normally (ie. multi-user mode) all the logins work fine.
Can anyone explain what is going on and/or how to correct this?