SSW SQL Reporting Services Auditor > Screenshots

SQL RS Auditor

Verify your SQL Server Reporting Services reports are working correctly with SSW Reports Validator!

SSW SQL Reporting Services Auditor User Guide
1. Prerequisites
2. Post Installation (Only for 1.18 and early version)
3. Running SSW SQL Reporting Services Auditor
4. Reports
5. Timeout

  1. Prerequisites

    1. To install, view the Installation User Guide
    2. To register, view the Registration User Guide

  2. Post Installation (Only for 1.18 and early version)

    Before you can run SSW SQL Reporting Services Auditor, you need to complete the following tasks.

    1. Configure the Virtual Directory to use ASP.NET 2.0

    Configure the Virtual Directory to use ASP.NET 2.0 runtime

    SSW SQL Reporting Service Auditor only supports ASP.NET 2.0 runtime. While the installer deploy the virtual directory, IIS defaults the web application to use ASP.NET 1.1 runtime. You need to change this in IIS manually.

    To do this:

    1. Open "Internet Information Services (IIS) Manager"
    2. Right click the "SSWSQLRSAuditor" virtual directory and choose "properties"
    3. On the ASP.NET tab select Version 2.0
      Configure ASP.NET
      Figure: Set the web app to use ASP.NET 2.0 runtime

    4. Click OK

  3. Running SSW SQL Reporting Services Auditor

    Program folder for SSW SQL Reporting Services Auditor
    Figure: Open default page for SSW SQL Reporting Services Auditor.


    Default Page for SSW SQL Reporting Services Auditor
    Figure: Click and open report server.
    Note: you need to enter the correct report server URL if you didn't have it installed to the default path.


    Report folder for SSW SQL Reporting Services Auditor
    Figure: Report folder for SSW SQL Reporting Services Auditor, click "01 - ValidateReports" to validate your reports.


  4. Reports

    Validating Report for SSW SQL Reporting Services Auditor
    Figure: Validating report for Reporting Services Reports.


  5. Timeout

    Timeout
    Figure: Timeout

    If there is a timeout warning, you need to modify parameters in Web.Config file to allow SQL Reporting Services Auditor to check your report server not timeout.

    Web.Config
    Figure: Modify the web.config

    CheckParameterTimeout is the timeout value for checking report parameters.

    RenderTimeout is the timeout value for rendering report.

    The web.config is located in the virtual directory folder. This is typically C:\Program Files\SSW SQL Reporting Services Auditor\WebApp\Web.Config