Hi Team, We have an issue with SQL Reporting Service 2008 R2. We have installed SQL Reporting Service & also configured the same. After that when i have open the Reports or ReportServer from browser, It gives me bellowed error message The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. Moreover, We have Sharepoint 2007 installed at that server which is running fine without this Reporting Webparts. Please let me know if anyone has any solution to resolved this error and use reporting webparts in sharepoint Thanks & Regards, Brijesh Shah

Hi Brijesh Shah, Through the error message you provided, it seems that Reporting Services has been installed with Secured Socket Layer (SSL), but the CA certificate was not installed in the trusted root for the local computer. If you do not need SSL on your report server, please take the following steps and then check if it works for you. 1.Open Reporting Services Configuration Manager. 2.Click Web Service URL and click "Advanced". 3.Remove the SSL certificates, both for IPv4 and IPv6 and click ok, and then Apply. If you would like to configure SSL on your report server, please refer to the following article to solve the issue: SSL configuration and Reporting Services: http://blogs.msdn.com/b/mariae/archive/2007/12/12/ssl-configuration-and-reporting-services.aspx If you have any question, please feel free to ask. Thanks, Eileen