Home > Resources > SQL Password > Reset SQL Server Password

How to Reset SA and Other User Passwords for SQL Server

Lost SA password to login SQL Server 2005/2008/2012/2014/2016 and couldn't open master.mdf file? How to reset SQL SA and other users' passwords? Please get effective iSunshare SQL Password Genius to help reset or change SQL Server user password.

Guide: Reset SQL Server User Password Step by Step

With this guidance, you can easily learn to reset SQL Server password for SA and other users, and open *.mdf file in SQL Server successfully.

Tips: Please stop SQL Server services before SQL Server password reset with SQL Password Genius.

Point to Start - All Programs - Microsoft SQL Server - Configuration Tools - SQL Server Configuration Manager to stop it.

Step 1: Download and install SQL Password Genius on your computer.

Step 2: Run it and import password-protected master.mdf file.

Click "Open File" button, and browse encrypted SQL Server primary data file (*.mdf file) on computer. Choose it and click "Open" to import it into iSunshare SQL password reset tool. And then database file would shown in "Open File" box.

Tips: Typically master.mdf file is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

import password protected SQL Serve Master *.mdf file

Step 3: Select target user account in user list.

After importing SQL Server database file into SQL Password Genius, all user accounts available for MDF file are listed in user list. Select the user used to login SQL Server and open *.mdf file. For example, select SA account, which is used to manage *.mdf file generally.

Step 4: Reset SQL Server database SA or other user password.

After you select target user account, click "Reset" button. Instantly a dialog pops up. Type new password for selected user account and click "OK".

reset SQL Server user password

And then a new window pops up with message "Password successfully changed".

successfully reset SQl password

You would find new password has been reset for target user account in user list.

SQL Server user reset with new password successfully

Now you can login SQL Server database with this user account and new password. But please close SQL Password Genius and start "SQL Server Services" in SQL Server Configuration Manager first.

What's the Next?

Now it's your time to try it. Don't hesitate and go ahead to download iSunshare SQL Password Genius.

windows password recovery professional free download

Related Articles:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +