Go Up
You are here: DeploymentPrerequisites and System RequirementsSupported Audit Database SQL Server Versions

Supported Audit Database SQL Server Versions

If you want to generate reports and run searches in Netwrix Auditor, SQL Server must be deployed on the same computer where Netwrix Auditor Server is installed, or on a computer that can be accessed by the product.

The Reporting Services (or Advanced Services) are required if you want to generate reports provided out-of-the-box with the product. Supported versions are 2008 R2 and above.

Supported SQL Server versions and editions are listed below:

Version Edition
SQL Server 2017

SQL Server 2016 SP1

SQL Server 2014

SQL Server 2012

SQL Server 2008 R2

SQL Server 2008

NOTE: SQL Server Reporting Services 2008 is not supported. In this case you have to manually install and configure Reporting Services 2008 R2 (or later).

NOTE: When planning for Netwrix Auditor deployment, consider the maximum database size in different SQL Server versions. Make your choice based on the size of the environment you are going to monitor, the number of users and other factors. Remember that the maximum database size in SQL Server Express editions may be insufficient. See SQL Server and Audit Database for more information.

Netwrix Auditor supports automated size calculation for all its databases in total, displaying the result, in particular, in the Database Statistics of the Health Status dashboard. This feature, however, is supported only for SQL Server 2008 SP3 and later.

You can configure Netwrix Auditor to use an existing SQL Server instance or to deploy a new instance manually or automatically.

  • Although SQL Server is not included in the product installation package the Audit Database Settings wizard helps you download SQL Server 2014 Express Edition with Advanced Services and guides you through configuration procedure.
  • For your convenience, Netwrix provides instructions on the manual installation of SQL Server with Advanced Services. See Install Microsoft SQL Server and Reporting Services for more information. For full installation and configuration details, refer to Microsoft documentation.

If you have more than one Netwrix Auditor Server running in your network, make sure to configure them to use different SQL Server instances. The same SQL Server instance cannot be used to store audit data collected by several Netwrix Auditor Servers.

Go Up