Platforms:
- Windows Server 2016
- SQL Server 2016
- SSMS 2018
Problem:
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:
- cluster1 - Failover cluster virtual network name account
- MACHINE1
- MACHINE2
I couldn't find any clear solution for this problem.