In implementing a SQL Server Always On availability group; I know I’ve run into this issue in the past, so figured I’d document the solution.
The Windows Server Failover cluster was properly created.
The SQL Server Always On Availability Group was created.
Adding the SQL Listener for the AOAG, and received the following:
Here is the error:
The WSFC cluster could not bring the Network Name resource with DNS name ‘<SQLAOAGName>’ online. The DNS name may have been taken or have a conflict with existing name services, or the WSFC cluster service may not be running or may be inaccessible. Use a different DNS name to resolve name conflicts, or check the WSFC cluster log for more information.
The attempt to create the network name and IP address for the listener failed. If this is a WSFC availability group, the WSFC service may not be running or may be inaccessible in its current state, or the values provided for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate the network name and IP address with the network administrator. Otherwise, contact your primary support provider. (Microsoft SQL Server, Error: 19471)
From Users and Computers MMC, enable Advanced Properties.
Pre-create the SQL AOAG Listener name in Active Directory.
Right check the SQL AOAG Listener name > Properties > Security tab
Add the Windows Server Cluster Name (for the SQL HA) Note: enable computer objects
Grant the Windows Server Cluster Name Full Control for the SQL AOAG Listener name
The create listener step should now work.