Steps to Reset SQL Server Password

The steps given below will guide you through the usage of SysTools SQL Password recovery software which helps reset lost & forgotten Microsoft SQL Server database password.

STEP 1

Go to Start menu » All Programs » SysTools SQL Password Recovery » SysTools SQL Password Recovery and the software will launch. The following screen will appear on screen:

sql password recovery
STEP 2

Click on Browse option provided to "Select (master.mdf) file" and load the desired MDF file.

browse mdf file
STEP 3

Locate and select the MDF file. Click on Open to open the file.

open master mdf file
STEP 4

Select the SQL Version carefully for the selected MDF. Note that selection of the wrong version may even lead to inconsistent behavior.

Note: Selecting a Wrong Version may result in inconsistent behaviour
select sql version
STEP 5

The software will scan the selected Master Database file and display a completion report once the scan finishes. Click OK.

database scan complete
STEP 6

The tool will list all the users that were created in SQL Server. Password column carries two values as
Unknown and Empty
Unknown means you have a password and database is encrypted.
Empty means you do not have a password for the user name and you can log into the account without a password.

Select the user whose password you want to reset and click on Reset.
Caution: Before proceeding further it is highly recommended to take a backup of your Master.mdf and Master_log.ldf files as the tool will make changes to the Master database in the next step.
reset sql password
STEP 7

The tool will prompt you to back up the Master.mdf and master.ldf files before continuing.

alert message
STEP 8

If you continue the tool will set an Empty password for the selected user. Click on Yes and go for the Reset option.
The tool will set an Empty password for the selected user.

password reset
STEP 9

Now log in to SQL server without being interrupted by a password restriction.

sql server 2008

Free Download SQL Password Recovery Download