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

Default SQL Server Instance

To provide searching, alerting and reporting capabilities, Netwrix Auditor needs an SQL Server where audit data will be stored in the databases. To store data from the data sources included in the monitoring plan, the wizard creates an Audit Database for each plan. At this step, you should specify the default SQL Server instance that will host Netwrix Auditor databases. To read more, refer to SQL Server and Audit Database.

NOTE: Alternatively, you can instruct Netwrix Auditor not to store data to the databases but only to the repository (Long-Term Archive) – in this scenario, you will only be able to receive activity summaries. Reporting and alerting capabilities will not be provided.

NOTE: Netwrix Auditor skips this step if you have already configured Audit Database settings for other monitoring plans.

Select one of the following options:

  • Disable security intelligence and make data available only in activity summaries — select this option if you do not want audit data to be written to the Audit Database. In this case, data will be available only in Activity Summary emails. Alerts, reports and search capabilities will not be supported.

    NOTE: If you later clear this option to start saving data to the database, consider that already collected audit data will not be imported in that database.

  • Install a new instance of Microsoft SQL Server Express automatically — this option is available at the first run of the wizard. It allows you to deploy SQL Server 2014 Express with Advanced Services on the local machine. This SQL Server will be used as default host for Netwrix Auditor databases.

    NOTE: It is strongly recommended that you plan for your databases first, as described in Database Sizing section. Remember that database size in SQL Server Express edition may be insufficient for your audited infrastructure.

  • Use an existing SQL Server instance — select this option to use an existing SQL Server instance.

    NOTE: Local SQL Server instance is detected automatically, and input fields are pre-populated with its settings.

    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