I am trying to build a multi subnet sql ag and listener not connecting
Hi
I am trying to build a multi subnet sql ag to upgrade/migrate an old sql, it's my first time and I am trying to build it based on how the existing ag are created in my employer environment.
So we have 2 azure vm each in a different subnet. Each vm has 2 nic, one for vm ip and another to hold the listener ip. This is how existing sql ag vm are configured.
I was somehow able to configure the listener but I am not able to connect to it from any other node other than ssms in primary.
I thought it would be a firewall issue and asked the firewall team to allow connection. But still it looks like it's not working.
NS lookup<listener> does give me both the listener ip but ping or test-netconnect the primary listener ip is failing.
I am able to connect to the primary sql instance via ssms on the secondary node but not with the listener
Can anyone suggest why this is happening ?