Problem

Attempts to log in to the AD Enterprise Management Server using the 'FTKAdmin' account say the account is locked out.

 

Resolution

Management Server uses MSSQL:

  1. Open SQL Server Management Studio (as Administrator)
  2. Enter the proper credentials and connect to your database
  3. Click "New Query"
  4. Execute the following query:
    UPDATE managementserver.adms.tbl_ad_membership SET islockedout='false' WHERE userid=1

 

Management Server uses PostgreSQL:

  1. Open a Command Prompt (as Administrator)
  2. Navigate (CD) to the PostgreSQL bin folder (usually "C:\Program Files\AccessData\PostgreSQL\bin")
  3. Log into the database with the following command, where the schema corresponds to a version of FTK that was already correctly linked to the database:
    psql -p [port] -U postgres -W -d managementserver
  4. When prompted, enter your PostgreSQL password.
  5. Execute the following query:
    UPDATE managementserver.adms.tbl_ad_membership SET islockedout=false WHERE userid=1;
  6. Close the command prompt.

 

Cause

This usually occurs after several attempts to log in as 'FTKAdmin' using an incorrect password.