Default SQL Server Instance
To provide search, alerting, and report capabilities, Netwrix Auditor has to store security intelligence data in the Audit Database hosted on a SQL Server instance.
Specify one of the following options:
Disable security intelligence and make data available only in activity summaries—Select only if you do not want to generate reports and run data searches. Audit data will not be written to the Audit Database and will be available only in Activity Summary emails.
Even if you select this checkbox now, you will still be able to configure these settings later, but already collected audit data will not be imported in the Audit Database. Refer to Audit Database for detailed instructions on how to configure the Audit Database settings.
Install a new instance of Microsoft SQL Server Express automatically—Select if you want Netwrix Auditor to download and configure SQL Server 2014 Express with Advanced Services.
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 audit, the number of users and other factors. Note that the maximum database size in SQL Server Express editions may be insufficient.
Use an existing SQL Server instance—Select to continue using an installed SQL Server instance. Netwrix Auditor detects local SQL Server instance automatically and prepopulates the fields. Complete the following fields:
SQL Server instance
Specify the name of the SQL Server instance to store audit data.
NOTE: 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.
Select the authentication type you want to use to connect to the SQL Server instance:
- Windows authentication
- SQL Server authentication
Specify the account to be used to connect to the SQL Server instance.
NOTE: This account must be granted the database owner (db_owner) role and the dbcreator server role.
See Configure Audit Database Account for more information.
Enter a password.