I constantly hear people complain that: "Oh, no, I forgot my SQL SA password. What should I do?" Have you ever encountered the same situation? You forgot SQL SA password and have to reinstall the SQL Server after several failed trial? Don't be shy to tell, this situation is very common especially to people who have a lot of accounts and a lot of password to remember. No matter for what reason you forgot SQL Server SA password, this article will demonstrate changing SQL SA Password without reinstalling the SQL Server.
SQL is short for Structured Query Language and it is a standardized query language for accessing and manipulating information from a database.
SA is the abbreviation for "System Administrator". And SA user is the administrative login for MS SQL Server.
MS SQL SA password is blank by default. That means if you have not change the password when you use SAL server the first time, then the SQL SA password is blank. But usually, we change the SQL SA password and create a complicated and strong one the moment we open SQL Server. Then, you forgot MS SQL SA password either for a long time or mixing up with other complicated passwords.
Here I will just introduce to you two easiest ways to reset your forgotten SQL SA password.
Don't want to bother the great trouble resetting forgotten SQL SA password yourself? Then why not try third party software. Using a third party software to recover lost or forgotten MS SQL SA password is the most easiest and effective way, especially for green hands in computer.
Here I highly recommend SmartKey SQL Password Recovery. It is easy-to-use software designed to reset lost or forgotten user and administrator password for MS SQL server 2012/2008(R2)/2005. You even don't need to install SQL at all to performance SQL password recovery, just import master.mdf file.
So why not have a try? Haven't download yet? Here to download first.
Download SmartKey SQL Password Recovery:
Now let's start the travel of recovering your forgotten SQL SA password by only a few clicks away.
You can now use your newly reset SQL SA password to login into the locked SQL Server.
If you are confident enough that you can recover forgotten SA password in SQL Server all by yourselves, then you can try this option: to reset forgotten SQL SA password using SSMS.
SSMS (SQL Server Management Studio) is the own database management tool of MS SQL Server. Here are steps to reset SQL SA password by using SSAM:
Now, you have got your SQL SA password back. And you can use it to enter your SQL Server.
Download SmartKey SQL Password Recovery:comments powered by Disqus