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

1. Create a folder on the Microsoft SQL Server outside of system folders (e.g., C:\Trace)
2. Make sure that the service under which the Microsoft SQL Server runs, has full control (file system permission-wise) to this folder.
3. 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.