Always On Failover hangs for one node

• webrunner

  SSC-Dedicated

  Points: 31862

  More actions

  June 3, 2021 at 2:21 pm

  #3891470

  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

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 4, 2021 at 3:10 pm

  #3892085

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

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

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  June 7, 2021 at 8:28 pm

  #3893118

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