Unable to add Reporting Services server to IT Analytics

Products

• IT Analytics

Issue/Introduction

The following error is returned when attempting to add the Report Server URL to IT Analytics (ITA) via the Report Server Configuration Wizard:

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 browser's developer tools capture the following additional details:

InnerMessage: "The client and server cannot communicate, because they do not possess a common algorithm"
Issue: "ReportingServerService: TestConnection Error"

The Report Server's web service HTTPS URL is accessible from a browser on the application server. Attempts to connect to the HTTP URL successfully redirect to HTTPS. Per the browser, the connection is made using TLS 1.2.

This issue occurs when SQL Server Reporting Services (SSRS) is installed on a server running Windows Server 2012 R2 and configured to use HTTPS and a signing certificate. The ITAnalytics app pool identity has full permissions granted (Content Manager for the ITA reports folder). This occurs regardless of the selected encryption setting (i.e., TLS 1.0, 1.1, 1.2, {Default}, NULL) in ITA's configuration wizard. Attempts at connection via HTTP are rejected as requiring HTTPS.

A network packet trace shows a communication attempt between the application and SSRS servers that aborts ("Connection reset") after a handful of calls and responses.

Environment

Release : 2.9.1

Component : Reports

Cause

Incompatible cipher suites on the servers hosting IIS and SSRS.

Resolution

Upgrade the operating system on the servers hosting SSRS and IIS to Windows Server 2016 or later.