This article applies to Netwrix Auditor 6.0 and above. It explains the nature of the Event ID 1014 and provides resolution.
||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>".
||Check your 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.
||Depending on your Netwrix Auditor version, follow the corresponding resolution prompts.
- 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:
<a n="Name" t="2" v="your_SharePoint_Managed_Object_name"/>
- 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.