SQL Server Reporting Services Web Portal URL returns a 503 error
search cancel

SQL Server Reporting Services Web Portal URL returns a 503 error

book

Article ID: 226059

calendar_today

Updated On:

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