RS Server Architecture

I am working on a POC (proof of concept) for reporting services.
My question is can RS be depoyed using the following architecture.
Web Server.
App Server.
DB Server.
The web server can only see the app server, and the app server can see both
the web and db server. Would like the actual report generation to be
performed on the app server.
Can RS be depoyed in this manner?
Thank you in advance for any information.
--
Robert HillIf you assume that the App Server is what you are calling RS then the answer
is yes. Your web app can use either url integration or it can use web
services. The new webform control (2.0 framework) that comes wtih VS 2005
(it does not ship with RS) is the easiest and best way to integrate. Under
the covers it uses web services.
RS does the rendering at the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RobertHillEDS" <rwhill@.nospam.nospam> wrote in message
news:DAFA3AF6-9291-4E2A-9038-3F57F2BB85B7@.microsoft.com...
> I am working on a POC (proof of concept) for reporting services.
> My question is can RS be depoyed using the following architecture.
> Web Server.
> App Server.
> DB Server.
> The web server can only see the app server, and the app server can see
> both
> the web and db server. Would like the actual report generation to be
> performed on the app server.
> Can RS be depoyed in this manner?
> Thank you in advance for any information.
>
> --
> Robert Hill|||Hi Robert,
I agree with Bruce. As for SQLserver reporting service, the report server
can be installed on a different server from the datasource used to generate
report. So for your scenario, the Application Server should be the one
which host the ReportServer, and DB server should be the one which provide
data for generaring report. And as for webserver, it just need to access
the Report server(applicaion server) to query the Reports (through url or
webservice).
#Planning a Reporting Services Deployment
http://msdn2.microsoft.com/en-us/library/ms157293(SQL.90).aspx
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)