SQL Servers supported up to the
following versions
• Microsoft SQL Server 2012 SP4
• Microsoft SQL Server 2014 SP3
• Microsoft SQL Server 2016 SP2
• Microsoft SQL Server 2017
• Microsoft SQL Server 2019
NOTE: Auditing is supported on SQL clusters only when they are not using
high availability technologies. In this configuration, the agent only audits the
active nodes in the cluster where agents are deployed.
NOTE: Change Auditor SQL Data Level auditing currently only supports
auditing databases in Full and Bulk logged recovery models. Minimally
logged operations performed in bulk logged recovery model may not
produce auditing events. An initial backup is required for both Full and Bulk
logged databases before the transaction log can properly support auditing.
NOTE: Encrypted databases are not supported.
NOTE: Change Auditor does not support auditing databases that have row
and page compression applied.
NOTE: Agent memory can increase 1.5 GB per audited database.
NOTE: SQL Data Level auditing templates are assigned to an agent when
you create the template. Each audited database requires one template
assigned to a single agent.
Required permissions The account specified in the auditing template that is used to access the
SQL Server instance must have the following database permissions:
• Permission to open a connection to the targeted database.
• Read permissions on targeted tables and system tables.
• VIEW SERVER STATE permission.
• SYSADMIN server role.
• CONTROL SERVER permission.
For more information See the Change Auditor for SQL Server User Guide.