Accessing SQL Server reports on database server via web and app servers
Category: Computers > Security
Asked by: reggie101-ga
List Price: $10.00
25 Apr 2006 03:16 PDT
Expires: 25 May 2006 03:16 PDT
Question ID: 722562
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.
|There is no answer at this time.|
Re: Accessing SQL Server reports on database server via web and app servers
From: utsav_verma-ga on 15 May 2006 03:41 PDT
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
If you feel that you have found inappropriate content, please let us know by emailing us at firstname.lastname@example.org with the question ID listed above. Thank you.
|Search Google Answers for|