SQL Server Reporting Services troubleshooting - Metasys - LIT-12012240 - Server - SQL Server - 13.0.50

SQL Server Installation and Upgrade Guide

Product
Building Automation Systems > Databases and Data Servers > SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
13.0.50
Revision date
2024-04-09
Product status
Active

Use this section to help you troubleshoot SQL Server Reporting Services. For additional troubleshooting information related to SQL Server Reporting Services, go to http://msdn.microsoft.com/en-us/library/ms159135.aspx.

Table 1. SQL Server Reporting Services Troubleshooting

Problem

Solution

One of the following messages appears when you are browsing to http://localhost/reportserver OR http://localhost/reports:

Cannot find the server or DNS error.

The page cannot be found.

The report server is not responding.

Note:
  • Make sure you are verifying SQL Server Reporting Services on the correct computer. In a split ADX, this computer is the web/application server.
  • Also, if you are using a SQL Server named instance other than MSSQLSERVER, use a web address that includes the suffix _instancename, where instancename is the SQL Server instance name. For example: http://localhost/ReportServer?ThisInstance http://localhost/ReportServer_ThisInstance

Start the Reporting Services Configuration Manager. This tool is located under the program group for your edition of SQL Server software (for example, Microsoft SQL Server 2017 > Configuration Tools > SQL Server Reporting Services Configuration Manager). Verify that each component is configured properly. For details, see Verifying SQL Server Report Server configuration.

When you attempt to verify that SQL Server Reporting Services is running, the following message appears:

<SQL Server 20xx error text>Service unavailable:

http error 503, the service is unavailable

To resolve this error, follow these steps:
  1. In Control Panel, select System and Security > Administrative Tools > Computer Management. The Computer Management window appears.
  2. In the left pane, expand Local Users and Groups. Select Groups.
  3. Under Group names, double-click the SQLServerReportServerUser group.
  4. Add the SERVICE and NETWORK SERVICE user accounts to this group. When added, they appear as NT AUTHORITY\SERVICE and NT AUTHORITY\NETWORK SERVICE.
  5. Restart Reporting Services using the Reporting Services Configuration Manager.

When you attempt to verify that SQL Server Reporting Services is running, you are presented with a Windows Security login prompt.

Enhanced security in the browser is preventing you from loading the page. Run the Internet Explorer web browser as an administrator (right-click the Internet Explorer icon, select Run or Run as Administrator). Then, try to load the Reporting Services page.

If the Reporting Services page still does not appear, log in to the operating system with the Administrator account and run the Internet Explorer web browser as an administrator. When the Windows Security login prompt appears, enter Administrator as the user name and the Administrator's password. Wait for the Reporting Services page to appear.

If the Reporting Services page still does not appear, turn off IE Enhanced Security for the server operating system by following these steps:

  1. Start Server Manager.
  2. On the Server Manager window, click Local Server.
  3. In the right column, set the parameter IE Enhanced Security Configuration to Off.

When you attempt to verify that SQL Server Reporting Services is running, you see this message:

The report server has encountered a configuration error. (rsServerConfigurationError)

The Reporting Services log file contains the error No DSN present in configuration file. A database connection to Reporting Services has not been created. Start the Reporting Services Configuration Manager. This tool is located under the program group for your edition of SQL Server software (for example, Microsoft SQL Server 2017 > Configuration Tools > SQL Server Reporting Services Configuration Manager). Perform the steps in Specific system requirements for the Metasys Advanced Reporting System.

When you attempt to verify that SQL Server Reporting Services is running, a scripting error occurs.

Enhanced security in the browser is preventing you from loading the page. Add the computer as a trusted site. For example, if the computer is called ADX-01, add http://ADX-01 to the list of trusted sites under security options for the browser.

Alternatively, turn off IE Enhanced Security for the server operating system by following these steps:

  1. Start Server Manager.
  2. On the Server Manager window, click Local Server.
  3. In the right column, set the parameter IE Enhanced Security Configuration to Off.

You configured SQL Server Reporting Services, but you cannot connect to http://localhost/reportserver or http://localhost/reports.

Make sure you are verifying SQL Server Reporting Services on the correct computer. In a split ADX, this computer is the web/application server.

Also, if you are using a SQL Server named instance other than MSSQLSERVER, use a web address that includes the suffix _instancename, where instancename is the SQL Server instance name. For example: http://localhost/ReportServer?ThisInstance http://localhost/ReportServer_ThisInstance.

Lastly, on a split ADX, the Reporting Services Database Setup/Database Connection might not be configured properly. See Verifying SQL Server Report Server configuration.

When you have the Reporting Configuration Manager open for SQL Server software, and make a change under Service Manager, the following Backup Encryption Key dialog box appears:

Figure 1. Backup Encryption Key Dialog

The backup encryption key is not used by Metasys software. However, to satisfy Reporting Services configuration, click the browse button (...), specify a file name for the encryption key, and click OK. Specify a password for the file and click OK.

You are installing SQL Server software with Reporting Services, but the Install the native mode default configuration option is unavailable.

This problem may occur when SQL Server software is already installed on the ADX and you install the software again to add Reporting Services.

To resolve this problem, follow these steps:
  1. Complete the installation.
  2. Configure Reporting Services manually. See Specific system requirements for the Metasys Advanced Reporting System.