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?
[...]While this seems like a simple thing to do, I recently discovered so many ways not to do it (also known as failing) that I just had to document this one.
[...]If you've painted yourself into the single_user corner, here is how you can get out.
[...]Copyright © 2021 | MH Corporate basic by MH Themes