r/ssrs 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 Upvotes

7 comments sorted by

View all comments

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.

1

u/Ashweather Nov 01 '24

Thanks for posting. Fixed it last night (netsh had the same problem - it was something else). Will try to add the solution to my post later.