SSRS 2016's

Question

We have two sql 2016 report servers on different windows 2019 hosts. We have a report using a xml web service as a data source. The report sends xml snippet to the web service, and this web service just sends back the submitted snippet.

We have two identical report servers. However, we are seeing this error on only one report server.

These are the errors.

Microsoft.ReportingServices.DataExtensions.XmlDP.XmlDPException: Failed to prepare web request for the specified URL. ---> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ds1

If I check with the browser, both report servers use TLS 1.2.
We don't know where the secure channel fails. (Verbose level log does not have the information.)

If anyone can shed a light, it would be appreciated.

thanks
Ben

Answer 1

Hi @Ben Kim ,
Enabling TLS 1.2 may cause some compatibility issues. You can try the following ways:

• Update .NET Framework, and enable strong cryptography on each machine
• Update SQL Server on the host server
• Update SQL Server client components on all systems that communicate with SQL. For example, the site servers, SMS provider, and site role servers.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.