Hey all,
Two servers participating in an Always On configuration.
On Server1, I can connect to Server2's instance; however can not connect locally to Server1's instance.
On Server2, I can connect to Server1's instance; however can not connect locally to Server2's instance.
The same applies with the AG listener. I can only connect to it when it's on the opposite server.
What's odd is that I'm part of an NT group (domain admins) and when I add NT account directly as a sysadmin, I can connect. Also If I drop the domain admins group, put a new group in there that I'm part of, it also works.
So the problem actually appears to be something with the domain admins NT group? I am at a loss on this one ... why can I connect remotely through this group, but not locally and then other groups or individual accounts work just fine!?
Thanks