The SA password in MS SQL Server 2008 R2 can be easily lost for different reasons. For example, the person who knows the password resigned and didn't tell you the password, you forgot the password temporarily and urgent to use your server, etc. In this article, you'll learn how to recover sa password in SQL Server 2008 R2 in seconds. This method is useful when you cannot login or connect to your Server.
Before getting started, you need to download and MS SQL Server Password Unlocker in any Windows-based computer. MS SQL Server Password Unlocker is professional designed to you change SQL Server SA password and other user account passwords to a new one in seconds by modifying the master.mdf file. After that, take the steps below to begin.
Step 1. Launch MS SQL Server Password Unlocker, and click Open button to import the master.mdf file of the serve you'd like to reset sa password for.
Note: You can copy and paste the master.mdf in the computer if the SQL server is not installed in it.
Step 2. All the user names of your MS SQL Server will be displayed. Select the SA account and then click Change Password button.
Step 3. Enter your new password and click OK. Your SA password will be changed in seconds.
Step 4. Log into the sa account with the new password.