TABLE OF CONTENTS



With the release of FTKC 7.6, users are now able to utilize multiple MSSQL databases; allowing for even distribution of cases (using round robin). One master server is required at all times to store ADG as well as additional procedures. Users must ensure they have the Database Management permission in order to add distributed databases using the administration panel – by default application administrator accounts will have this permission applied.

The case list can help identify which database server a case has been placed.

 

Prerequisites:

  • A working FTK Central 7.6 environment, using MSSQL
  • One or more additional MSSQL 2016/2017/2019 instances installed
  • Ports opened: 1433, MSDTC

 

DBConfig – Designating a Master Database

Validat

  1. On the App server, navigate to the Forensic Tools "bin" folder (typically C:\Program Files\AccessData\Forensic Tools\7.6\bin).
  2. Open DBConfig.exe as an Administrator.
  3. Locate and click on the existing database that will be used as the master database.

Validation

  1. Click Validate.
  2. Click Check Common Options.
  3. Select an Authentication Mode.
  4. Click Validate.
    • Database Validate Successful should appear. Do not proceed if this does not, please send any messages that accompany an unsuccessful validation to support@exterro.com.

Verifying the Master Database in FTKC


  1. From the home page, click Settings from the top-right corner.
  2. Navigate to the System Management tab.
  3. Click Database Servers.
  4. Verify the Is Master Server column value is set to true.

 


FTKC – Adding an Additional Database

  1. From the home page, click Settings from the top-right corner.
  2. Navigate to the System Management tab.
  3. Click Database Servers.
  4. Navigate to the Add Database Server section.



  1. Enter the Database Server Host Name or IP address.
  2. Enter the Port (Default: 1433).
  3. Enter the Admin (sa) Credentials or click Windows Authentication.
    • If you are using the Windows Authentication option, the user must be a domain-level service account with local administrator permissions to all servers.
  4. Click Save.


FTKC – Deactivating a Database

To stop cases being assigned to a specific database, users can simply click the toggle icon in the Actions column. This will not stop access to the cases stored on this database, it will only remove it from the active database pool for new cases.