We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services.
We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal network -- there is no external access.
How can we access SSRS from the Web server?
As an example, I am using the following to call the report, which works when I have a VPN connection into the collocation. Then I have access to SSRS.
What can I do so that the front end application can go to this internal network where SSRS lives?