Go Up
You are here: AdministrationMonitoring PlansCreate a New PlanDefault SQL Server Instance

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. Define the default SQL Server instance on this step or disable security intelligence. Netwrix Auditor skips this step if have already configured Audit Database settings for other monitoring plans.

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:

    Option Description

    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.

    Authentication

    Select the authentication type you want to use to connect to the SQL Server instance:

    • Windows authentication
    • SQL Server authentication

    User name

    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.

    Password

    Enter a password.

Go Up