How to allow/deny only certain users access ApexSQL Audit auditing reports

Applies to
ApexSQL Audit

Summary
This article describes how to set permissions for viewing ApexSQL Audit reports.

Description
ApexSQL Audit
offers web based reports through Internet Information Services (IIS). By default, access to these reports is granted to everyone except Anonymous Users. The default reports URL is localhost:41300. If there is another application that uses this port, ApexSQL Audit will take the next available one.

To control web report access, Internet Information Services Manager is required. Internet Information Service Manager is installed as a Windows feature:

  1. Open Control Panel
  2. Open Programs and Features
  3. Click Turn Windows features on or off
  4. Expand Internet Information Services
  5. Expand Web Management Tools
  6. Check IIS Management Console and IIS Management Service
  7. Click OK and wait for the installation process to finish

To allow or deny access to a specific user:

  1. Open Control Panel
  2. Open Administrative Tools
  3. Open Internet Information Services (IIS) Manager

    ApexSQLComplyWebConsole is added as a website in IIS Manager

    By default, Internet Information Services authentication is limited to Windows authentication only. If that is not the case, disable all other options except Windows authentication.

  4. To control the web report logins, open .NET Authorization Rules

  5. Add a rule to allow or deny access to a specific user, group, or role. These rules are applied from the first one in a list to the last.

Example 1

For example, there are 5 different Windows users on the Production2 machine. Four of them need to have access ApexSQL Audit web reports, but JohnSmith doesn’t. A rule must be added to the .NET Authorization Rules to deny access to JohnSmith.

  1. Open .NET Authorization rules
  2. Right click and choose Add Deny Rule
  3. Choose Specified users
  4. Enter Production2\JohnSmith
  5. Click OK

After the rule is added, the .NET Authorization Rules show a new deny entry

Example 2

Another example would be with 7 different Windows users on the Production2 machine. None of them should have access to ApexSQL Audit reports, except JohnDoe. A rule must be added to the .NET Authorization Rules that allows access to JohnDoe and denies it to everybody else, in that specific order.

After the rules are added, the .NET Authorization Rules show new allow and deny entries

These steps can be followed for every scenario: specific users, groups, and roles.