Tip & How-To about Computers & Internet

Reset sql sa password directly and efficiently

A few days ago, I had a painful experience that I lost SA password on my MS SQL Server database, and I almost took the whole weekend to look for an efficient way to reset SA password. I asked friends, searched on Internet and even bought some book.... Fortunately, I finally got a SQL server password recovery software and it instantly reset SA password without data loss. And I also got a couple of good solutions for sql sa password reset 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 Recover/Reset SA Password

The most direct, efficient way to reset SA password is to take use of the third part utility - SQL server password recovery software. Just two steps:

Step 1: Access to master.mdf file, which is default at C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf

Step 2: Select SA password and reset SA password
So, Reset SA password successfully!



Option 2 : Recover or Reset SA Password with Other SQL Server Login
If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account and reset SA password of SQL Server. Reset sql sa password as described here :

SQL SERVER - Reset Password of SA Login Using Management Studio.

Login into SQL Server using Windows Authentication.

In Object Explorer, open Security folder, open Logins folder. Right Click on
SA account and go to Properties.

Reset SA password, and confirm it. Click OK.

Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.



Option 3 : Recover or Reset SA Password with Windows Login that is a member of Windows Admin Group

If there is any other Windows Login that is a member of Windows Admin Group, log in using that account. Start SQL Server in Single User Mode as described followings :

SQL SERVER - Start SQL Server Instance in Single User Mode.

There are certain situation when user wants to start SQL Server Engine in "single user" mode from the start up.

To start SQL Server in single user mode is very simple procedure as displayed below.

Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on desired SQL Server instance and right click go to properties. On the Advance table enter param '-m;' before existing params in Startup Parameters box.

Make sure that you entered semi-comma after -m. Once that is completed, restart SQL Server services to take this in effect. Once this is done, now you will be only able to connect SQL Server using sqlcmd.

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

3 Answers

Forgot SQL Server SA password. How to reset user password to login SQL Server?


When SA password for SQL Server logon forgot, please take SQL Password Genius to install it on computer.

Step 1: Run SQL Password Genius full version and browse Master.mdf file to import into it.

Step 2: Select SA user and click "Reset" button.
After master database file imported into SQL Password Genius, you would see all user in list. SA password is unknown. Select SA account and click "Reset" button.

A new window would pop up, type new password for SA account in it. And click "OK". Instantly, SA password is changed successfully. SA password lists in software screen.

Step 3: Close SQL Password Genius and restart SQL Server Services.

SQL Server services influence SQL password reset on computer. So we stop it before using SQL Password Genius. Now, when you finish SQL SA password reset, restart SQL Server Services to run SQL Server with SA account.

How to Reset SA and Other User Passwords for SQL Server

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

Not finding what you are looking for?

298 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...