SQL SSRS change certificate binding error

SSL-binding-already-exists
While deploying SQL Reporting Services I got the following error:
Create certificate binding.
We were unable to create the certificate binding.

Reserving url https://+:443
The url was successfully reserved.

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An SSL binding already exists for the specified IP address and port combination. The existing binding uses a different certificate from the current request. Only one certificate can be used for each IP address and port combination. To correct the problem, either use the same certificate as the existing binding, or remove the existing SSL binding and create a new binding using the certificate of the current request.

—> System.Runtime.InteropServices.COMException (0x80040238): Exception from HRESULT: 0x80040238
— 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)

Resolution

You need to delete existing bindings.
Firstly, get a list of current bindings.
Open Command Prompt as Administrator and type:

Now you can delete the binding like following:

Example:
show-add-delete-ssl-bindingsNow you will be able to add new binding.
Good Luck! 🙂

Be sociable 🙂 Share!
error

Comments/Коментарі/Комментарии