Could not establish trust relationship for the SSL/TLS secure channel

Question

 

Hi,

I am working on sql server reporting services 2005 , i got this error while deploying a report

Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. C:\Temp\NotificationReport\db.rds 0 0 

NB: i checked IIS no ssl required on all sites.

Any Help ?

Thanks

Tarek Ghazali

SQL Server MVP

Answer 1

Hi,

I solved the problem :

in start-->program files-->microsoft sql server--> configurtion tools-->

reporting server configuration.

in report server virtual directory --> uncheck the require secure socket layer (ssl) connections--> press apply

 

:)

Thanks,

Tarek Ghazali

SQL Server MVP

Answer 2

If you want to enable the SSL and get rid of this error, then install the certificate in the trusted certificate store of your local computer.

Answer 3

I also have this problem. I have my virtual directories under the default website for Windows Server 2003 IIS 6.0. I have installed the certificates and the the report server works in SSL, but not the Report Manager and the default webpage (home.aspx-->page/folders.aspx) states the "could not establish trust relationship..." error. Please advise and thanks in advance.

r,

Clem

Answer 4

I had the same problem, but I had entered the wrong certificate name in the Reporting services configuration manager -> Report server virtual directory -> Certificate name.

I had used myName instead of myName.domain.com that was the correct name of the certificate to use.

Answer 5

I had the same problem, and tried everything, not working.

 

However, in the reports service configuration manager check the SSL --> Restart --> IISRESET--> uncheck SSL --> Restart --> IISRESET did the final trick. Now it is working without SSL whtich is what I wanted.

 

Answer 6

Tarek:

 

I have the same problem. But when I navigate to Reporting Services Configuration Manager/Web Service URL, I don't see any checkbox to turn off Require SSL.

 

Can you help?

 

Venki

 

Answer 7

This solution was mentioned earlier. Just now i resolved it. Follow the below steps:

 

1. Open Start -> Program Files -> Microsoft Sqlserver 2005-> Configuration Tools -> Reporting Services Configurations

[Hope u already did this ]

2.  Select "Reporting Server Virtual Directory" in the left panel. [here u will find the check box]

3. Uncheck "Secure Socket Layer (SSL) Connections.

 

Answer 8

Hi,
Please check the Server Date and Time. if both servers date and time difference is too long then you will receive this error.  If you really want SSL the above suggestion may not suit.

Thanks,
Suyaraj M

Answer 9

I really need SSL and this error still follow me. Some one have done it with SSL. I installed the certificate  and I can navegate in  https://myserver/ReportServer ... but https://mysite/Reports still with the same error:

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

Some one has done with SSL

Answer 10

Any solutions for this? I have the same problem. I want to stay in SSL, but running into the same issue. anyone has any ideas? Thanks

Answer 11

Hi hs2009,

Please look at this article http://support.microsoft.com/kb/915599

Answer 12

Most probably your Reports and Report Server is not configured correctly on your IIS website (default or whatever). Also check if the related SQL services are running.
I faced the same issue and came here for an answer. It worked for me this way =

Eventually, i deleted the certificate then the reports and reportserver from IIS website (inetmgr)
> reconfigured the certificate (use machine's fully qualified name i.e. machine.domain)
> From reporting services configuration, reconfigure reportserver and reports.
> In report server virtual directory settings -> check the checkbox for ssl, require for - 3 All SOAP APIs, machine's FQN.

Finish rest of the configuration if any.

Answer 13

hi Murty k

how about this error happen in Microsoft Sqlserver 2008,

after steping through "Open Start ->All Programs -> Microsoft Sql Server 2008-> Configuration Tools -> Reporting Services Configuration Manager"

I can't find checkbox to uncheck "Secure Socket Layer (SSL) Connections" in 2008

 

what should I do?