SQL Server 2012 to SQL Server 2016 migration error

Victor Xue 21 Reputation points

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,229 questions
No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,381 Reputation points Microsoft Employee

    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,

    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.

2 additional answers

Sort by: Most helpful
  1. Abeer mahmoud Salama 1 Reputation point

    @ Joyzhao-MSFT. Thank you

  2. Abeer mahmoud Salama 1 Reputation point

    @ Joyzhao-MSFT. Thank you