all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

RServer in 3 tier environment


RServer in 3 tier environment Cliff_Harker NO[at]SPAM hotmail.com
9/13/2004 4:14:27 PM
sql server reporting services:
Can anybody shed some light on this for me?

I have to deploy Reporting Services in what I think is a fairly
typical 3-tier Internet environment.

I have the following

Firewall - 443 only
IIS Server (x2)
Firewall - 443 only
App Server (IIS)(x2)
Firewall - 1433 only
SQL Server

Question. How do I deply Reporting Services in this when the IIS
server can't talk directly to the SQL Server?

Is there some form of proxy I can use to pass through requests, via
the App Servers?

Any ideas appreciated

Re: RServer in 3 tier environment Jéjé
9/13/2004 9:41:54 PM
RS is a webservice
so you can install it on your App server
and you have to create your own front end application for your IIS Server
which talk to RS

"CliffH" <Cliff_Harker@hotmail.com> a écrit dans le message de news:
c13c8375.0409131514.6969f970@posting.google.com...
[quoted text, click to view]

RE: RServer in 3 tier environment Buzz
9/14/2004 5:35:12 AM
Cliff

The best solution for this would be to install Reporting Services (IIS) on
your Application Server, this will be able to communicate with your SQL
Server and so deployment would be a simple task using the RS command line
util or ReportingServices() .NET class.

To access the application server ReportingServices from the first (UI?) IIS
server you'll need to create a proxy class to the Application Server
Reporting Services using WSDL. You will be able to reference the proxy class
using code in the UI layer.

Hope this helps


[quoted text, click to view]
Re: RServer in 3 tier environment Cliff_Harker NO[at]SPAM hotmail.com
9/15/2004 1:15:28 PM
Thanks for the replies, I'll get our guys to have a look at creating
this "proxy" on the UI IIS server.

Given this is a fairly typical deployment setup I'm surprised there
isn't something in the package itself to facilitate this

Cliff


[quoted text, click to view]
AddThis Social Bookmark Button