Manage SQL Server Reporting Services

About SQL Server Reporting Services Workspace

The SQL Server Reporting Services stores the reports that can be viewed and managed in APM. To integrate SQL Server Reporting Services with APM application, you must define the SQL Server Reporting Services instance that you want to use for a given APM database.

The Operations Manager application provides a feature that lets you configure the SQL Server Report Server. After you have defined the SQL Server Reporting Services instance that you want to use for a given APM Server and data source, APM will use that Report Server for storing the reports that are created and accessed on that APM Server and database. 

Access the SQL Server Reporting Services Workspace

Procedure

  1. In the Applications menu, navigate to ADMIN > Operations Manager > Connections.
  2. In the Connections page, select SQL Server Reporting Services.
    The SQL Server Reporting Services workspace appears.

Configure APM to Use Reporting Server

Procedure

  1. Access the SQL Server Reporting Services Workspace.
  2. Enter values as described in the following table, and then select .
    FieldDescription
    Server NameEnter the name of the server on which SQL Server Reporting Services (SSRS) has been installed and configured.

    If you do not specify the protocol for the server, HTTP will be considered. If the SQL Server Report Server is a secured server, you can type HTTPS://<Server Name> to indicate that an HTTPS connection should be used. If the SQL Server Report Server is not secured, you can type HTTP://<Server Name> or you can omit the protocol and simply type the server name.

    Note: In the Data Source page, specify the Data Source Host value as “*” by default. But when you are configuring https, enter a valid Fully Qualified Domain Name (FQDN) in the Data Source Host field.
    Web ServiceEnter the name of the Report Server Virtual Directory that has been created for the instance of SSRS that you want to use for the current APM Server and data source.

    If the SQL Server Report Server for this data source has not been defined, the Web Service will be set to Report Server by default, which is the name of the virtual directory created for the first SQL Server Reporting Service instance that is installed on the given server. You can modify the default value if needed.

    If the server specified in the Report Server text box contains multiple instances of SSRS, you must specify the virtual directory of the instance that you want to use for the current APM Server and data source.

    User NameEnter the user name to access SSRS.
    User PasswordEnter the password to access SSRS.
    User DomainEnter the domain name to access SSRS.
    Tip: If you want to delete the existing configuration and restore the default values stored in the applications.json file, select .