Russell Christopher's Semi-Useful BI Musings

I had the same problem using SelfSSL on a Win2K3 machine and could not figure out what the issue was for a long time. Finally I noticed that my certificate was in the Personal folder and not the Trusted Certificates folder. There was one in there but it did not have the same name.

Long story short, you have to make sure your certificate is in the Trusted folder and Personal Folder using MMC and they have to be the same certificate with the same name.

Hi Russel. I have a similar issue, but it is the /Reports folder the one that does not work fine. The /ReportServer folder works perfect. I can enter the /Reports folder, and can list all the reports. But, when I select one of the reports, and it starts rendering, I get the error message:

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

The remote certificate is invalid according to the validation procedure."

I access the report server from Internet, but the server is not exposed directly to the internet. It is behind a firewall.

Do you have any clue of how to fix this?

Thanks,

Julio

Hi,

Similar to Julio, I also have the ReportServer folder working fine, but the Reports folder is giving me the: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." error.  However, I get it as soon as I try to bring up the page, I am not able to see the list as Julio describes.

Also, if I update rsWebApplication.config to include the fqdn assigned to the certificate, I get a configuration error.

Finally, I have copied my certificate from the Personal Folder to the trusted folder.

Still no dice.

Hmmm... ??? Any ideas?

Thanks Russell, our issue was that someone changed the rsWebApplication.config file and missed out the S for https, your notes pointed that out.

We are now up and running after 2 days outage.

Cheers

we are getting the error message on accessing the reports VD. We have applied a locally genrated cert (simply called TAURUS08 - which happens to be the machine name also ) and applied it through iis to the relevant web site.  We have set the SSL requirement in the config manager with level 3 and cert name of Taurus08  (on applying this gets changed to the web sites ip address !?). We have set the value of UrlRoot   to https://192.168.2.214/reportserver in reportserver.config

We have set <ReportServerUrl>https://192.168.2.214/reportserver</ReportServerUrl> in RSWebApplication.config.

Have we missed anything? Any ideas why we still get the error message?

cheers steve

anybody managed to get the SSL working on SQL SRS 2005? i'm having a tough one on the Reports

https://localhost:2444/Reports/Pages/Folder.aspx?ItemPath=%2fMyDemo&ViewMode=Detail

but the reportserver link is ok..

I'm capable of acessing all Reporting Server sites from the RS machine using https://localhost/... but not using the Machine Name neither using the FQDN as it's configured in the RS Conf tool.

Any ideas?

PingBack from http://www.hilpers.it/2539110-connessione-in-https-da-report

For me my customer can cannect to my SQL Reporting database with SSL portal and can export data in .pdf, but it doesn't work with an Excel or Word report.

Any ideas ?

Thanks