• 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