Question
How to recover SQL SA password?
Answer
In order to recover SQL SA password, please follow below steps:
Step1
Log in windows as an administrator
Step2
Run SQL Server Configuration Manager - select the server - right click Properties - Startup Parameters - add -m to Existing parameters - OK.
Step 3
Restart the Server.
Step 4
Run Microsoft SQL Server Management Studio, login as Windows Authentication
Step 5
Go to Security - Logins - sa - Properties, reset password and click OK
Step 6
Go back to SQL Server Configuration Manager - select the server - right click Properties - Startup Parameters - remove -m to Existing parameters - OK.
Step 7
Restart server. You are able to log in as sa with the new password now.