Skip to main content

How to get Database Content Audit working

You have enabled Data changes Audit in Netwrix Auditor for SQL Servers data source, configured as per our guide, but do not get data in reports without any errors, while you are sure some changes to data in the audited table were made.

The owner of the target database must have the sysadmin role on your SQL Server. It is needed for cross-database write.

Resolution​

  1. Open MSSQL Management Console and connect to your SQL Server.
  2. Select properties of the target database and pick an owner.
  3. Go to Security->Logins and grant that account the sysadmin role.