How to Unlock SQL Server SA Account When Locked Out

Ralph Adolphs

Updated: January 11, 2024

After multiple failed login attempts, your SQL Server SA account becomes locked with error 18486: "Login failed - account currently locked out." Discover professional solutions to regain administrative access.

SQL Server enforces password policies by default, locking accounts after repeated failed attempts. This guide details two verified methods to unlock SQL Server SA accounts across versions 2008-2016+ while maintaining system security.

• Method 1: by resetting sa password
• Method 2: by removing password enforcement

Method 1: Reset SQL Server SA Password to Unlock Account

Step 1: Install SQL Password Refixer on your local machine

Step 2: Stop SQL Server services through Configuration Manager

Step 3: Launch SQL Password Refixer with administrator privileges

Step 4: Select Open File and locate the master.mdf database file

Note: Default path: C:/Program Files/Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\master.mdf

Step 5: Identify the locked SA account in the user list and click Reset Password

Step 6: Create a strong new password meeting complexity requirements

Step 7: Confirm successful password reset notification appears

Step 8: Close the password recovery tool securely

Step 9: Restart SQL Server services to apply changes

Method 2: Disable Password Policy to Unlock SA Account

Prerequisite: Requires Windows Authentication access to SQL Server

Step 1: Connect via SSMS using Windows Authentication credentials

Step 2: Navigate to Security → Logins → SA properties

Step 3: Under General settings, disable Enforce password policy

Step 4: In Status settings, uncheck Login is locked out

Important: Some environments automatically unlock accounts after 15-30 minutes. Monitor login attempts before retrying.