Overview
This article provides the solution to the issue you may encounter when configuring the Database Activity Auditing in GFI Archiver.
Information
When configuring Database Activity Auditing (Tracing) and setting the trace folder to C:\Program Files or C:\Program Files (x86) the following error is shown:
Failed during: ConfigTracingStep
Details: Failed enabling traces
This applies to any Microsoft SQL Server-based store type.
Root Cause Analysis
The Microsoft SQL Server service does not have sufficient permissions to write to system folders like C:\Program Files or C:\Program Files (x86).
Diagnosis
The debug log ..\Store\Debuglogs\AuditProviders.log reads:
"error ","AuditProviders","Error: (MSSql) EnableTrace [SQLSERVER\INSTANCE]. Error execute: Could not create a trace file."
Solution
- Create a folder on the Microsoft SQL Server outside of system folders (e.g., C:\Trace)
- Make sure that the service under which the Microsoft SQL Server runs, has full control (file system permission-wise) to this folder.
- When configuring Database Activity Auditing (Tracing) set the Trace Folder to the one created in step 1.
Configuration
The Database Activity Auditing configuration is successful.