Always On Failover hangs for one node

  • Hello experts,

    We have a 3-node Always On setup. When I use the Failover... in the SSMS GUI, I have two other possible nodes to connect to (assuming the current primary is NODE02).

    NODE01 Synchronous commit / Automatic / No data loss / Resolving

    NODE03 Synchronous commit / Manual / No data loss / Resolving

    Specify the connection to the secondary replica

    Connect...

    When I try to connect to NODE01, it just hangs. When I try to connect to NODE03, the connection works and I can continue with the failover.

    Does anyone know why the connection attempt would hang like that? If I need to provide any more info, just let me know.

    Thanks for any help.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Thanks for posting your issue and hopefully someone will answer soon.

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

  • Hi, are you able to connect from node02  to node01 using ssms or sqlcmd? SQL port is open between these two nodes?

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

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