SQL Server 2016 Always On Endpoint creation fails RRS feed

  • Question

  • Hi Experts,

    I have a standard setup of two Nodes (SQL1 and SQL2) and want to create two Always On avaibality groups for two instances, each hosting a single user database.

    I have created the first Always On availability group without any issues. I used port 1433 TCP for the listener and used 5022 as an endpoint. Both SQL1 and SQL2 are added and the SQL1 has the Primary replica.

    Now I wanted to do the same with the other Database, but this time use SQL2 a Primary. In the "New Availability Group Wizard" I am configuring different endpoints for the 2nd AG of course and I am taking 5023 as port. I am also usiong a unique Listener name and IP of course. The problem is that when I try to complete the wizard I get following error:

    The Database Mirroring endpoint cannot listen on port 5022 because it is in use by another process. (.Net SqlClient Data Provider)

    This is very strange as in both in the cofiguration and also on the Summary page I see that the endpoints should be on 5023

    Any ideas on what I am doing wrong? Do I need to create an endpoint on 5023 in advance? I though the Always On AG wizard will do that for me?



    (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Friday, June 28, 2019 12:53 PM