One WSFC, Three Nodes, Two AGs

  • We have a 3 node WSFC hosting 3 individual instances of SQL Server 2014 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. Selburg
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply