IT Analytics connection failure to Reporting Services server
Article ID: 245682
Updated On:
Products
Issue/Introduction
The following error message is displayed when adding or updating the Report Server URL via the Report Server Configuration Wizard in the IT Analytics (ITA) console under Admin > Settings > Servers:
The Report Server URL may not be valid or the IT Analytics Server service account may not have enough permissions in the Report Server. Exception: The underlying connection was closed: An unexpected error occurred on a receive.
The following messages are captured in the browser's developer tools console:
InnerMessage: "The client and server cannot communicate, because they do not possess a common algorithm"
Issue: "ReportingServerService: TestConnection Error"
This issue occurs in an environment in which Microsoft SQL Server Reporting Services (SSRS) is configured to use HTTPS and a signing certificate and Microsoft SQL Server (MSSQL) is hosted on a server running Windows Server 2012 R2. The ITA site's app pool identity has been granted full permissions in SSRS (Content Manager for the ITA reports folder). The connection fails independent of the encryption settings selected in the Report Server Configuration Wizard (i.e., TLS 1.0, 1.1, 1.2, {Default}, NULL). Attempts at connection via HTTP are rejected as requiring HTTPS.
A network packet capture trace shows a connection attempt between the ITA application server and the SSRS server that aborts ("Connection reset").
Environment
Release : 2.9.1
Component : SQL Server Reporting Services
Cause
This problem is caused by an incompatibility in the TLS cipher suites between the servers hosting the ITA application and SSRS.
Resolution
Per Microsoft, Windows Server 2012 R2 reached mainstream End of Service (EOS) on October 9, 2018 and extended support expires October 10, 2023. Refer to the product lifecycle page published by Microsoft here:
https://docs.microsoft.com/en-us/lifecycle/products/windows-server-2012-r2
To resolve this issue, upgrade the operating system version on the server hosting SQL Server to Windows 2016 or 2019.
Additional Information
Microsoft KB article KB3435244 - TLS 1.2 support for Microsoft SQL Server:
Feedback
