Report Server Configuration Manager - Change Database - SSL Error
-
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.
-
Add TrustServerCertificate=True; to the connection string.
-
Where?
-
Are you referring to this?
- 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.
-
The issue magically resolved by itself. I'm confuse.
The last command I ran in command prompt was - netsh http show sslcert.
Click on 'Test Connection' or 'Next' from your first picture.Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply