SQL Server Reporting Services Web Portal URL returns a 503 error

Products

• IT Analytics
• IT Management Suite
• Server Management Suite
• Client Management Suite

Issue/Introduction

Accessing the SQL Server Reporting Services (SSRS) Web Portal URL while troubleshooting reports displays no content and returns a 503 error. The following error is captured in the SSRS server log:

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Invalid PBI Configuration, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

Environment

Release: All

Component: Reports

Resolution

To troubleshoot this error, follow this procedure:

1. Locate the SSRS configuration file rsreportserver.config on the server hosting SSRS; e.g.
   
   %SystemDrive%\Program Files\Microsoft SQL Server\MSRS13.<instance name>\Reporting Services\ReportServer\rsreportserver.config
   
   
2. Open the file with a text editor
3. Inspect the <URLReservations> key for duplicate <Application> keys; e.g.,
   

   <Name>ReportServerWebApp</Name>

4. If duplicates are found, delete the duplicate entry or entries
5. Save and close the file
6. Restart the SQL Server Reporting Services service
7. If no duplicates were found in step 4, open Reporting Services Configuration Manager (RSCM)
8. Connect to the server and instance hosting the IT Analytics reports
9. Select the Encryption Keys page
10. Click the Delete button to Delete Encrypted Content
11. Click the Yes button to confirm the deletion
12. Click the Exit button to close RSCM
13. Open the IT Management Suite console
14. Navigate to Settings > Notification Server > IT Analytics Settings > Connections > Symantec CMDB
15. Click the Update Dependencies button
16. Navigate to Settings > Notification Server > IT Analytics Settings > Configuration
17. Select the pencil icon to edit the Report Server Virtual Directory URL
18. Click the Verify Connection button to verify the ReportServer Virtual Directory URL
19. Edit the Authentication Type to use stored credentials and enter the credentials of the account specified as the Service Account identity in RSCM
20. Navigate to Settings > Notification Server > IT Analytics Settings > Reports and install the reports you wish to use