I’m trying to set up reporting services 2005 to use ssl with a 2008 instance also on the same machine also using ssl.  I’m trying to use the simple method of changing the ssl port of the 2005 site.  The website’s ssl certificate seems valid when I go to the /Reports directory, but a call is going bad somewhere inside.

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

I was directed to activate network tracing for the .net application as outlined here:

 http://msdn.microsoft.com/en-us/library/a6sbz1dx.aspx

After figuring out what version of .net the application is using, which can be found in the IIS settings for the site, activating was as simple as moving the proper xml into my web.config file for the SSRS web application.

I also added this code to direct the trace output:

Now I’m seeing  the network.log file in the reportmanager directory.  I also see some calls happening to the webservice which don’t include the 444 port number which would be necessary to make the ssl connection.

IIS reserves port 80. SQL 2008 reporting services is now using it’s own ‘web server’ – HTTP.sys.  In reporting services configuration manager change the Report Manager URL advanced settings.  In the ‘Multiple Identities for Report Manager’, edit the entry and change the TCP Port to not be 80.  Common alternates are 8080 or 8000.
http://technet.microsoft.com/en-us/library/bb630449.aspx

A helpful list of steps to enable IIS 7 for a Reporting Services 2005 install.

http://www.igregor.net/post/2008/01/Installing-SQL-Server-2005-Reporting-Service-on-IIS-7.aspx

The microsoft list is a little more thorough, telling you what’s needed in the IIS config afterwards (classic .net appPool).

http://support.microsoft.com/kb/934164

It’s interesting how large publications write multi-page features and then pepper the page – sometimes even interrupting content with links to totally irrelevant content.  How am I to make it through their expose without clicking out to some other link and getting distracted – thereby losing the supposed value that a long form story bears?  Let’s think a little.