Reset SA Password in SQL Server 2012

How to Reset SA Password in SQL Server 2012

Security and privacy have become more and more important in this open world. By default, the MS SQL Server SA password is blank (NULL) which is unsecure. Thus, setting password for almost everything becomes a trend. You may also have set a SA password for your SQL Server 2012. But one day, you find that you forget the SA password and have to reset SA password in SQL Server 2012. Then how to do that?

Here in the following paragraphs, I will show you how to set SA password in SQL Server 2012 and several methods about how to change SA password in SQL Server 2012 if you forgot.

How to set SA password in SQL Server 2012?

You are requested to set SA password at the very first time you use SQL Server 2012. If you have not set one at that time, then the SA password is blank, which is called default SA password SQL server 2012. If you want to set a SA password for it now, then follow the steps below:

• 1. Open the SQL Server Management Studio Program from the Start menu bar.
• 2. Click "SQL Server" and right-click "security folder">-"New">-"Login".

  

• 3. Enter the name you like and select "SQL Server Authentication", and then type a password.
• 4. It is recommend to select "enforcing password policy" when you are requested to select the password policy.
• 5. Click "OK" to finish the creation of new SA password.

How to reset SA password in SQL Server 2012 with SQL Password Recovery?

If you are a new user of SQL Server, we recommend an easy way to recover SA password SQL Server 2012--SQL Server Password Recovery. It is smart and easy to use. Only with a few clicks, you can reset SA Password SQL Server 2012 without any data loss.

Download a Free Trial Version of SQL Password Recovery and have a try.

Download SmartKey SQL Password Recovery:

Install and launch the software on your PC. Then follow the easy steps to change SA password SQL Server 2008 R2:

• Step1. Click Open to load master.mdf file to this software.
  Note: the default master.mdf file location is as follows:

  C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER08\MSSQL\DATA

  

• Step2. Select SA Account and click "Change Password".

  

• Step3. Enter a new password for your SA account and then click "OK".

  

Now you can use your new SA password to enter SQL Server 2012.

Next time when you forgot SQL Server 2012 SA password, you needn't be panic. With the aid of SQL Password Recovery, you can recover SA password SQL Server 2012 safely and easily.

Download SmartKey SQL Password Recovery:

comments powered by Disqus