I can tell you how many times I have heard about this error. This can appear in any of the situation where SQL needs to create a cluster network name resource in the WSFC Cluster. Here are the two situations I can think of:
- Installing SQL Server Failover Cluster instance.
- Creating listener in the AlwaysOn availability group.
Below is the error which was sent by one of my clients. This appeared while creating listener from management studio.
Here is the text of the message.
The WSFC cluster could not bring the Network Name resource with DNS name ‘<DNS name>’ 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. 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.
Above error can be caused due to many reasons which can cause network name or client access point resource in cluster creation to fail. One of the most common cause would be where the Domain Administrator does not allow the CNO “Read All Properties” and “Create computer Objects” permissions. You might see “Access is denied” in the event log.
Here are the steps, which are also known as prestaging of virtual computer object (VCO) in domain controller.
- If possible, connect to domain controller. Ensure that we are logged in as a user that has permissions to create computer objects in the domain.
- Open the Active Directory Users and Computers Snap-in (dsa.msc).
- In Menu > View -> Advanced Features. (Otherwise, we would not see option explained in next steps)
- Right click the OU/Container where we want the VCO to be created and click “New” -> “Computer”
- Provide a name for the object (This will be your SQL Server Network Name in FCI or Listener Name in AG) and click “OK”:
- Right click on the on the VCO which we just created and select “Properties”. Click the security tab and then click “Add”:
- Enter the CNO (Make sure to select “Computers” option in the “Object Types” window) and click “OK”. The CNO is a Cluster Name Object. This is the name of the Windows Cluster name NOT listener or FCI name.
- Give CNO “Full Control” over the VCO.
If all above steps are followed, we should not get access denied and if we try creating Listener, it should be successful.
What are the other errors you have seen while creating listener?
Reference: Pinal Dave (https://blog.sqlauthority.com)