Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

AlwaysOn Listener pointing to incorrect Hadr group Expand / Collapse
Posted Friday, June 27, 2014 11:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 20, 2016 11:56 AM
Points: 69, Visits: 81
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

Post #1586975
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse