all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Installing SQL Reporting Services on 2 Tiers


Installing SQL Reporting Services on 2 Tiers ChrisG
8/1/2005 11:46:06 AM
sql server reporting services:
I would like to install the Report Manager on a web tier and the Reporting
Services on an applications tier behind a firewall. The install program
automatically installs Report Manager and Services on the same box, but it
seems that the Manager is only a UI for calling the Services which are web
services. We would like to call the services from the web tier through 443
on the firewall to the application tier. Can anyone provide assistance on if
and how we could install Reporting Services as mentioned above?

Re: Installing SQL Reporting Services on 2 Tiers Bruce L-C [MVP]
8/1/2005 1:59:34 PM
Report Manager and Reporting Services are both asp.net application. As you
noted Report Manager is essentially a portal. Report Manager and Reporting
Services must be on the same box. However, Reporting Services and the
database do not need to be on the same box.

So, if you are planning on using Report Manager portal as the UI to
Reporting Services, then what you want to do is not possible (separating the
two). If, however, you are planning on using your own web page then it is
possible. There are two ways to integrate, web services and URL integration.
URL integration however only works if the Report Server is visible to the
client, which, again, is not what you want. You would need to use web
services to integrate with your own web site.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

AddThis Social Bookmark Button