A few days ago, I had a painful exprience that I
lost sa password on my
MS SQL Server database, and I almost took the whole weekend to look for some efficient
SA password recovery solutions. I asked friends, searched on Internet and even bought some books... Fortunately, I finally got
MS SQL Server Password Unlocker and it instantly changed the SA password but no data loss. Besides, I also got a couple of good "
recover SA password" solutions in order to save your weekend in case you have lost or
forgot MS SQL Server passwords (SA password!)
Option 1 : Use MS SQL Server Password Unlocker to Change SA Password
...
The sa account has full rights in the MS SQL Sever environment. When you install the MS SQL Server program, the sa account is created and sa password is default blank (NULL). You can also change the blank sa password to a strong one when the setup program is running.
How to verify if the SA password is blank
1 On the computer that is hosting the instance of MSDE to which you are connecting, open a command prompt window.
2 At the command prompt, type the following command, and then press ENTER:
osql -U sa
This connects you to the local, default instance of MSDE by using the sa account. To connect to a named instance installed on your computer type:
osql -U sa -S servername\instancename
You are now at the following prompt:
Password:...
How to change your system administration password if you forget your SQL password?
Look, there are so many similar questions:
How to
reset sa password ?
"How to
change SQL password without data loss?"
"I've
forgotten the sa password for SQL Server - what can I do?"
"How to
Change SA Password If Forgot or Lost SQL Password?"
...
...
