Reset SA Password in SQL Server 2012

How to Reset SA Password in SQL Server 2012

2013-05-29 04:38:12 / 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:

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:

Size: 31.15MB
Only $54.95
Secure Download
90 Days Money Back Guarantee
comments powered by Disqus
About Us
SmartKey is the world's leading software company and pioneer in password decryption and data recovery technologies on Windows and Mac platforms.

Learn More >>

Hot Products
Hot Articles
Domain Password Reset Bypassing Administrator Password Crack Admin Password Forgot Login for Win Server Microsoft Word Password Breaker Advanced RAR Password Recovery Forgotten Excel Password How to Crack Win 7 Password Forgotten Windows 7 Password Windows 7 Password Unlocker
Follow Us

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