Every time when you came across a problem that you forgot SQL SA password, what would you do? If you have no answer, I would like to take the pleasure to tell you how to deal with forgotten SQL SA password issue. There are two methods I could tell you.

Method 1: Change the Known Password to a Complex One
1: Run command prompt when you have made sure the SQL has been connected.
2: Type in the following command and then press “Enter”.
osql -U sa
3: Type in the following command to change the password and then press “Enter”
Sp_password @old = null, @new = ‘complexpwd’, @loginame=’sa’
go

Method 2: Reset SQL Server Password with SQL Server Password Recovery
1:Download MS SQL Server Password Recovery on your PC, and then install and launch it.
2: Please click on the “Open” button to import the target file of master.mdf.
3: Make a selection of the SA account and then click on the “Change Password”button.
4: Enter into your new password and then click on the “OK” button.You will get SQL server password reset in minutes.
These two methods can be used to deal with forgotten SQL SA password issue, so next time if you meet with these problems again, you can have two options. But from the above expressions, we may feel that the second method is easier to use than the first one. Generally speaking, we are intended to select the easier one as a common person.