• Windows Server 2016
  • SQL Server 2016
  • SSMS 2018


enter image description here

Create failed for Availability Group listener 'lsn'.

None of the IP addresses configured for the availability group listener can be hosted by the server 'MACHINE1'. 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.

I have three machines:

  • the first machine runs Active Directory
  • the second machine is named MACHINE1
  • the third machine is named MACHINE2.

The machines are nodes for SQL Server.

My machines, user and cluster are added to Active directory in a OU and they have necessary permissions. IPv4 configuration is complete as well.

My Active Directory looks like this:

enter image description here

  • cluster1 - Failover cluster virtual network name account

I couldn't find any clear solution for this problem.

1 Answer 1


In order for the IP address to be brought online, three requirements must be met (among others, but these are the most relevant to this error):

  • At least on of the listener IP addresses must be in the same subnet as one of the cluster networks.
  • The cluster network that is in the same subnet as the listener IP address must be configured as a public network (will add more details in a few minutes).
  • The IP address must not be in use on the network.

You can view and configure the cluster networks in Failover Cluster Manager. Expand the cluster and select the Networks node to see the networks. Right-click on a network and select properties. Ensure that "Allow clients to connect through this network" is enabled on all networks that are used by listener IP addresses.

If you need further help, please add more detail to the question regarding the network and IP configuration of the nodes and the listener. The only useful information in your question at this point is the error message, so that's all I have to go on.

  • Hi sir, I checked my Failover Cluster Manager and it enabled. My addresses are: (active directory), (node1), (node2) and my subnet is ( for cluster network. And my cluster's ip is So I'm trying to give for listener while I configuration to AO. My nodes' dns are configured like my active directory machine's ip. Gateway ip is for all and subnet mask is for all machines.
    – jrdba
    Commented May 1, 2020 at 17:05
  • 1
    You can't use the same IP address for the cluster IP and the listener. Commented May 1, 2020 at 18:04
  • Syntax error. Cluster is, and listener
    – jrdba
    Commented May 1, 2020 at 18:06
  • The only other thing I can think of is that is already in use on the network. I don't know what else would cause this error. Commented May 1, 2020 at 18:09
  • I tried .20, .55, ... but it doesn't work...
    – jrdba
    Commented May 1, 2020 at 18:27

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.