This product is no longer supported.

SSW SQL Reporting Service Auditor (SSW Auditor) installation cannot run perfectly on MS SQL Server 2008 and later versions, you need to manually configure it.

This document is made under the following install environment:

  • Windows Server 2008 R2 Enterprise with Service Pack 1
  • MS SQL Server 2008 R2
  • SSW SQL Reporting Services Auditor v1.22

Before you can run SSW SQL Reporting Services(SSRS) Auditor, you need to complete the following steps.

  1. Adding an ASP.NET 2.X Application Pool
  2. Using this Application Pool in SSRS Auditor
  3. Rname “ValidateReports” file

First, to add an ASP.NET Application Pool:

  1. Open "Internet Information Services (IIS) Manager"
  2. Expand the menu under Server name | right click "Application Pools" | select "Add Application pool..."
    Figure: Add an Application Pool in IIS
  3. Adding a new Application Pool. In this example, it named as "TestAppPool", select ".NET Framework v2.0XXXX", tick the box in front of "start application pool immediately", click "OK"
    Figure: Adding a new application pool
  4. Go to Advanced Settings of "TestAppPool"
    Figure: Go to Advanced Settings
  5. In Advanced Setting, change Identity from "ApplecationPoolIdentity" (default) to "LocalSystem" | Click "OK"
    Figure: Change Identity from ApplecationPoolIdentity(default) to LocalSystem
  6. The newly created application pool is shown
    Figure: The newly created application pool is shown

Second to add an ASP.NET Application Pool:

  1. Go to SSRS Auditor's application Pool. Right click "SSW SSRS Auditor" | select "Manage Application" | select "Advanced Settings"
    Figure: Go to "Advanced Settings" of SSW SSRS Auditor
  2. To use the new application pool
    Figure: start using new application pool

Last, rename "001-ValidateReports" file in SSW auditor folder from:

001- ValidateReports

To:

01 - ValidateReports

Figure: change its name to "01-ValidateReports"