Pointing the web app at the current Primary instance will produce issues if there is an AlwaysOn group failover.
Yep, thats the crux of the post, i want to resolve this 🙂
What cluster name are you referring to?
so there is nodeA & nodeB in the cluster. The cluster name is Clust1. I can open SSMS, type in Clust1 in the connection properties and connect to the cluster. I was wondering if in MDM i should referr to this as the instance name, or if i should create an AG Listener.
A listener should be used to provide centralised access to the AlwaysOn availability group so that the moving of the primary role does not present any issues.
And that answers my last question!
New question, whats the benefit of using the AG Listener over the cluster name? after a node failure and failover, the database should still be accessable by either, right?