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.

     

     

    SSRS - SSL Error

     

     

     

     

     

    • This topic was modified 3 weeks, 4 days ago by  JDRocket.
    • This topic was modified 3 weeks, 4 days ago by  JDRocket.
    Attachments:
    You must be logged in to view attached files.
  • Add TrustServerCertificate=True; to the connection string.

  • Where?

  • Are you referring to this?rs2rs

  • SSRS - SSL ErrorClick 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.

    • This reply was modified 3 weeks, 4 days ago by  JDRocket.
  • The issue magically resolved by itself. I'm confuse.

    The last command I ran in command prompt was - netsh http show sslcert.

    • This reply was modified 3 weeks, 4 days ago by  JDRocket.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply