When want to login QNE Optimum, prompt error "Login failed for user 'SA' because the account is currently locked out. The system administrator can unlock it."

Created by Cheng Kah Poh, Modified on Fri, 4 Sep, 2020 at 12:41 PM by Cheng Kah Poh

When want to login QnE Optimum, prompt error below:

 

Solutions:


Step 1 -  In Server Windows>Run, type gpedit.msc


Step 2 -  Navigate to Account Lockout Policy, check is it got set security setting


Note:  If got set security setting, please ask assistance from IT person to check is it got many failed attempts to server and caused the security setting block the SQL server access already.


Step 4 -  At the same time, can run below script to the QNE's SQL instance to unlock it, please replace the password with your actual SQL instance password.

ALTER LOGIN sa WITH PASSWORD='password' UNLOCK

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article