Configuring SQL Server Reporting Services - 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

Follow these steps to start the SQL Server Reporting Services Configuration Manager.

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 SQL Server Reporting Services installed. For more information see Installing SQL Server Reporting Services for SQL Server 2019 and SQL Server 2017
  2. In the Server Name field, click Find to navigate to the appropriate server.
  3. In the Report Server Instance field, select the correct SQL Server software instance name. Click Connect.
    Figure 1. Instance selection

  4. In the Report Server Status pane, verify Started is in the Report Service Status entry.
    Figure 2. Report Server Status

  5. In the left pane, click Service Account. Verify Virtual Service Account is in the Use built-in account field and click Apply. The outcome of the action appears in the Results window.
    Note: SQL 2019 uses a Virtual Service Account in place of ReportServer.
    Figure 3. Service Account

  6. In the left pane, click Web Service URL. The warning icon indicates that the report server Web Service is not yet configured.
    Figure 4. Web Service URL

  7. Verify ReportServer is in the Virtual Directory field, accept the default values, and click Apply. The outcome of the action appears in the Results window.
  8. In the left pane, click Database.
    Figure 5. Report Server Database

  9. In the right tab, click Change Database.
    Figure 6. Change Database

  10. In the Action tab, select Create a new report server database. Click Next.
    Figure 7. Database Server Connection

  11. In the Database Server tab, complete the following:
    1. In the Server Name field, type the name of the unified ADX server, or the database server if this is a split ADX. If you are using a SQL Server named instance other than MSSQLSERVER, add the SQL Server instance name in this format: computername\instancename.
    2. From the Authentication Type list, select one of the following:

      • Current User - Integrated Security if you logged in to the computer with the Administrator account. The Username and Password fields are dimmed.

      • SQL Server Account if you logged in to the computer with a user in the Administrative group. This selection is required on the web or application server of a split ADX with the Metasys Advanced Reporting System.

    3. If you selected SQL Server account, specify the username and password for the SQL server administrator (sa) account.
    4. Click Next.
  12. In the Database tab, complete the following: (Figure 8):
    1. Specify ReportServer is in the Database Name field. If you use a SQL Server named instance other than MSSQLSERVER, add the instance name to the database name in this format:

      ReportServer_<instancename>.

    2. Select Native for the Report Server Mode.
    3. Click Next.
    Figure 8. Specify Database Name

  13. In the Credentials tab, complete the following:
    1. From the Authentication Type list, select SQL Server Credentials.
    2. In the Username and Password fields, type the user name and password you created in Step 4 of Creating a new SQL Server user. (The recommended user name is SSRSServiceAccount). For a split configuration, type the appropriate SA account and password.
    Figure 9. Credentials Dialog Box

  14. Click Next. Review the summary details, and click Next to create a new report server database.
    Figure 10. Database Confirmation

  15. The configuration process begins and completes in a few minutes. Make sure the result for each configuration step is a success. If any configuration is not successful, go to http://msdn.microsoft.com/en-us/library/ms159135.aspx for Reporting Services troubleshooting.
  16. Click Finish on the completion screen. The configured Report Server Database screen appears.
    Figure 11. Completion Window

  17. In the left pane, click Web Portal URL.
    Figure 12. Web Portal URL

  18. The warning icon indicates that the Report Manager virtual directory name is not yet configured. In the Virtual Directory field, accept the default value or type a name, and click Apply. The outcome of the action appears in the Results window.
    Note: The configuration of SQL Server software for the Metasys Advanced Reporting System is complete.