Process to Know How to Recover SQL Server Password

Reset the lost and forgotten passwords of Microsoft SQL Server database with SQL Server Recovery Manager Toolkit; a single application with multiple facilities.

STEP 1

Open & Launch the SQL Server Recovery Manager Tool. Click 'Recover SQL Server User Password' module.

recover-sql-server-password
STEP 2

Click on Browse button to load the Master MDF file for password recovery.

sql-server-password-recovery
STEP 3

Browse the location and Select Master.mdf file. Click Open

open-master-mdf-file
STEP 4

A prompt window will appear once the scanning has completed successfully. Click Ok

scan completed
STEP 5

The tool will list all users created in SQL Server. Password column carries two values as:Unknown and Empty

  • Unknown means that a password is present and encryption is applied.
  • Empty means you do not have a password for the user name, you can login the account without involving a password.

Select the user whose password has to be reset. And Click Reset Password button.

Caution: Before proceeding further, it is highly recommended to backup your Master.mdf and Master_log.ldf files as the tool will make changes to the Master database in the next step as part of resetting the password.

reset sql server password
STEP 6

The tool will alert you to back up the Master.mdf and Master_log.ldf.

warning-message
STEP 7

Enter the new password that you want to apply. And click OK

set password
STEP 8

Pop will appear showing your password for the selected user has been successfully resetted. Click OK.

password for the selected user is reset successfully
STEP 9

Start SQL Server and connect to the database.

sql server 2008

Free Download SQL Server Recovery Manager Tool Download Now