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

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.

Related Articles

 

 

Comments

0 comments

Please sign in to leave a comment.