You are here

T-SQL - Get Listener Name on AlwaysOn Cluster

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:

Categories: 
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
3 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer