Sunday, April 27, 2014

Reset Lost SA Password on SQL Server 2012 / 2014

Lost or forgot SA password on MS SQL Server 2012 or 2014 instance? Looking for a way to recover or reset the password? With SQL Server Password Changer you can easily reset lost SA password on all versions of  SQL Server instance, including SQL Server 2014 and 2012.

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:
  1. Click here to download and install SQL Server Password Changer on your local computer.
  2. 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 Select the SQL Server master database file
  3. The program will automatically decrypt the master database file and display all user accounts in your SQL Server database. SQL Server Password Recovery
  4. Select a user account whose password you want to change, click the Change Password button. Type a new password and click OK. Change SQL Server Password
  5. 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.
Besides resetting SQL Server 2012 / 2014 password, you can also use SQL Server Password Changer to change forgotten SA password on SQL Server 2008, 2005 and 2000.

No comments:

Post a Comment