Report Server Configuration Manager - The target principal name is incorrect SSL

• JDRocket

  Old Hand

  Points: 397

  More actions

  April 24, 2025 at 1:58 pm

  #4583556

  SQL Server SSRS 2022.

  Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting.

  Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection

  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.

   

  • This topic was modified 1 month, 3 weeks ago by JDRocket.
  • This topic was modified 1 month, 3 weeks ago by JDRocket.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  April 25, 2025 at 2:10 pm

  #4584104

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.