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

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).

SQL Server AlwaysOn Availability Group can also be used for hosting Netwrix Auditor audit database. For that, after specifying database settings in Netwrix Auditor, you should manually add created database to a properly configured AlwaysOn Availability Group. These steps must be taken each time a new audit database is created in Netwrix Auditor.

See this Microsoft article for details on adding a database to AlwaysOn Availability Group.

Planning for SQL Server Databases

When planning for Netwrix Auditor deployment, consider the maximum database size supported by different SQL Server versions and editions. Remember that maximum database size in SQL Server Express edition may be insufficient. Make your choice based on the size of the environment you are going to monitor, the number of users and other factors. This refers, for example, to Netwrix Auditor for Network Devices: if you need to audit successful logons to these devices, consider that large number of activity recordsSee 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.

NOTE: During SQL Server installation, you will need to provide the path for storing the SQL databases — it is recommended that you specify the data drive for that purpose (by default, system drive is used).

You will also need to add user account who will be assigned the sysadmin role — add the Configure Data Collecting Account, the account currently logged in, and local administrator of the machine.

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