SQL Server 2012 to SQL Server 2016 migration error

Question

When I migrated SQL Server 2012 Standards to SQL Server 2016 Standard on Windows 2012 R, SSRS failed. The error message was "An HTTPS 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." Does any one know how to fix this? Thanks

Answer 1

Hi @Victor Xue ,

An HTTPS binding already exists for the specified IP address and port combination.

Which means a IP:Port combination was still bound to the old certificate. Probably one of the more sensible error messages you get in SSRS. You need to delete existing bindings.
Firstly, get a list of current bindings.

In order to check what certificate is bound to which IP:Port combination, please open Command Prompt as Administrator and type:

netsh http show sslcert  

And sure enough, the old certificate was still bound to the following IP:Port combination: [::]:443

Now you can delete the binding like following:

netsh http delete sslcert ipport=[::]:443  

Then you can rebind SSRS Web Service URL to your SSL Certificate.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@ Joyzhao-MSFT. Thank you

Answer 3

@ Joyzhao-MSFT. Thank you