Monday, September 21, 2009

How to SSL enable SQL 2005 Reporting Services

This assumes you have received the required CERT to enable SSL on IIS.
  1. Install SSL cert to IIS and enable SSL and required 128-bit.
  2. Open Reporting Services Configuratioin tool to configure the Report Server Virtual Directory.
  3. Select Require Secure Socket Layer (SSL) connection checkbox.
  4. Select level 3.
  5. Enter certificate name which is (usually) the DNS of the webserver.
  6. Click Apply.
  7. Using Notepad, edit RSReportServer.config and modify the UrlRoot to use "https:" and the full DNS (certificatename) of the webserver.
    https://certificatename/reportservervirtualdirectoryname

Reference: http://msdn.microsoft.com/en-us/library/ms345223(SQL.90).aspx

No comments:

Post a Comment