While configuring SQL Server 2012 Always on Listener name you may encountered the below issue :
The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057The WSFC cluster could not bring the Network Name resource with DNS name 'ServerName' 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. (Microsoft SQL Server, Error: 41009)
1. Verify the listener AD object has proper permissions or not, If not ask your admins to give proper permissions to that object
2. Later do nslookup of that objet and get the IP address of it and configure the listener with static port of the IP which you got in the nslookup.
3. If that doesn't work then remove the listener from the SQL AG and ask your admins to add DNS to the object first and then add listener at the AG it will work.
The Windows Server Failover Clustering (WSFC) resource control API returned error code 5057The WSFC cluster could not bring the Network Name resource with DNS name 'ServerName' 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. (Microsoft SQL Server, Error: 41009)
1. Verify the listener AD object has proper permissions or not, If not ask your admins to give proper permissions to that object
2. Later do nslookup of that objet and get the IP address of it and configure the listener with static port of the IP which you got in the nslookup.
3. If that doesn't work then remove the listener from the SQL AG and ask your admins to add DNS to the object first and then add listener at the AG it will work.
No comments: