Issue with SSL certificate after SQL SERVER SSRS UPGRADE

Nick 0 Reputation points
2025-04-08T16:12:41.37+00:00

hi All Experts, looking for some help here, we have SQL SERVER and SSRS running under:

Microsoft SQL Server 2017 (RTM-CU31-GDR) (KB5040940) - 14.0.3471.2 (X64)

2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Datacenter

10.0 <X64> (Build 14393: ) (Hypervisor) , and we have upgraded SQL SERVER and SSRS to below side by side

Microsoft SQL Server 2022 (RTM-CU18) (KB5050771) - 16.0.4185.3 (X64)

2022 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2022 Datacenter

10.0 <X64> (Build 20348: ) (Hypervisor)

we have installed new certificate

and we don't see any option to trust server certificate or any encrypt true or false in SSRS configuration manager

we get error when we try to access the SSRS reports

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)

---> System.ComponentModel.Win32Exception:

The target principal name is incorrect processing!ReportServer_0-3!15c8!03/21/2025-03:49:25:: e

ERROR: An exception has occurred in data source 'db'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:

Cannot create a connection to data source 'db'. ---> Microsoft.Data.SqlClient.SqlException:

we have re installed new server certificate, restarted SERVER multiple times but no luck

sp_readerrorlog 0,1,'certificate'

The certificate [Cert Hash(sha1) "9XXXXXXXXXXXXXXX"] was successfully loaded for encryption.

SQL SERVER is up and running , we can connect via ssms with trust server certifiacte and read data

please help with some tips..Thanks

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,064 questions
0 comments No comments
{count} votes

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.