Process to Know How to Recover SQL Server Password

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

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

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

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

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.

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

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

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

Start SQL Server and connect to the database.