Proxy web service to call SQL RS web service... issues? RRS feed

  • Question

  • We have a security policy that requires us to have our web site call to an application server, which in turn calls to our database server.  Firewalls are in place so only the web server has any exposure to the internet, and even that is proxied.


    The database server has the processing power and memory to run reports, but since we can't have the web server access it direcly, I thought that maybe we could create a proxy web service on the app server that "appears" to look like the SQL RS web service, and calls the SQL RS web service on the database server where the real work will be done.  I figured ReportViewer would  be able to point to that as the ReportServerURL.


    Has anyone tried something like this?  Are there any gotchas I should watch out for?  Is it a simple matter of using WSDL.EXE to generate a C# proxy class for SQL RS web service, then adding tags to expose the methods in the proxy class as web services?


    Is there a better way of handling this?




    Friday, May 4, 2007 3:24 PM