PCVITA software to reset the SQL Server sa and user password from master.mdf
MDF Password Recovery Tool
PCVITA MDF Password Recovery Tool resets the SQL Server sa and user passwords by loading the master.mdf file, so you log in again with a new password of your choice. Microsoft documents a single user mode route that needs commands and an instance restart and PCVITA software replaces that with a Reset Password button. MDF password recovery needs no SQL Server installation on your PC. Free demo previews every login ID with its password status.
- Input
- master.mdf file of SQL Server
- Result
- New password for the sa or user login
- Handles
- Passwords of any length, type or language
- Works with
- SQL Server 2017 to 2000 on Windows 10 to 7
Load master.mdf, select the login and type a new password inside the software, without SQL Server on the PC. See all features. Corrupt MDF file? Open the SQL Database Recovery Tool instead.
How to Reset SQL Server sa and User Passwords
Load master.mdf, select a login and set a new password. Your SQL Server login works again after the reset.
master.mdf of SQL Server
SQL Server 2017 back to 2000
- sa or user password lost or unknown
- Copy of master.mdf saved first
- SQL Server stopped on the PC
PCVITA MDF Password Recovery
Windows software for SQL Server logins
- Browse and Open master.mdf
- Unknown or Empty status for every login
- Backup prompt for the master files
Login With a New Password
SQL Server accepts the password you set
- Both login types reset
- New password typed in the software
- Success message ends the job
- 1AddBrowse to the database file and click Open.
- 2SelectCheck the password status and select the login.
- 3ResetBack up the files, type the new password and confirm.
Reset SQL Server Password in 6 Steps
Six screens from the first click to the new login. Click a step to view its screen or open the Software Guide for every screen.
Step 1. Install and Start the Software
Download PCVITA software and install it. Right click the program and select Run as Administrator. Stop the SQL Server services before you start.
Step 2. Add the master.mdf File
Click Browse to add the master database file. Locate master.mdf in the dialog and click Open.
Step 3. Select the Login to Reset
A Scanning completed Successfully message appears, so click OK. PCVITA software lists all SQL Server users. Unknown means a password is set on an encrypted database and Empty means the login has no password. Select the user and click Reset Password.
Step 4. Back Up the master Files
PCVITA software prompts you to back up master.mdf and master.ldf. Make the copies and click OK.
Step 5. Type the New Password
Enter the new password in the Reset Password window, confirm it and click OK.
Step 6. Confirm and Log In
A password reset successfully message appears when the job ends. Open SQL Server and enter the new password you set.
Free demo, no payment to preview your login list.
SQL Password Recovery Software Features
Four groups of options for locked SQL Server logins.
Loads master.mdf and Scans the File
Browse to the master database file and let PCVITA software list the logins stored inside it.
Browse and Open
Browse adds master.mdf to the software and Open starts the scan of the file.
Scan Confirmation
A Scanning completed Successfully message confirms the load and OK shows the user list.
No SQL Server Needed
Reset the password on a PC with no SQL Server on it.
Run as Administrator
Windows 10 and lower versions need the Run as Administrator option.
Shows Every Login and Its Password Status
Check which accounts hold a password before you reset anything.
All SQL Server Users
MDF password recovery software loads every user name found in master.mdf.
Unknown Status
Unknown marks a password set on an encrypted database.
Empty Status
Empty means the user name has no password, so the login works without one.
Selective Reset
Select one account or check the boxes to reset all user accounts.
Resets Both Login Types With a Backup Prompt
Set a new password inside the software and keep copies of the master files first.
sa and User Logins
Both the System Administrator password and user passwords reset from MDF.
Any Length or Type
Long passwords, special characters and multilingual passwords reset the same way.
New Password Inside the Software
Type and confirm the new password with no T-SQL commands.
Backup Prompt
A prompt asks for copies of both master files before the reset starts.
Confirms the Reset and Lets You Connect
A success message ends the job and the new password opens SQL Server.
Success Message
Password reset successfully message confirms that the login has a new password.
Log In Again
Connect to SQL Server using the password you typed in the software.
SQL Server 2017 Back to 2000
Supported files come from SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000.
Healthy MDF Files Only
Passwords reset from a healthy MDF file, so a damaged file needs repair first.
Preview your own logins first. Full edition resets the password.
Why SQL Server Logins Live in the Master Database
Four Microsoft facts and how PCVITA software answers them.
- 1
Master Database Records Logon Accounts
Microsoft says master records system level information, including logon accounts. PCVITA software loads master.mdf, so you reach those logins in one list.
- 2
SQL Server Cannot Start Without Master
Microsoft says SQL Server cannot start if the master database is unavailable. PCVITA software prompts you for copies of both master files before the reset starts.
- 3
Microsoft Advises a Current Backup
Microsoft advises a current master backup and a new one after you modify logon accounts. Save the copies when the prompt appears and back up master again once the new password works.
- 4
Lockouts Need Single User Mode
Microsoft lists an sa account with a disabled or unknown password as a lockout case. Its fix restarts the instance in single user mode and PCVITA software gives you a window route instead.
Prepare Before You Reset the SQL Password
Seven checks before the first reset. Tick them off before you start.
- Copy master.mdf and its log file to a separate folder and add the copy to the software. Your original files stay safe.
- Stop the services of SQL Server before you start the software and keep them stopped during the job.
- Select Run as Administrator when you open the software on Windows 10 and lower.
- Install Microsoft .NET Framework 2.0 or a later version.
- Check the system for 50 MB free disk space, 2 GB RAM and a 1 GHz Intel Pentium processor or equivalent.
- Check that master.mdf is healthy. PCVITA software resets passwords from healthy files only.
- Preview your logins in the free demo before you buy. Download the MDF Password Recovery demo and check the Password column.
System lines match the Specifications table below and the master database lines come from the Microsoft pages under Sources.
MDF Password Recovery Pricing
Free demo first, then one licence. Demo previews the logins and full edition resets the password.
Demo Edition
Free
See which SQL logins hold a password
- Login ID previewShown
- Password statusShown
- Password resetFull edition only
Version 5.0, 2.7 MB, Windows
Full Edition
$69 one licence
Reset the sa and user passwords of master.mdf
- Login ID previewShown
- Password resetIncluded
- DeliveryElectronic delivery
30 Days Money Back*, Safe & Secure checkout
Included in the full edition Everything the free demo shows, plus the password reset
- Reset sa Password From master.mdf
- Reset User Account Passwords
- Set the New Password in the Software
- Password Status for Every Login
- Multilingual Password Support
- Backup Prompt Before the Reset
- No SQL Server Installation Needed
- Windows 10 to 7 Support
SQL Password Recovery Specifications
Version, system needs and SQL Server support in one place.
| Version | 5.0 |
|---|---|
| File size | 2.7 MB |
| Windows versions | Windows 10, 8.1, 8 and 7 (32 bit and 64 bit), Windows Server 2008, 2012 and 2016 |
| Hardware | Intel Pentium 1 GHz processor (x86, x64) or equivalent, 2 GB RAM minimum, 50 MB free hard disk space |
| Framework | Microsoft .NET Framework 2.0 or later |
| Free demo limit | Previews the login ID and password status, resets no password |
| Delivery | Electronic delivery after payment |
| Input file | master.mdf of SQL Server, healthy file |
|---|---|
| SQL Server versions | SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000 |
| Accounts | sa and user logins |
| Passwords | Any length or type, special characters and multilingual |
| Password status | Unknown (encrypted database password) or Empty (no password) |
| Before the reset | SQL Server services stopped, administrator rights on Windows |
| SQL Server installation | Not needed |
SQL Server Single User Mode vs MDF Password Recovery
Microsoft documents one way back into a locked instance. Here is how that route compares with PCVITA software, so you can decide which fits your server.
| Point | Microsoft Single User Mode | PCVITA Tool |
|---|---|---|
| Who can start | Member of the local Administrators group | Anyone who holds master.mdf and has administrator rights on the PC |
| Method | Restart the instance with the -m option, then run T-SQL | Browse, select the login, click Reset Password |
| Services | Stop SQL Server Agent so it cannot take the only connection | SQL Server services stay stopped while the software works |
| SQL Server on the PC | Needs a running instance to restart | Not needed |
| Status check | No password status list | Unknown or Empty shown for every login |
| sa password | ALTER LOGIN sa with a new password, in mixed authentication mode | New password typed in the software |
| Price | Part of SQL Server at no extra cost | Free demo, $69 full edition |
Microsoft facts come from the two Microsoft Learn pages listed in the Sources. Software facts match the Features and Specifications sections above.
Checks Before Resetting a SQL Server Password
- PCVITA software resets passwords from a healthy master.mdf only, so a damaged file needs the SQL Database Recovery Tool first.
- Services of SQL Server must stay stopped while the software works.
- Copy both master files first. Microsoft advises a current master backup at all times.
- Unknown flags a login that holds a password. Empty flags a login with none.
- Microsoft advises a strong password when you reset sa, so choose one before you type it.
Open the Software Guide for every screen.
Sources for SQL Server Password Facts Microsoft pages behind the facts above
- Microsoft LearnConnect to SQL Server when system administrators are locked out
- Microsoft LearnMaster database
MDF Password Recovery FAQs
Answers to the questions users ask before and during a SQL Server password reset, grouped by topic.
Reset and Limits How the software behaves on master.mdf
How to reset SQL Server sa password from master.mdf?
Six steps reset the sa or user password in the Windows software.
- Step 1. Install PCVITA software and start it with Run as Administrator.
- Step 2. Click Browse, locate master.mdf and click Open.
- Step 3. Click OK on the scan message and select the login.
- Step 4. Click Reset Password and back up the master files.
- Step 5. Choose the password you want, confirm it and click OK.
- Step 6. Open SQL Server and enter the new password.
Can I reset the sa password without SQL Server installed?
Yes. PCVITA software resets the sa password on a PC with no SQL Server on it. PCVITA software works on the file you add, so no instance has to be active.
Should I back up master.mdf before the reset?
Yes. Copy master.mdf, then add the copy to the software instead of the original. PCVITA software also prompts for backups before it resets the password.
What do Unknown and Empty mean in the Password column?
Unknown means a password is set on an encrypted database. Empty means the user name has no password, so that login works without one. Free demo shows the same status for every login.
Can I open or view an MDF file with PCVITA software?
No. MDF Password Recovery loads master.mdf to list logins and reset their passwords, so it is not an MDF viewer. Attach the file to a SQL Server instance to open it.
Can the software reset a corrupted MDF file password?
No. MDF Password Recovery resets SQL Server passwords from a healthy MDF file only. Repair a corrupt database file with the SQL Database Recovery Tool and reset the password afterward.
Can the software reset multilingual or special character passwords?
Yes. PCVITA software resets passwords of any length and type, including multilingual passwords and passwords with special characters. Select the user, click Reset Password and set a new one.
Does Microsoft offer a way back in when sa is locked?
Yes. Microsoft documents single user mode. You start the instance with the -m option, connect as a member of the local Administrators group and fix the login with T-SQL. PCVITA software gives you a window route that works on master.mdf.
Demo and Cost What the demo previews and what the licence costs
What does the free demo show?
It previews your logins. Free demo adds master.mdf and shows the login ID and password status of every user. Password reset needs the full edition.
How much does MDF Password Recovery cost?
$69. Full edition resets passwords of sa and user accounts, comes with a 30 day money back guarantee and arrives by electronic delivery after payment.
Versions and System SQL Server, Windows, hardware, services and other password tools
Which SQL Server versions does the SQL password recovery tool support?
SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000. PCVITA software resets sa and user logins found in master.mdf of these versions.
Which Windows versions work with the software?
Windows 10, 8.1, 8 and 7 in 32 bit and 64 bit, plus Windows Server 2008, 2012 and 2016. Right click the software and select Run as Administrator.
What system needs does the software have?
50 MB free disk space, 2 GB RAM and a 1 GHz Intel Pentium processor or equivalent. Microsoft .NET Framework 2.0 or a later version must be installed on the PC.
Do I stop the SQL Server services before the reset?
Yes. Stop the services of SQL Server before you start PCVITA software and keep them stopped during the job. Start them again after the success message.
Does the tool reset Access database or PST file passwords?
No. MDF Password Recovery works on master.mdf of SQL Server. Locked Access files need Access Database Password Recovery and locked Outlook files need PST Password Recovery.
Question not answered here? Ask on Live Chat or write to us from the Contact Us page.
What Customers Say About MDF Password Recovery
Ratings collected on pcvita.com and what customers wrote after their SQL Server password reset.
In order to remove and reset SQL Server sa password on my Windows 10 operating system, I used this SQL Password Reset tool. It scanned the MDF file and loaded all its user login details in software. I just need to select the username which I want to reset and password resetting process get completed in just a few minutes. Thus, without any doubt, I can title this software as the best SQL MDF file Password Recovery tool.
Recover and rest SQL Server Password was a very complex task for me. However, after utilizing this amazing software I can say that any user can operate this even without much technical expertise. The user-interface of SQL MDF Password Recovery is simple. All users out there who want to reset their SQL Database file passwords must use this. Thank you, team!

Software Informer: experts tested PCVITA MDF Password Recovery and called it a 100% secure tool. More badges sit on the awards page.
Key Takeaways on SQL Password Reset
The short version.
- Reset from master.mdf: PCVITA software resets both login types and lets you type a new password.
- Microsoft route: single user mode needs an instance restart and T-SQL and the software uses buttons instead.
- No server needed: the reset works on a PC without SQL Server installed.
- Before you start: stop the SQL Server services and copy the master files.
- Demo and price: free demo previews login IDs and password status and the full edition costs $69.
Preview Your SQL Server Logins in the Free Demo
Download the demo, add master.mdf and check the password status of every login before you buy the full edition.
Safe & Secure · 30 Days Money Back*