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?
Tag: failover clustering
PowerShell – Find Active Node On Cluster
PowerShell script that prints out the state of the node you are on – Active or Passive.
Finding Active Node in SQL Server Cluster
The T-SQL method to find the active node that a SQL service is running on:…