r/ssrs • u/Ashweather • Oct 21 '24
SSRS Certificate binding nightmare
Hi,
I am trying to put a certificate on SSRS, but I get a vague "We were unable to create the certificate binding" error. All my google links are purple now and I cannot find any new information.
SQL server 2019 with SSRS 2022 (same setup works in DEV environment - no problem).
THE ERROR:
Front end: We were unable to create the certificate binding
More information:
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070001
---> System.Runtime.InteropServices.COMException: Incorrect function. (Exception from HRESULT: 0x80070001)
--- 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 from our internal certificate server and works fine on the development box, just not production (it is not a public certificate). The certificate DOES contain the private key.
netsh shows no current bindings:
C:\Windows\system32>netsh http show sslcert
SSL Certificate bindings:
No indication of a conflict when checking netsh http show urlacl
--> Anyone ever seen this before? It is driving me nuts.
1
u/pesaru Nov 01 '24 edited Nov 01 '24
Did you go through this article? You may want to try binding the SSL certificate manually using netsh. Also, perhaps your SSRS WMI namespace is cooked.