Installing ApexSQL Audit

Applies to
ApexSQL Audit

Summary
This article describes how to install ApexSQL Audit and its modules.

Permissions and requirements

Before proceeding with ApexSQL Audit deployment, please check the Permissions and requirements knowledgebase article to ensure that your target system meets the requirements listed in the article.

To install the ApexSQL Audit components:

  1. Log on as a user with administrator permissions to the computer where ApexSQL Audit will be installed
  2. Start the installation
  3. Follow the installation instructions
  4. At the Select components dialog, select the appropriate modules to be installed

    1. Main application (the GUI and the Central repository database)
    2. Web reports
    3. Auditing instance (the module for auditing a local SQL Server instance remotely via the ApexSQL Audit main application)

      Important note: options a. and c. exclude each other – both modules cannot be installed on the same machine. Users can monitor local SQL Server instance with Main application, there is no need for Auditing instance module.

      Setup ApexSQL Audit - Select components

      Note that if you select only the Web reports option, you will be prompted to provide credentials to connect to the ApexSQL Audit central repository database. The dialog does not appear if the Main application option is selected. The provided information will be used to connect to a remote SQL Server where the central repository is hosted.

  5. Continue and leave the Use default installation parameters option checked

    Depending on whether you selected the Main application or Auditing instance option, following installation scenarios can be applied:

    If you selected the Main application option

    1. 5.1.1. After copying the files, the installation will prompt for a target SQL Server instance by showing a list of local SQL Server instances in the Local SQL Server instance drop-down menu

      ApexSQL Audit installation - Local SQL Server instance

      Check the Audit the selected SQL Server instance option if you want to audit the SQL Server instance that hosts ApexSQL Audit Central repository database. Otherwise, this can be changed at later time using the ApexSQL Audit GUI and the Add auditing instance option. Note: Checking this option requires one ApexSQL Audit license, otherwise no license is required for Main application.

    2. 5.1.2. When prompted, provide the credentials for the ApexSQL Audit service. Use the default settings or specify an existing Windows user with appropriate permissions (see the Permissions and requirements knowledgebase article).

      Provide credentials for the ApexSQL Audit service

    3. 5.1.3. Use the Select the folder for temporary files dialog to set the folder used for audited data before it’s stored in the repository.
    4. 5.1.4. The Choose credentials for web reports dialog prompts for credentials which will be used to access the repository using the Web console module. Specify an existing Windows user with permissions as described in the Permissions and requirements knowledgebase article.
      Note: the dialog does not appear if the Main application option was selected previously.

      Choose credentials for Web reports

    5. 5.1.5. Complete the installation following the instructions on screen.

    If you selected the Auditing instance option
    The Auditing instance option cannot be deployed on the machine where the ApexSQL Audit Main application (the GUI and central repository database) is installed.
    The Auditing instance option is used for installing the ApexSQL Audit auditing service locally on a server machine that hosts SQL Server instances that will be audited remotely by the ApexSQL Audit Main application.
    You only have to install the Auditing instance once on a server machine, regardless of the number of SQL Server instances hosted on the server.

    To continue with the installation of the Auditing instance:

    1. 5.2.1. When prompted for the ApexSQL Audit central server address, add the ApexSQL Audit central instance by adding the machine name where the ApexSQL Audit main application is installed, or by adding its IP address

      ApexSQL Audit installation - Central server address

    2. 5.2.2. Follow the onscreen instructions
    3. 5.2.3. When prompted, provide the credentials for the ApexSQL Audit service. Use the default settings or specify an existing Windows user with appropriate permissions (see the Permissions and requirements knowledgebase article)
    4. 5.2.4. Follow the onscreen instructions

Once the Auditing instance is installed, the SQL Server instance must be added to the ApexSQL Audit Main application for auditing. To do that:

  1. Start the ApexSQL Audit GUI
  2. Select the Add auditing instance option
  3. Check the SQL Server instance you want to add for auditing
  4. Click the Apply button to confirm the selection

Useful link