Reporting services giving an error only when i try to upload a new report

Greg Booth 1,371 Reputation points
2023-01-09T13:09:55.99+00:00

Reporting services giving an error only when i try to upload a new report.
The lasted log file has an error message saying

2023-01-09 12:49:08.3987|ERROR|7|OData exception occurred: System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.
at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)

When i look at the reporting services configuration manager, for the web portal, it shows identities that are using an https certificate. The certificate looks ok and the service account has the correct permissions to use/access the certificate.

Can anyone advise what might be going wrong ?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,063 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2023-01-10T02:32:31.217+00:00

    Hi @Greg Booth Did you configure the TLS connection correctly? Has your certificate expired?

    For configuring TLS connection on native mode report server, you can refer to this link: configure-ssl-connections-on-a-native-mode-report-server.

    Also, I found a link that lists possible causes and solutions for the error "The remote certificate is invalid according to the validator warning", maybe you can check it based on the content of this link. https://www.positioniseverything.net/the-remote-certificate-is-invalid-according-to-the-validation-procedure#:~:text=The%20remote%20certificate%20is%20invalid%20according%20to%20the,the%20hostname%20you%20use%20to%20contact%20the%20server.

    Best regards, Aniya


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.