I have given wrong name for listener while configuring the always on in SQL Server management studio.

enter image description here

One option I can see is deleting and re-creating the listener, But is it right way of doing it? will it have any side affects?


Updated - After deleting and recreating the listener I am getting following warning.

Cluster network name resource 'abc_xyz' cannot be brought online. Ensure that the network adapters for dependent IP address resources have access to at least one DNS server. Alternatively, enable NetBIOS for dependent IP addresses

  • 1
    Are you Domain Admin? You need elevated privileges since you are creating a DNS entry for the new listener. – IanG Mar 27 '16 at 0:44
  • You don't need to be a Domain Admin to do this. The CNO will need certain permissions in the OU it exists at a minimum in order to create child objects and computer objects. Additionally, even if logged in as an account that was a Domain Admin it would fail to work, as again, the CNO creates the object. My best advice is to pre-stage the listener by having someone with permissions to create a computer object and give the CNO full control over that computer object. The name of the object should be the DNS name of the listener. – Sean Gallardy Apr 6 '16 at 4:35
  • In the failover cluster manager, does the VNN still exist for the availability group's cluster resource? – SQL Hammer Apr 11 '16 at 2:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.