Share via

Distributed AG in sqlserver 2019 getting error in joining the secondary

SVA 121 Reputation points
2022-07-14T11:33:00.287+00:00

Hi ,
Trying to configure the distributed AG in sqlserver 2019 getting an error in joining the secondary. Not possible to join the secondary even I open the port 5022 in the firewall. Below error is getting

Cannot create an availability replica for availability group . An availability replica of the specified availability group already exists on this instance of SQL Server. Verify that the specified availability group name is correct and unique, then retry the operation. To remove the existing availability replica, run DROP AVAILABILITY GROUP command. (.Net SqlClient Data Provider)

error no 41106

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,921 Reputation points
    2022-07-14T13:01:56.637+00:00

    The error is given in the message...

    the specified availability group already exists on this instance of SQL Server

    So connect to your secondary SQL Server and look for that AG, it should already exists... maybe it is not created correctly than drop it
    Maybe your first attempt didn't work well and it already created the AG but was not able to join the databases or creating the listener...

    Without any more details of what you have done exactly and what were those error messages before... it is hard for us to give you correct answers or guide in the correct direction.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.