How do I unlock a SQL Server database?

How do I unlock a SQL database?

Option 1: Unlock SA Account in Management Studio1Login into SQL Server using Windows Authentication.2In Object Explorer, open Security folder, open Logins folder. Right click on SA account and go to Properties.3In the Login Properties window, uncheck the box beside Login is locked out and click OK.2 Methods to Unlock SQL Server SA Account When It's Locked Out

How do I unlock a database?

Click Databases > Database Details List (or Database List) Left-click the gray rectangle on the left side of your database name to select the database. Right-click the same gray rectangle and choose Unlock database. Click OK on the confirmation prompt.

How do I unlock a SQL Server account?

Open Server Management Studio, connect to the server and go to the Security --> Logins item in Object Explorer. Select the login that is locked out and double-click on it. The Status page should let you re-enable the login (uncheck the "Login is locked out" box).

Why is SQL Server account locked out?

If a SQL Server login is configured to use password policy enforcement and your organization uses account lockout after a certain number of failed logins, you can end up locking out a SQL Server login via the same scenario. This can result in the account being locked out.