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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy