0

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error

None of the IP addresses configured for the availability group listener can be hosted by the server 'Cluster'. Either configure a public cluster network on which one of the specified IP addresses can be hosted, or add another listener IP address which can be hosted on a public cluster network for this server.

This kind of error comes when there are two subnets and only one was included in the listener . Under the cluster validation there is also a warning that RegisterAllProvidersIP should be 0 instead of 1. I am clueless as this is in the same data center. I can create the AG and listener when I exclude the 'Cluster' but when I include the server 'Cluster' I get the above error.

Any advice will be greatly appreciated.

Improve this question
3
  • This might helpful: dba.stackexchange.com/questions/80671/…
    – CR241
    Dec 5, 2018 at 18:58
  • Thanks I went through those but i have the same subnet and this error should not happen with same subnets
    – SQL_NoExpert
    Dec 5, 2018 at 18:59
  • Your subnet definitions are incorrect, somewhere. Please update the question with the output from each cluster network interface (IPv4 only) ip address and subnet mask or CIDR value and the values you're setting the listener to. Without those pieces of information it is impossible to tell.
    – Sean Gallardy
    Dec 7, 2018 at 4:05

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.