I am a developer trying to work with a new Sql Server 2016 Always On cluster.
In reading documentation I am getting conflicting information.
- Some documentation tells me that I just need to add "failover partner=MySecondaryServer" to my connection string.
- Other sites talk about using an "Listener". And in my Always On section in SSMS 2016 there is an Availability Group Listeners section.
What is the difference between these options?
Are these competing options (meaning you pick just one) or do they work together?
Notes: I have tried the "failover partner" and got limited success. When the primary rebooted, I had to restart my Entity Framework service before it "failed over" to the secondary server. I am thinking about setting up a Listener to see if it will work more dynamically.