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 following SQL Server versions are supported:

Version Edition

SQL Server 2008

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

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

SQL Server 2016

The Reporting Services is required if you want to generate reports that are provided out-of-the-box with the product. The following SQL Server Reporting Services versions are supported: 2008 R2 and above.

NOTE: It is recommended to consider the maximum database size in different SQL Server versions, and make your choice based on the size of the environment you are going to monitor, the number of users and other factors. Note that the maximum database size in SQL Server Express editions may be insufficient.

Netwrix Auditor supports automated size calculation for all its databases in total, displaying the result, in particular, in the Database statistics widget 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 the documentation provided by Microsoft.

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