T-SQL – Get Listener Name on AlwaysOn Cluster benjf.com.blog@benjf.com, 2016-05-25 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? Books Online: https://msdn.microsoft.com/en-us/library/hh231289.aspx 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? You can use your GUI to find the listener name, or you can do it the quick way using T-SQL, like this: SQL Server alwaysonfailover clusteringhigh availabilityTSQL