Friday, March 30, 2012

Install RS with SSL handled in firewall

Hi,

We are trying to install RS in an unusual environment. The Web server's SSL and public IP address are installed in the firewall. The communications between Web server and other servers such as database server are not encrypted; all the servers have no public IP addresses.

My question is if RS can be installed and if it will work properly. Any other advice?

Thanks

Yes - we call this SSL Offloading.

With SQL Server 2005 Reporting Services, things should just work with the exception of the following:

1) Report Builder - it requires a direct connection to the report server to download and to function.

2) Links in Emails - we use the URLRoot property in the rsreportserver.config file to form the URL for the link. You'll need to set the property to your external IP Address or the external hostname, and remember to use the https protocol designatiion.

3) Drill-through links in Exported reports (PDF, Excel, etc.) - again we use the URLRoot property in the rsreportserve.config file to form the URL for the link. See comment above.

4) SharePoint V2 web parts - need a direct connection to the report server to view reports.

With SQL Server 2000 Reporting Services, this is supported starting with SP2. The instructions for setting this up are in the SP2 readme file. One note I should add, is that it is required for the router to translate URLs.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

sql

No comments:

Post a Comment