Verifying SQL Server Report Server configuration - Metasys - LIT-12012240 - Server - SQL Server - 11.0

SQL Server Installation and Upgrade Guide
Brand
Metasys
Product name
SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
11.0
Revision date
2021-02-05
Product status
Active
Language
English

About this task

Use this section if you have SQL Server software and SQL Server Reporting Services installed on your computer. To verify that the installation is correct, complete the following steps:
Note: This procedure uses SQL Server 2019 but the steps are similar for other editions of SQL Server Reporting Services.

Procedure

  1. Start Report Server Configuration Manager. The Report Server Configuration Connection dialog box appears.
    Note: If the Report Server Configuration Connection dialog box does not appear, you do not have installed SQL Server Reporting Services. For more information see Installing SQL Server Reporting Services for SQL Server 2019 and SQL Server 2017
  2. In the Report Server Instance field, select the correct instance name. Click Connect.
  3. In the Report Server Status pane, verify Started is in the Report Service Status entry. If not, click Start.
  4. In the left pane, click Web Service URL.
    1. In the Report Server Web Service Virtual Directory area, verify that a virtual directory appears in the Virtual Directory field. If any warning icons appear, address the issues. If you used a named instance other than SSRS, the instance name is in either of these formats: Reports$instancename or Reports_instancename.
    2. In the Report Server Web Service URLs area, click the URLs hyperlink.
  5. Windows web browser launches the SQL Server Reporting Services web page. The version shown depends on, which edition of SQL Server you installed. If you see Microsoft SQL Server Reporting Services Version 15.x.xxx.xxx on the web page, the web service URL configuration is successful
    Note:
    • This window may take up to 30 seconds to appear.
    • If a prompt for a user name and password appears, type the administrator credentials, and click OK, or exit the web browser and relaunch the browser as an administrator. You can also avoid the prompt if you log in to the computer using the administrator user account.
    • If the report server window does not appear, or appears with an error, this indicates the configuration for the report server is incorrect. For more information, refer to the SQL Server Reporting Services troubleshooting section in SQL Server Installation and Upgrade Guide (LIT-12012240).
  6. In the left pane, click Database.
  7. In the right pane, in the Current Report Server Database area, verify that values appear in the Report Server Database area and no warning icon appears is visible.
  8. In the left pane, click Web Portal URL. Verify a virtual directory name is visible and no warning icon appears. Windows web browser launches the SQL Server Reporting Services web page.
    1. To launch the web portal URL, click the URL link.
    2. If you see the SQL Server Reporting Services home page, the configuration is correct.
    Note:
    • This window may take up to 30 seconds to appear.
    • If a prompt for a user name and password appears, type the administrator credentials, and click OK, or exit the web browser and relaunch the browser as an administrator. You can also avoid the prompt if you log in to the computer using the administrator user account.
    • If the report server window does not appear, or appears with an error, this indicates the configuration for the report server is incorrect. For more information, refer to the SQL Server Reporting Services troubleshooting section in SQL Server Installation and Upgrade Guide (LIT-12012240).

    Report services are configured and running correctly, to configure SQL Server Reporting Services for Metasys Advanced Reporting System, see Specific system requirements for the Metasys Advanced Reporting System.