THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

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

I had seen this issue before but found another cause for it today.

In this case, the client was using SCCM (System Center Configuration Manager) and couldn't access reports from the reporting server. After resolving some other issues, I was left with "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel" when I tried to go to http://servername/reports.

When I've seen this previously, it's been to do with the trust relationship between a pair of servers. However, I hadn't seen it come up before on a single server.

When I checked the SSL bindings in Reporting Services Configuration Manager, in the Advanced tab, I found that no certificate was associated with the SSL configuration. When I tried to edit it, and choose the cert from the dropdown list, the certificate binding could not be applied. (It would be useful if it told you why at that point). That had me puzzled until I opened Report Manager in IE and viewed the certificate. The certificate had been generated onsite and had expired.

Hope this helps someone. (Or helps me the next time I see it and can't recall what it was :-))

Published Monday, August 5, 2013 3:23 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Razvan said:


Had this issue too, it can be caused by a missing certificate. You can easily check that using the mmc snap-in.

August 5, 2013 2:46 AM

wandersick said:

For me, it was caused by the proxy server setting specified in Internet Properties (inetcpl.cpl) as our client's site require proxy for Internet access.

After unchecking "Bypass proxy server for local address", clicking "Create report" button would not return the error anymore.

April 13, 2015 4:58 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement