SSRS 2008- Underlying connection was closed – could not establish trust relationship for SSL/TLS…

Hi Friends,

In my previous blog, I wrote about SSRS 2005 “unable to connect to remote server” issue and the fix for it. You can find it here;

So here is the next issue with SQL Server 2008 Reporting Services. “The underlying connection was closed: could not establish trust relationship for the SSL/TLS secure channel.”

This error popped up after a fresh, successful installation, when I tried to access the report manager at http://localhost/Reports_SQL2K8

1_SQL_Server_SSRS2008_Underlying_connection_was_closed_could_not_establish_trust_relationship

Well, this one was not so difficult to figure out. Since the error clearly said that it has something to do with SSL. I fired up Reporting Services Configuration Manager. And clicked on “Report Manager URL” section, and this is what I saw:

2_SQL_Server_SSRS2008_Underlying_connection_was_closed_could_not_establish_trust_relationship

 

If you observe, https:// has been configured. But I did not do it. May be, the default configuration. I clicked on Advanced. See the screenshot below:

3_SQL_Server_SSRS2008_Underlying_connection_was_closed_could_not_establish_trust_relationship

If you observe, default SSL certificate for both IPv4 & IPv6 was configured which was causing the problem. This default configuration was done by SSRS 2008 installation. I suspect, this was due to Windows Server 2008 R2 network services or any other role/feature I enabled before SSRS installation. Now, I did not need SSL configuration on my personal laptop and/or this configuration had to be fixed. I removed both the configurations and clicked OK. But it still not done. The same configuration has to be removed from “Web Service URL” section in SSRS configuration – exactly in the same way.

That’s it. You are done. The Report Manager was now showing up, successfully.