Troubleshooting AlwaysOn availability group listener creation in SQL Server 2012

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard More

Summary


When you cannot create a Microsoft SQL Server 2012 AlwaysOn availability group listener, it is frequently a symptom of other problems in which you cannot create an object in Active Directory or register IP addresses in DNS. These problems usually occur because of the domain policy, or because of a lack of permissions for the Windows cluster to interact with Active Directory or DNS.

When you create a listener in SQL Server, Windows cluster creates a client access point resource. If SQL Server cannot create a listener, it may be unable to report the cause because Windows cluster is creating the resource. In this situation, you can collect the Windows cluster log and Windows System event log in order to diagnose the cause.

If you cannot create a listener, it is usually because of at least one of the following reasons:
  • You do not have sufficient Windows cluster permissions to create and change an Active Directory cluster name account.
  • You cannot register the IP address in DNS because of certain problems that involve a duplicate or invalid IP address.
  • You violate the Windows policies.
This article discusses the steps that you can perform in order to diagnose a failed attempt to create a listener if SQL Server cannot report the cause. Additionally, this article lists some error messages that you may see when the availability group listener creation fails.

More Information


SQL Server may not report the cause when you cannot create an availability group listener

When you create an availability group listener by using SQL Server Management Studio's Add Listener dialog box, you may receive an error message that includes information about the cause of the error, which can help you to resolve the issue. For example, you receive an error message about an incorrect IP address for the subnet that resembles the following:

The specified IP Address '<IP Address>' is not valid in the cluster-allowed IP range. Check with the network administrator to select values that are appropriate for the cluster-allowed IP range. (Microsoft SQL Server, Error: 19457)

Image 1

However, you may also receive an error message that does not explain why you cannot create the group listener. For example, when you try to create an availability group listener, you receive an error message that resembles the following, which does not specify the actual cause of the error:

Msg 19471, Level 16, State 0, Line 2
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.

Msg 19476, Level 16, State 4, Line 2
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.
Image 2