failover clustering

T-SQL – Get Listener Name on AlwaysOn Cluster

May 25, 2016 | 0 Comments

When using AlwaysOn, you must connect using your listener name, not your node name.  If you connect with the node name, it will only work until there is a failover, which would defeat the purpose of your High Availability setup, right?

[...]