Skip to main content

Free demo previews login IDs and password status. Full edition resets the password.

PCVITA Logo

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.

3.8 / 5Rating from 254 reviews
Admin and UserLogins the software resets
Unknown or EmptyStatus the free demo previews
Since 2007Software for corporate needs
30 DaysMoney back guarantee*

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.

Source

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
Reset

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
Result

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
  1. 1
    AddBrowse to the database file and click Open.
  2. 2
    SelectCheck the password status and select the login.
  3. 3
    ResetBack 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.

Main screen of the SQL password reset software after the start

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.

Open dialog with the master.mdf database file selected

Step 2. Add the master.mdf File

Click Browse to add the master database file. Locate master.mdf in the dialog and click Open.

User list with the Password column showing Unknown or Empty and the Reset Password button

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.

Backup prompt for the master database files before the reset

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.

Reset Password window with the new password and confirm password fields

Step 5. Type the New Password

Enter the new password in the Reset Password window, confirm it and click OK.

Password reset successfully message after the SQL Server password reset

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.

Check your SQL logins in the free demo

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.

Browse button that adds the master.mdf database file
Browse button for adding master.mdf

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.

User list with the Password column showing Unknown or Empty and the Reset Password button
User list with the password status of every login

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.

Backup prompt for the master database files before the reset
Backup prompt that appears before the password reset

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.

SQL Server login window opened after the reset
SQL Server login window after the reset
Download Now Buy the full edition for $69

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. 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. 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. 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. 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.

  1. Copy master.mdf and its log file to a separate folder and add the copy to the software. Your original files stay safe.
  2. Stop the services of SQL Server before you start the software and keep them stopped during the job.
  3. Select Run as Administrator when you open the software on Windows 10 and lower.
  4. Install Microsoft .NET Framework 2.0 or a later version.
  5. Check the system for 50 MB free disk space, 2 GB RAM and a 1 GHz Intel Pentium processor or equivalent.
  6. Check that master.mdf is healthy. PCVITA software resets passwords from healthy files only.
  7. 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
Download Now

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
Buy Now

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.

Software Version, Windows and hardware needs
Version5.0
File size2.7 MB
Windows versionsWindows 10, 8.1, 8 and 7 (32 bit and 64 bit), Windows Server 2008, 2012 and 2016
HardwareIntel Pentium 1 GHz processor (x86, x64) or equivalent, 2 GB RAM minimum, 50 MB free hard disk space
FrameworkMicrosoft .NET Framework 2.0 or later
Free demo limitPreviews the login ID and password status, resets no password
DeliveryElectronic delivery after payment
Password Reset What goes in, what comes out and the limits
Input filemaster.mdf of SQL Server, healthy file
SQL Server versionsSQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000
Accountssa and user logins
PasswordsAny length or type, special characters and multilingual
Password statusUnknown (encrypted database password) or Empty (no password)
Before the resetSQL Server services stopped, administrator rights on Windows
SQL Server installationNot 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.

PointMicrosoft Single User ModePCVITA Tool
Who can startMember of the local Administrators groupAnyone who holds master.mdf and has administrator rights on the PC
MethodRestart the instance with the -m option, then run T-SQLBrowse, select the login, click Reset Password
ServicesStop SQL Server Agent so it cannot take the only connectionSQL Server services stay stopped while the software works
SQL Server on the PCNeeds a running instance to restartNot needed
Status checkNo password status listUnknown or Empty shown for every login
sa passwordALTER LOGIN sa with a new password, in mixed authentication modeNew password typed in the software
PricePart of SQL Server at no extra costFree 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

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.

  1. Step 1. Install PCVITA software and start it with Run as Administrator.
  2. Step 2. Click Browse, locate master.mdf and click Open.
  3. Step 3. Click OK on the scan message and select the login.
  4. Step 4. Click Reset Password and back up the master files.
  5. Step 5. Choose the password you want, confirm it and click OK.
  6. 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.

Overall rating

3.8

254 ratings

5 star50%
4 star11%
3 star11%
2 star20%
1 star6%
Read all reviews

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.

Jack G. Lee, United States

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!

Arne Jakobsen, Greenland
Software Informer expert rating badge

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*

Free demo previews the password status of your SQL logins.

Download Now Buy Now