Information Technology

  • About
Reporting Services 2008 R2 SSL wildcard errors: ‘You are not authorized to view this page’ + ‘The underlying connection was closed: could not establish Trust relationship for the SSL/TLS secure channel’

Reporting Services 2008 R2 SSL wildcard errors: ‘You are not authorized to view this page’ + ‘The underlying connection was closed: could not establish Trust relationship for the SSL/TLS secure channel’

November 4, 2014 by ralph.hogaboom

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.

rs1

rs2

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’

alternating with

‘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.

<UrlRoot>
https://apps.ghc.edu/ReportServer
</UrlRoot>

and

<ReportServerUrl>
https://apps.ghc.edu/ReportServer
</ReportServerUrl>

4) Then I restarted IIS and ReportServices, and the problem went away.

 

Posted in: Software Tagged: 2008 R2, certificates, documentation, microsoft, reporting services, SQL Server, wildcard cert

Tags

All Campus Day aruba batchfiles chokermail configuration DNS documentation email exchange exchange2016 experts-exchange fonts google live live@edu maybethiscanhelp microsoft msaccess network novell office office 2007 powershell proxy scripting security servers Software spam students support sync template tips tricks useful virtualization vmware wifi win7 windows windows7 winxp wireless word

About

Infotech is the blog of Ralph Hogaboom, sysops+ at Grays Harbor College in Aberdeen WA. I talk about Windows and linux servers, networking, higher education, scripting, design, and wireless.

GHC Homepage
ralph.hogaboom.org

Recent Posts

  • Windows 7 Windows update fails (usually with 8007000E)
  • Powershell Script to create Office 365 distribution list from AD OU
  • Remote PS client for Exchange 2016
  • Giving Permissions to Additional Mailboxes in Exchange 2016
  • Checking Windows Firewall Status from Nagios using NSClient++
  • Backing up DHCP for Windows Server
  • Reporting Services 2008 R2 SSL wildcard errors: ‘You are not authorized to view this page’ + ‘The underlying connection was closed: could not establish Trust relationship for the SSL/TLS secure channel’
  • jigsy.com Phishing Attacks
  • Quick + Dirty Powershell
  • Moving VMs from vmWare Server to ESXi 5.1.0 build 799733

Copyright © 2019 Information Technology.

Custom WordPress Theme by themehall.com

Better Tag Cloud