Multiple Instances of SSRS webservice URL not working
Hi, I currently have a default instance and 3 named instances on the same physical machine. When I open the reporting services configuration manager for each instance, on the 'Web Service URL' tab there are 2 URLs the first being a regular http url and the other, an SSL URL. When I click on the SSL url, it works fine i.e., I get directed to the report server exactly. However, when I click on the first URL, the browser says it cannot find the page. To double check, I tried the links from another computer on the same domain and network, and the same thing happens, i.e, the SSL url works fine but the other one does not. I have also observed that all the RS instances have the Port Number as 80. So tried changing the port numbers and tried the new URL but no difference. All the SSL ports on the 3 instances are the same and yet, I can access all of them with no issues. Please help as I cannot seem to find a solution anywhere. Thanks!
July 19th, 2011 1:09pm

Hi SQL Novice 01, Thanks for your question. According to your description, it seems that you installed multiple Reporting Services instances in one server with the same IP address. However, I couldn’t conclude these four instances using one common ReportServer database or four single ReportServer databases. If using the common database, you should configure these instances using Scale-Out Deployment. There is one article about How to: Configure a Report Server Scale-Out Deployment, please refer to: http://msdn.microsoft.com/en-us/library/ms159114(v=SQL.100).aspx. Besides, to access a particular instance of a report server or Report Manager, or to publish reports to a particular instance, you type the URL for the instance you want to use. For example, suppose you have a server named SERVER01 on which you installed a default report server instance, a named report server instance (identified as TestServer), and a SQL Server Express instance, the default URLs for these instances would be as follows: · http://server01/reportserver · http://server01/reportserver$SQLExpress · http://server01/reportserver$TestServer You can found the detail information in this MSDN article: Installing Multiple Instances of Reporting Services: http://msdn.microsoft.com/en-us/library/ms403426(v=SQL.90).aspx. Hope these help you. If the problem still exists, please feel free let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2011 3:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics