Stacked instances and Availability Group Listeners

• lanky_doodle

  SSCrazy

  Points: 2378

  More actions

  March 17, 2022 at 4:53 pm

  #4001374

  Hi,

  We have stacked Names instances, running on distinct static ports:

  INSTANCE1: 1433

  INSTANCE2: 1533

  INSTANCE3: 1633

  Configured the same on both SQL hosts.

  In INSTANCE2 we created a Listener on port 1433. We connect to this Listener in SSMS, running this

  SELECT @@SERVERNAME shows SERVER1\INSTANCE2 = correct

  Failing the AG over and re-running that shows SERVER2\INSTANCE1 = wrong

  Failing back and re-running that now shows SERVER1\INSTANCE1 = wrong

  If we change the AGL port to 1533 and force connect to that in SSMS using AGLNAME,1533 everything works as expected.

  This is not my expected behaviour. MS docs say:

  INSTANCE ports have to be unique (totally understand this)

  AGL ports do not have to be unique

  I read it that you can have multiple instances on different ports and multiple listeners ALL on port 1433, whether that's multiple listeners within an instances or single listeners in multiple instances.

  I'll try and find the doc.

  Thanks

  • This topic was modified 2 years, 9 months ago by  lanky_doodle.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  March 18, 2022 at 5:10 pm

  #4001994

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

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