Reset SA Password in SQL Server 2012

How to Reset SA Password in SQL Server 2012

May. 29, 2013 04:38 pm / Posted by Michael Eric to Files & Database
Follow @MichaelEric

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

    SQL Server 2012 reset SA password

  • 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:

Free Trial

Size: 31.15MB

Secure Download

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

    SQ server 2012 change SA password

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

    SQL Server 2012 forgot SA password

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

    SQL server 2012 reset SA password

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:

Free Trial

Size: 31.15MB

Buy Now

Only $54.95

Secure Download
90 Days Money Back Guarantee
comments powered by Disqus
About Us
SmartKey is the world's expert password recovery team. For the past 8 years we have helped about 20,000,000 customers get back their password.

Learn More >>

NEW Products
RAR Password Recovery 5.0
Windows Password Recovery
Word Password Recovery
Excel Password Recovery
Zip Password Recovery
Password Recovery Bundle
Windows 8 Password Reset Forgot Password Windows 7 Excel 2003 Password Recovery Hack Yahoo Password Password Protect Word 2010 Bypass Administrator Password Hack Facebook Password Crack Windows 7 Password Office 2013 Product Key finder

Copyright©2007-2015 SmartKey Password Recovery. All rights Reserved.