By Hally | Last Updated
Probably many SQL Server users have such doubts:
While SA account is disabled, and there is no administrator rights to SQL Server instance, how to reset or recover SA account password, and then login SQL Server with SA successfully?
From the description above, the key problems should be how to enable SA account and reset SA password. If you sort them in two parts, they have been talked in other two articles separately. If you want to solve them together, just refer to method in this passage and try them.
Tips: Before enabling SA account and reset SA password, please confirm that Mixed Authentication mode is available. If not, refer to four ways to enable Mixed Mode Authentication.
1. Launch SQL Server Configuration Manager and stop SQL Server services.
Navigate to Start - All Programs - Microsoft SQL Server - Configuration Tools - SQL Server Configuration Manager to stop SQL Server services.
2. Right-click SQL Server instance and choose Properties.
3. Enter "-m" into the Start parameters field.
4. Save changes and restart SQL Server services. Start SQL Server in single-user mode.
About all operation above, you can refer to article how to set SQL Server access in single-user mode.
5. Open a Command Prompt and enter the command to connect to SQL Server instance.
Tips: Be sure to change PC_NAME to whatever your PC name is. Replace SQLEXPRESS with the name of your SQL Server instance or you will get a big long message saying you messed up.
There are two choices for you to reset SA password after you enable SA account in this step. Command or SQL password recovery tool, no matter with which one, you can reset SA account password for SQL Server 2014/2012/2008/2005.
If you want to reset SQL SA password with command, just follow the command in step 1 for enabling SA account. And type command below to do later:
Then stop SQL Server services and remove "-m" from the "Start parameters" field. Start SQL Server services at last before you login SQL Server with SA account and new password.
If you don't want to enable SA account or reset SQL SA password with command, third-party tool would be your better choice. With user-friendly interface on SQL password recovery tool, such as iSunshare SQL Password Genius, you could just need to click several buttons on SQL Password Genius and disabled SA account password would be successfully reset.
1. Stop SQL Server services and install SQL Password Genius on computer.
Tips: SQL Password Genius trial version just could add SQL Server database and list users for database, but could not reset database user password.
2. Tap Open File button on SQL Password Genius. Browse computer to locate master.mdf file, and select it to add to SQL Password Genius.
MDF file usual location: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
3. Select SA account in user list after SQL database file import. Click Reset button and set new password for SA account in pop-up dialog. Instantly, you would get message about successfully changing SA password, and it will show in user list.
4. Remove "-m" from Start parameters field.
5. The last but not the least, start SQL Server services and login SQL Server with SA account and new password.
Probably it seems to be more difficult than resetting SA password with command because of several steps above. But if you realize that SQL Password Genius could be used by everyone to easily reset forgotten or lost SA password no matter when, you would like to try it especially when you cannot sure which way is better for SQL SA password reset.
Related Articles: