Problem


When trying to perform some task, it fails and you see something like "permission denied in database 'master'. " in the error logs. 

 

Resolution

  1. On the main Application Server for FTK Central, navigate to ProgramFiles\AccessData\Forensic Tools\<version>\bin, while logged in as the service account.
  2. Find DBconfig.exe
  3. Right Click and "Run as Administrator"
  4. Click the "Create Master Proc" button
  5. Choose "Windows Authentication" on the pop-up
  6. Click "Start Creation"

 


Cause


Something has corrupted the Stored Procedures for the "master" database. This function will recreate all the stored procedures. 


Sample Errors:


CREATE DATABASE permission denied in database 'master'.


The EXECUTE permission was denied on the object 'sp_ADG7X1_ClearCache', database 'master', schema 'dbo'. 


(Last updated June 23,2023 - FTK Central 7.6 SP3)