login failed for user 'sa' because the account is currently locked out. the system administrator can unlock it
If the mixed mode authentication is enabled in SQL
Server, you can log into SQL Server Management Studio with Windows
Authentication, and then unlock any SQL Server user account easily.
Step 1: Open SQL
Server Management Studio and select Windows Authentication to login.
Step 2: Go to Security
-> Logins -> sa, and double click on sa account.
Step 3: After
sa Login Properties dialog opens, select the General page,
uncheck the box besides Enforce password policy, and click OK.
Step 4:
Select the Status page, make sure the box besides Login is locked out
is unchecked. Then the SA account can be unlocked and you can successfully
connect to SQL Server with SA login.
Great article,Thank you for sharing this valuable info with us.
ReplyDeleteKeep updating...
MSBI Training