If you lost SA password to login SQL Server 2000/2005/2008/2012/2014 and could not open master.mdf file, you probably will be upset about that. Not only these files are written in Structured Query Language, but also the number of item is large. As finishing a database is not an easy job, many users tend to use third-party software to solve this problem.
ISunshare SQL Password Genius is a handy password software which helps to reset SA and other users' passwords for Microsoft SQL Server database instantly. It can unlock password-protected databases master.mdf file instantly regardless of the length and complexity of the password. In addition, it can reset lost or forgotten SA password and administrator/user's password. Most importantly, it supports Microsoft SQL Server and Microsoft SQL Server Express 2014/2012/2008/2005/2000. It is clean without any annoying virus, spyware and adware. In addition，its 100% safety and high recovery rate will meet your need. Its fast speed, easy control and lower price make it better than using other ways.
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 Managerto 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
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".
And then a new window pops up with message "Password successfully changed".
You would find new password has been reset for target user account in user list.
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.