I migrated a few SQL servers from another site and joined them to a new domain. As a result I was no longer able to log into the SQL instance with Management Studio. If you find yourself in this situation there is an easy fix. Start SQL in Single user mode and log in with the local admin account.
- Open up Services.msc and find the SQL service, go to properties and note the “Service name: MSSQL$INST01”
- Open up command prompt as Administrator, stop the service and start it up in single user mode by adding /m to the end.
Net Stop MSSQL$INST01
Net Start MSSQL$INST01 /m - Open up MGMT Studio and you should be able to log in with any Local admin account.
- Stop the service again and start it up from the services.msc console or without the /m