Hi,

I'm working on an application that is to be available on the internet. 
Our hosting team in my company has said that the only way they host
web applications is with 3 machines and restricted ways of
communicating between them, like this:

Web Server / IIS -----HTTP---->AppServer ----SQL Port---->Database Server

The Web Server is open to the public who can login. Our client
software on the Web Server talks to our application server using Web
services.

The Application Server is connected to the database via a non-standard
SQL Port and software on it accesses the database and replies to the
Web Server.

Our Database Server has SQL Server 2005 with Reporting Services on it
and no other software.

The customer this is being set up for wants to be able to access
reports, via the web, on the database server and I have no idea how to
go about this. There are only two suggestions I've had:
Another license for SQL Server on the AppServer even though we'd only
be using the Reporting Services part of that license
A reverse proxy (!) which apparently would allow the machines to see each other

Both these incurr a cost that we haven't factored in. The customer
also wants to (somehow) upload reports that they have designed on
their own network (or at least edit ones that are up there).

This is giving me sleepless nights. I have no idea how to do it but
its been sold this way and the hosting team aren't budging. I would
really appreciate if anyone knows of any way this can be done.

---

Clarification of Question by reggie101-ga on 22 May 2006 03:06 PDT

SQL Server did install IIS when it installed Reporting Services but
unfortunately the hosting team will not allow http traffic to or from
the database server!

Hi

Dont your database server even contain IIS? I never tried,neither i
google ;), but i dont think it is possible to install sql server rep
services without having IIS Installed. Please specify.

Utsav