Admin user is locked out


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


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    locked = '0'
    WHERE  personal_idno = '{idno}' 
    Replace {idno} with the ID you noted in Step 4.


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

Related Articles





Please sign in to leave a comment.