Hi Sarah,
A recap and some clarifying questions I have for you:
- You have a three node Windows Server Failover Cluster
- You have three SQL Server instances - one per node? And are they standalone instances or Failover Cluster Instances?
- You created an Availability Group that spans all three SQL Server instances?
- Which instance hosts the read-write replica and which WSFC node does that instance currently "live" on?
- You created an AG Listener associated with the Availability Group
- Can you clarify what you mean by "windows cluster points to secondary"? You're seeing that the AG resource in Failover Cluster Manager is owned by a SQL Server instance hosting a secondary replica?
Thanks,
Joe