Monday, May 7, 2012

Configure SQL Server Reporting Services 2008 R2 To Use SSL


The very brief outline of how to setup SSL access in SQL Server Reporting Services:

First install the SSL Certificate in IIS or Server Certificates:
  • Open MMC
  • Go to File --> Add Snapin
  • Select Certificates
  • Import Certificate
Use Reporting Services Configuration Manager to setup the the SSL / 443 in SSRS.

Next edit RSReportServer.config and add the new report server URL 

eg.

<ReportServerUrl>https://server_name/ReportServer_PRD</ReportServerUrl>

Restart the reporting service for the settings to take affect.

Note: The report server has to be accessed using the path configured above. This must be a valid resolvable path and must conform to the SSL certificate issuer address. To test the procedure has worked just edit the hosts file and try connecting with the URL above.

No comments:

Post a Comment