How to Configure Multiple SQL Server Reporting Service Instances on the Same Computer

Printer friendly

When a second instance of SQL Server Reporting Services is installed the second instance will connect to the default instance.  This is because the default behavior of a Reporting Services instance is to redirect its requests to the localhost. To reconfigure this behaviour you need to change the settings in the RSReportServer.config, RSWebApplication.config config files of Reporting Services.

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://<Server IP>/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://<Server IP>/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
Note: It's very important that only one of the two values is filled, else an error will occur.

Then run iisreset /noforce and you will be able to use multiple instances of Reporting Services on the same machine.

Your Name
Email	(Emails will not be displayed on the site or used for promotional purposes)
Comment
Type characters in the image	(case sensitive)