Recently, my DBA asked if I could fix Reporting Services. When users try to view reports – specifically, they click on the drop down and choose Security, then Properties, the site goes from https to http.
At this point the link below is http, not https. To fix that, I had to dig into Reporting Services a bit. I had a few errors in the process, like
‘The underlying connection was closed: could not establish Trust relationship for the SSL/TLS secure channel’
‘You are not authorized to view this page’
Here’s how I fixed it.
1) Made sure the wildcard cert was findable under Trusted Root Certification Authorities. It was already on the server, but under Certificates >> Personal >> Certificates. I re-imported it, this time specifying Certificates >> Trusted Root Certification Authorities.
2) Set the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportingservices.config file to SecureConnectionLevel 3. The line looks like
<Add Key=”SecureConnectionLevel” Value=”3″/>
3) In that same file, set UrlRoot.
4) Then I restarted IIS and ReportServices, and the problem went away.