Admin user is locked out

Overview

This article explains how to unlock the administrator account once it is locked out.

Solution 

Please follow the steps below to resolve the issue:

  1. Open SQL Server Management Studio.
  2. Open your company database.
  3. Run the following query to list all user accounts:
    SELECT *
    FROM   personal;
    
  4. Note the idno value for the administrator account.
  5. Reset the password for the admin account. This will ensure that you will be able to log in:
    UPDATE personal
    SET    seccode = '{yournewpass}'
    WHERE  idno = '{idno}'; 
    
    Replace {yournewpass} with your desired new password, and {idno} with the ID you noted in Step 4.
  6. Clear the lock from the admin account:
    UPDATE account_status
    SET    fail_times = 0, locked = 0
    WHERE  personal_idno = '{idno}';
    
    Replace {idno} with the ID you noted in Step 4.
Note: Non-admin users can be unlocked from the UI by following the steps outlined in Unlocking Everest User once the admin credentials have been recovered.

Testing

After running the queries above, you will be able to log-in using the administrator account. If the issue still manifests, please contact support.

Back to top

Comments

0 comments

Please sign in to leave a comment.