[Optimum] Login failed for user 'SA' because the account is currently locked out. The system administrator can unlock it.

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."

Answer:

The error message:

Solutions:

--------------------

1) In Server Windows>Run, type gpedit.msc

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

3) 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.

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='QnE123!@#' UNLOCK