AlwaysOn Listener pointing to incorrect Hadr group

• James Slebodnick

  SSC-Addicted

  Points: 491

  More actions

  June 27, 2014 at 11:27 am

  #308669

  All, Thanks in advance

  I have two instances of SQL Server 2012 SP1 on a three node WSFC with a HAdr group on each instance with a corresponding listener. Instance 1's listener points to Instance 1, no issue.

  Instance 2 listener also points to instance 1. I'm at a loss why listener #2 is showing databases for Instance 1. Ive recreated instance 2's HAdr groups from scratch but still no change. Here is some additional information -

  1. Both instances Database mirroring endpoints are configured on different ports.

  2. The SQL Server instances are named instances also using different ports.

  3. Listeners have different names and different IP addresses and ports.

  4. Opening up each SQL instance on each of the three nodes show the correct HADR information and databases.

  The Listener seems to be getting confused and is looking at the wrong instance.

  Any help would be greatly appreciated

  thanks

  James