Netwrix Auditor System Health Log - Event ID 1014 / 1214

This article applies to Netwrix Auditor 6.0 and above. It explains the nature of the Event ID 1014 and provides resolution.
Email It to Me Print this Page
Symptoms Depending on your Netwrix Auditor version, the Netwrix Auditor System Health Log contains the following EventID
Netwrix Auditor 9.0 and above: 1214
Netwrix Auditor 8.5 and below: 1014

"The following error occurred when trying to write audit data to the SQL database: <error>".
Cause Check your Netwrix Auditor version and review the possible error causes.
  1. 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.
  2. Incorrect SSRS settings specified in Netwrix Auditor.
Resolution Depending on your Netwrix Auditor version, follow the corresponding  resolution prompts.
  1. Grant the Data Processing Account write permissions to the temporary folder with audit data (by default, %ProgramData%\Netwrix Auditor\Netwrix Auditor for SharePoint\Configuration\<your_SharePoint_monitoring_plan_GUID>).

*To view your monitoring plan (Managed Object in Netwrix Auditor 8.5 and below) GUID, navigate to %programdata%\Netwrix Auditor\Audit Core\Config Server\Configuration.xml. Find your monitoring plan name in the configuration file:
-<n n="ManagedObjects">
....
<a n="Name" t="2" v="your_SharePoint_Managed_Object_name"/>
 
  1. Verify SQL Server Reporting Services settings. Do the following, depending on your current Netwrix Auditor version:
  • Netwrix Auditor 9.0 and above: navigate to Settings --> Audit Database and verify SQL Server Reporting Services settings. 
  • Netwrix Auditor 7.1 - 8.5: In Netwrix Auditor Administrator Console, navigate to AuditArchive--> Audit Database and verify your SQL Server and Reporting Services settings.
  • Netwrix Auditor 7.0: In Netwrix Auditor Administrator Console, navigate to Settings --> AuditIntelligence and verify your SQL Server and Reporting Services settings.
  • Netwrix Auditor 6.5 and below: In the Netwrix Auditor console navigate to Settings --> Reports and verify your SQL Server and Reporting Services settings.


 
Was this information helpful?