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

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 FilesMicrosoft SQL ServerMSSQL.#Reporting ServicesReportServer open
old value:
new value:
<UrlRoot>http://<Server IP>/reportserver</UrlRoot>

For example in: C:Program FilesMicrosoft SQL ServerMSSQL.#Reporting ServicesReportManager open
old value:
new value:
<ReportServerUrl>http://<Server IP>/reportserver</ReportServerUrl>
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.


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |