How to Reset Lost SA Password on SQL Server 2012 / 2014?
Before getting started, you need to stop your SQL Server instance so we can then reset your lost SA password offline, by following these steps:
- Click here to download and install SQL Server Password Changer on your local computer.
- Start the program and click the Open File button. Select the master database file (master.mdf) for your SQL Server instance. Typically it is located in the folder:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
- The program will automatically decrypt the master database file and display all user accounts in your SQL Server database.
- Select a user account whose password you want to change, click the Change Password button. Type a new password and click OK.
- The old password will be replaced with your new password. Now start your SQL Server instance and you can then connect to your SQL Server database with your new password.