Issue with SSL certificate after SQL SERVER SSRS UPGRADE
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