SQL Server 2012 to SQL Server 2016 migration error

Victor Xue 21 Reputation points
2022-02-11T10:37:37.603+00:00

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,793 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-02-14T02:04:07.067+00:00

    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

    173952-01.png

    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.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Abeer mahmoud Salama 1 Reputation point
    2022-02-14T06:23:32.35+00:00

    @ Joyzhao-MSFT. Thank you

    0 comments No comments

  2. Abeer mahmoud Salama 1 Reputation point
    2022-02-14T06:30:17.337+00:00

    @ Joyzhao-MSFT. Thank you

    0 comments No comments