Reporting Services Newbie Question

[ChuckG]

Trying to find out if this is possible.

If you have an IIS webserver that is behind a firewall and accessable via the internet.

Then you have a SQL Reporting server behind the firewall, but not accessable via the internet.

Now you have a user on the internet who's viewing pages on the IIS server, is it possible to retrieve a report from the Reporting server to be displayed to the internet user?

I would assume it would have to be some kind of server side script the would have the IIS server talk to the Reporting server, but I'm not sure how you would render the report back to the internet user.

Thanks
ChuckG

 

[onpnt]

Yes

Is the IIS instance on a DMZ? This is purely network configurations. Allowing ports and the traffic that needs to go back and forth. SSL, SSLVPN etc... Things I know of but have no where near the depth to explain. I would suggest meeting with your network group to disucss the architecture of this setup. It MUST be perfect or security is a large issue.

_{____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[ChuckG]

No, both servers are sitting on our internal network. The IIS simply has a external IP mapped to it for HTTP usage.

ChuckG