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 –
- Both instances Database mirroring endpoints are configured on different ports.
- The SQL Server instances are named instances also using different ports.
- Listeners have different names and different IP addresses and ports.
- 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
Best Answer
An Availability Group Listener simply connects the user to a database instance. Once they are connected to the instance they can access all the databases on the instance. It doesn't matter of the databases are part of the availability group or not. This is by design.
In other words everything is working exactly as it should be.