July 2, 2021 at 4:02 pm
We have a 3 node WSFC hosting 3 individual instances of SQL Server and one AG sitting on top. Listener configured.
Node1 - Primary (AG1)
Node2 - Secondary/sync
Node3 - Secondary/async
This works as expected. Listener set up, failover functions correctly, etc...
From my understanding, it is possible to host a second AG in the same WSFC using the same SQL instances (and the listeners will handle routing).
Node1 - Secondary/sync
Node2 - Primary (AG2)
Node3 - Secondary/async
I can create the second AG fine on Node2 but when adding the first replica (regardless of Node1 or 3) throws error 41106. The replica appears in Object Explorer but is in the DISCONNECTED state. The error directs you to the SQL Error log, which in turn says:
A connection timeout has occurred while attempting to establish a connection to availability replica 'Node2' with id [F834...E4].
Either a networking or firewall issue exists, or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance.
However, this makes no sense, as the other AG is functioning correctly.
Thoughts?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 3, 2021 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 16, 2021 at 5:49 am
This was removed by the editor as SPAM
July 21, 2021 at 2:51 am
This was removed by the editor as SPAM
August 9, 2021 at 8:04 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply