SQL Server Availability Group – Listener configuration problem

Posted on

Question :


  • 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.

Answer :

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.

Leave a Reply

Your email address will not be published. Required fields are marked *