April 24, 2025 at 1:50 pm
SQL Server SSRS 2022.
Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting.
I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error.
Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection
Anyone have any idea?
I am able to log into the SQL Server in SSMS without checking the 'Trust server certificate' checkbox. I enter in the host name in the 'Host name in certificate' textbox.
I've confirm SQL server is using the certificate.
sys.sp_readerrorlog 0,1,cert
Not sure where to go from here.
April 24, 2025 at 2:29 pm
Add TrustServerCertificate=True; to the connection string.
April 24, 2025 at 2:41 pm
Where?
April 24, 2025 at 3:16 pm
Are you referring to this?
April 24, 2025 at 3:37 pm
Click on 'Test Connection' or 'Next' from your first picture.
User has rights and can log into SSMS.
I am able to log into the SQL Server in SSMS without checking the 'Trust server certificate' checkbox. I enter in the host name in the 'Host name in certificate' textbox.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply