How to Unlock SQL Server
How to Unlock SQL Server SA Account
Summary: This blog provides the method to unlock SQL server SA account when you are facing the troublesome situation in accessing your SQL account.
There are chances that some of you are facing the failure of logging in to the SQL server SA account after trying multiple attempts. The following error message can be seen while logging:
“Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486)”.
There can be various reasons behind the locking of SQL server System Administrator account.
So, l have identified some of the reasons which are discussed below.
Reasons for SQL Server SA Account Locked Out
- You forgot the SA login password.
- Deactivation of SA account.
- Unintentionally removal of all the logins members of the sysadmin fixed server role.
- The elimination of all Windows Groups members of the sysadmin fixed server role unknowingly.
- The use of login members of the sysadmin fixed server role which do not exist or no more in the company.
- Enabling the option of Enforce password policy and your company has utilized account lockout after multiple login attempts.
Therefore, it is advisable that you should keep your eye on the above reasons to prevent the issue of SA account getting locked. Now, let’s move to unlock SQL server SA account.
Solution to Unlock SQL Server SA Account
1. Disable Password Enforcement Policy to Unlock SA Account
In this method use Windows Authentication to log into SQL Server Management Studio. For this, follow the below steps:
2. Use SQL Server Password Recovery Tool
There is another way to get rid of SQL server SA locked up by using the SysInfo SQL Server Password Recovery Tool. From this tool, you can reset the password in case you have lost the password or forgot the password. The free version of this tool shows you first two characters of the lost password.
I have discussed the reasons for locking out of SA account so you should keep in mind. The manual, as well as expert solution, is provided here to unlock SQL server SA account. You can choose any method wisely which suits your situation the best.