@SQL2TheSequel
Eric B
2 years
Any AG experts out there able to help me with a Listener/IP problem I'm having? My nodes are on different subnets and it isn't doing what I expected. #sqlhelp
1
0
0

Replies

@AngryPets
Michael K. Campbell
2 years
@SQL2TheSequel What are you expecting? vs ... what are you seeing? This can be a bit odd/weird to set up if it's your first multi-subnet AG - but, once you know what you're looking for and how it works, it's pretty straightforward.
1
0
0
@SQL2TheSequel
Eric B
2 years
@AngryPets I see one ip listed as offline in the windows fail over cluster manager, but both on the Listener object in AD. For some users they resolved to the offline ip and couldn't connect. I ended up dropping the second IP to get everyone working.
1
0
0