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