Microsoft SQL Server sa login locked out: how to unlock/enable sa login?

Microsoft SQL Server sa login locked out error message 2

Issue: Microsoft SQL Server 'sa' login locked out
So, today, I got myself locked out of Microsoft SQL Server after entering the wrong password multiple times. If suppose “sa” login account is locked out, the above message will be displayed-

How to enable “sa” login account locked out by Microsoft SQL Server?

1. Open SQL Server Management Studio
2. In the login prompt window, instead of the SQL Authentication select “Windows Authentication”

Microsoft SQL Server sa login locked out Windows SQL authentication 2

3. Click “Connect”
4. Once in, expand the “Security” tree on the left sidebar and click on “Logins”
5. Double click “sa” or Right-click on “sa” and select properties to open the login properties window 6. In the login properties window page, select “Status” on the left sidebar
7. You should be able to see “Login is locked out” at the end of the page.
8. To re-enable the “sa” login, uncheck the “login is locked out” to disable lock.

Microsoft SQL Server sa login locked out status 2


9. Click ok
10. Disconnect from the Database engine

Test if “sa” login is able to connect after unlocking the account:
1. Open SQL Server Management Studio
2. In the login window, select “SQL authentication” as usual.
3. Enter “sa” and the password
4. You should be able to login now.


Comment with Facebook

Comments


  1. it’s ok to show some appreciation and say ‘great post’
    .NET developer

    ReplyDelete

Post a Comment