Netwrix Auditor System Health event log contains the following Event ID: 1214
“The following error occurred when trying to write audit data to the SQL database: <error>”.
Check Netwrix Auditor version and review the possible error causes.
- The Data Processing Account has insufficient permissions to create temporary files that are to be copied to the SQL database in the folder with audit data.
- Incorrect SSRS settings specified in Netwrix Auditor.
To resolve this issue, follow the steps below:
- Grant the Data Processing Account write permissions to the temporary folder with audit data (by default, %ProgramData%\Netwrix Auditor\Netwrix Auditor for SharePoint\Configuration\”SharePoint monitoring plan GUID*“).
- Verify SQL Server Reporting Services settings: navigate to Settings > Audit Database and verify SQL Server Reporting Services settings.