After changing the websitename, hostheader or computername of a Microsoft Reporting Services Server, you get the error: The report server is not responding. Verify that the report server is running and can be accessed from this computer.

This error occurs, because the UrlRoot element in the RSReportServer.config is not changed automaticly, when you change your computername or website hostheader.
Open the RSReportServer.config in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer
Change the UrlRoot element to the correct name

Open RSWebApplication.config file and, if necessary, modify the ReportServerUrl setting to reflect the new server name. Note that this setting is not used in every installation. If it is empty, do nothing.

For example in: C:\Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportServer open

RSReportServer.config

old value:
<UrlRoot>http://<servername>/reportserver</UrlRoot>

new value:
<UrlRoot>http://<hostneader>/reportserver</UrlRoot>

For example in: C:\Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportManager open

RSWebApplication.config

old value:
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

new value:
<ReportServerUrl>http://<hostneader>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Note: It’s very important that only one of the two values is filled, else an error will occur.

Run iisreset /noforce and you’re now using multiple instance of Reporting Services on the same machine.

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.