Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Externally available reports

Author  Topic  jbodey Starting Member 3 Posts Posted - 2005-02-17 : 07:16:58 Hi We have developed an application that is viewable external to the company, which works with sensitive corporate data. One aspect of this system is the Reporting functionality, which is written in Reporting Services. A rough description of the architecture is: Application Web server in DMZ (accessible from internet via SSL) Database servers behind firewall. One of these hosts Reporting Services Because the Report Server is sitting behind the firewall on a database server, and we do not wish to expose this to the web, I have developed a component to the application which penetrates the firewall via HTTP Tunnelling, authenticating itself using Windows credentials. Then the report url is called across the tunnel, and the report data passed back to the application via a byte stream (in pdf form), and displayed to the user. Currently, the login credentials for the tunnelling are stored in the web.config file. Can anybody please advise me of any problems with this approach? If there are any problems, then what solutions are available to me? Thank you.