Installing ApexSQL Audit

Applies to

ApexSQL Audit

Summary

This article describes how to install ApexSQL Audit and its components.

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. Dialoging the installation wizard, first select the appropriate components to be installed
    1. ApexSQL Audit (central (windows) service, server-side components, application GUI and the Central repository database)
    2. ApexSQL Audit Main GUI (the standalone GUI)
    3. Server-side components (Windows service which allows auditing of SQL Server instances remotely via the ApexSQL Audit main application)

    Main installation screen

  4. Continue and choose an installation directory

In case when ApexSQL Audit (Main application) is being installed, 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 SQL Server drop-down menu of the Repository location section:

Configure the central repository host

Users can optionally change the port which is set to 64561 by default.

Next, provide user credentials (username and password) and choose a temporary file location:

Configure an user account to access application

Alternatively, it is possible to set a Group managed service account for application access:

Configure a gMSA account to access application

More information about gMSA can be found in the Configuring gMSA account to run ApexSQL Audit processes article.

Additionally, the location for repository files can be changed and users can opt to archive old database in case there is a central repository from previous versions or installations already present on the selected SQL Server instance:

Configure the central repository database location

This will complete the installation of ApexSQL Audit (Main application).

  • Note: If you select one of the Install ApexSQL Audit GUI or Install server-side components options, the installation process will not require any input from the user and will complete the installation process automatically using default inputs

Useful link