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 module navigation menu, select 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 the required values in the following fields:
    1. Server Name: Enter the name of the server on which SQL Server Reporting Services (SSRS) has been installed and configured.
      Note: If you do not specify the protocol for the server, HTTP will be assumed. 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.
    2. Web Service: Enter 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.

    3. User Name: Enter the user name to access SSRS.
    4. User Password: Enter the password to access SSRS.
    5. User Domain: Enter the domain name to access SSRS.
  3. Select .