Google Answers Logo
View Question
Q: Accessing SQL Server reports on database server via web and app servers ( No Answer,   1 Comment )
Subject: Accessing SQL Server reports on database server via web and app servers
Category: Computers > Security
Asked by: reggie101-ga
List Price: $10.00
Posted: 25 Apr 2006 03:16 PDT
Expires: 25 May 2006 03:16 PDT
Question ID: 722562

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

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!
There is no answer at this time.

Subject: Re: Accessing SQL Server reports on database server via web and app servers
From: utsav_verma-ga on 15 May 2006 03:41 PDT

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.


Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy