Fix The report server has encountered a configuration error

In this article, I will show you how to fix “The report server has encountered a configuration error (rsServerConfigurationError)“.

On new SCCM server, when you install SQL Server Reporting services, you may encounter Reporting Services Error. Upon browsing the SCCM reports in browser, you see The report server has encountered a configuration error (rsServerConfigurationError).

In addition, when you launch the SCCM console and go to Monitoring\Reporting\Reports, you see the ConfigMgr reports are empty. Does this mean reporting services has not been installed correctly? Let’s not conclude that so soon and first examine the log files.

SQL Server Reporting Services Log Files

When you install SQL Server Reporting Services for SCCM, there are three log files that you must monitor.

  • srsrpsetup.log – Records results of the reporting services point installation process.
  • srsrpMSI.log – Records detailed results of the reporting services point installation process from the MSI output.
  • srsrp.log – Records information about the activity and status of the reporting services point. Site system server.

In my case, the srsrpsetup.log did not log any errors. I could see the srsrp.msi exited with return code 0 which meant the reporting services role was installed correctly.

srsrp.msi exited with return code: 0
srsrp.msi exited with return code: 0

The srsrpMSI.log also did not have any errors logged.

Product: ConfigMgr Reporting Services Point -- Configuration completed successfully.
Windows Installer reconfigured the product. Product Name: ConfigMgr Reporting Services Point. Product Version: 5.00.9049.1000. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.
ConfigMgr Reporting Services Point Configuration completed successfully
ConfigMgr Reporting Services Point Configuration completed successfully

Finally, when I examined the srsrp.log, I saw The report server has encountered a configuration error.

System.Web.Services.Protocols.SoapException: The report server has encountered a configuration error.  ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ~   at Microsoft.ReportingServices.Library.ReportingService2005Impl.GetItemType(String Item, ItemType& Type)~   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetItemType(String Item, ItemTypeEnum& Type)
The report server has encountered a configuration error
The report server has encountered a configuration error

Fix The report server has encountered a configuration error

If you launch the browser and browse the SCCM reports, you see The report server has encountered a configuration error. Reporting Services Error. There are few reasons why you see the report server configuration error.

  1. You haven’t configured the reporting database properly.
  2. The report server database is not created.
  3. You haven’t applied the configuration for the Web Service URL and Web Portal URL.
The report server has encountered a configuration error
The report server has encountered a configuration error

Launch the Report Server Configuration Manager and select Database. On the right pane, under Current Report Server Database, click Change Database.

Reporting Server Configuration Manager
Reporting Server Configuration Manager

On the Change Database window, you got two options.

  1. Create a new report server database – Choose the first option if you know that a report server database is not created. You can also verify that by logging in to the SQL server and checking the database.
  2. Choose an existing report server database – Select the second option when you know that report server database exists. Use this option to reconfigure your report server database.

Create New Report Server Database

I noticed that that report server database wasn’t created. If you log in to SQL server, you should find the reporting server database under Databases. In my case, it was missing. So use the below steps to create a new database for report server.

Configure Report Server Database
Configure Report Server Database

Choose a local or remote instance of a SQL server database engine and specify the credentials that have permissions to connect to the server. After you do that click Test connection and ensure you see Test Connection Succeeded message.

Create Report Server Database
Create Report Server Database

On the Database section, specify the database name for report server and click Next.

Specify Report Server Database Name
Specify Report Server Database Name

On the Credentials window, specify the credentials of an existing account that report server will use to connect to report server database. Click Next.

Report Server Credentials
Report Server Credentials

On the Summary window, verify all the settings once and click Next.

Reporting Server Configuration Summary
Reporting Server Configuration Summary

On the Progress and Finish window, ensure the reporting server database configuration wizard configures the database. Ensure you don’t see any errors here. Click Finish.

Report Server Database Configuration Wizard
Report Server Database Configuration Wizard

The SQL Server Reporting Services Configured successfully. Click Exit.

SQL Server Reporting Services Configured
SQL Server Reporting Services Configured

In the above steps we have created a report server database. You can log in to the SQL server and verify if you see the new database under Databases.

Report Server Database
Report Server Database

After you have made the above changes, you don’t need to reinstall the reporting services role. Just wait for few minutes and the reports will be deployed. Monitor the srsrp.log, and you will notice that reports are being added to SCCM.

Fix The report server has encountered a configuration error
Fix The report server has encountered a configuration error

Finally, the reports started to appear both in console and web browser. We have successfully fixed The report server has encountered a configuration error. I hope this post helps.

Fix The report server has encountered a configuration error
Fix The report server has encountered a configuration error

Need Assistance?

Send us a message or post your question in forums.

Leave a Comment