Microsoft SQL Server sa login locked out: how to unlock/enable sa login?
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”
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.
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.
No comments