Recover SA Password?

How to Create and Recover SA Password?

2013-01-09 12:23:56 / Posted by Michael Eric to Files & Database
Follow @MichaelEric

What is SA?

SA (abbreviation for "System Administrator") refers to the person who maintains and operates Microsoft SQL Server. When you install Microsoft SQL Server Desktop Engine, the installation uses SQL Authentication by default. In addition, the default user name in these cases is sa, and the default password is blank.

How to Secure SQL Server database with SA password?

To make your SQL Server database secured, you are requested to set SA password at the very first time. It is extremely easy to create a SA password as follow:
1. Open the SQL Server Management Studio Program from the Start menu bar.
2. Hit "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 the new SA password.

How to Reset SA password?

I frequently find that many users are confused about recovering SA password when I browse SQL forums and communities. In fact, it is very easy to crack SA password with SA Password Recovery which I experienced for a long time. How to operate it? Just follow me.
reset sa password

1

Step 1: Simply download SA Password Recovery Tool , and setup and run it. Don't worry; you don't need to install MS SQL Server at all. Just load master .mdf file by clicking on "open" and select the files on your PC.

2

Step 2: All the user names and password of your SQL Server are listed respectively. You need to highlight "sa" and hit "change password".

3

Step 3: Then a case pops up. What you need to do is to enter your new password and confirm it.

Done! You have finished resetting sa password just with 3 steps.

Download SmartKey SQL Password Recovery:

Free Trial

Size: 31.15MB

Buy Now

Only $54.95

Secure Download
90 Days Money Back Guarantee
downloadDownload this article as :  
comments powered by Disqus

NEXT TOPICS
Windows Password & Key

Recover all your Windows 8/7/vista/xp Password and fix your computer problem


Connect with SmartKey

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