none
Unable to bind SSL certificate to SSRS Web Service URL or Report Manager URL RRS feed

  • Question

  • I'm using SQL 2014 SSRS, and trying to bind an SSL certificate to Web Service URL and Report Manager URL.

    I'm getting this errors:

    Microsoft.ReportingServices.WmiProvider.WMIProviderException: The SSL certificate is not trusted.
    
     ---> System.Runtime.InteropServices.COMException (0x80040241): TabletPC inking error code. The property was not found, or supported by the recognizer (Exception from HRESULT: 0x80040241)
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
       at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.CreateSSLCertificateBinding(String application, String certificateHash, String ipAddress, Int32 port)
       at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateSSLCertificateBinding(UrlApplication app, String certificateHash, String ipAddress, Int32 port)
    The certificate is issued from the local AD domain CA server:

    and it shows up in the Personal Certificate Store

    Any ideas?


    Sam Boutros, Senior Consultant, Software Logic, KOP, PA http://superwidgets.wordpress.com (Please take a moment to Vote as Helpful and/or Mark as Answer, where applicable) _________________________________________________________________________________ Powershell: Learn it before it's an emergency http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx http://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx

    Monday, November 7, 2016 1:59 PM

Answers

  • NVM, I had to add the domain root CA to the Trusted Root Certification Authorities on the SSRS server


    Sam Boutros, Senior Consultant, Software Logic, KOP, PA http://superwidgets.wordpress.com (Please take a moment to Vote as Helpful and/or Mark as Answer, where applicable) _________________________________________________________________________________ Powershell: Learn it before it's an emergency http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx http://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx

    • Marked as answer by Sam Boutros Monday, November 7, 2016 3:36 PM
    Monday, November 7, 2016 3:36 PM

All replies

  • Hi Sam,

    SSL that I wanted to use appeared in the list so I selected and applied it… only to receive an error message!

    This message claimed that a binding already exists for the IP address and port combination. Luckily, the message also told me how to fix the issue: remove the binding and create a new one.

    You can use the Command Prompt command netsh http show sslcert to view the binding:

    This can be cleared out using a similar Command Prompt command: netsh http delete sslcert ipport=[::]:443 (if that does not work, simply replace “[::]:443 with your IP:port combination). Once this is completed, return back to ‘Web Service URL’ in the Reporting Services Configuration Manager and recreate the bindings with the correct SSL.

    Refer in following link

    http://blog.fpweb.net/configuring-ssl-in-sql-server-reporting-services-ssrs/#.WCCdPS197IU


    Please click Mark As Answer if my post helped.

    Monday, November 7, 2016 3:31 PM
  • NVM, I had to add the domain root CA to the Trusted Root Certification Authorities on the SSRS server


    Sam Boutros, Senior Consultant, Software Logic, KOP, PA http://superwidgets.wordpress.com (Please take a moment to Vote as Helpful and/or Mark as Answer, where applicable) _________________________________________________________________________________ Powershell: Learn it before it's an emergency http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx http://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx

    • Marked as answer by Sam Boutros Monday, November 7, 2016 3:36 PM
    Monday, November 7, 2016 3:36 PM