Microsoft SQL Server sa login is locked out

When too many failed attempts to login to the SQL Server 'sa' login account have been made, this account can get locked out. To unlock the account the following steps must be performed:

1. Open SQL Server Management Studio, and login using Windows integrated security.
2. Open a query window and run the following command:

ALTER LOGIN sa WITH PASSWORD = 'password' UNLOCK


To ensure the 'sa' account cannot be locked out again performthe following steps:

1. Expand the SQL Server node.
2. Expand the Security node.
3. Open the sa account properties under the security node.
4. Uncheck: Enforce password policy.
5. Click 'Ok' to save the changes.

 







Return to all articles