Resolving an Error When Creating an Availability Group Listener

  • gana20m

    SSCrazy

    Points: 2433

    Comments posted to this topic are about the item Resolving an Error When Creating an Availability Group Listener

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the detailed article.

  • gana20m

    SSCrazy

    Points: 2433

    Glad you liked it 🙂

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • Ray Ayyelos

    SSC Enthusiast

    Points: 155

    Hi,

    Thanks for the article.

    As a reminder, if you use an account to run setup that has domain admin permissions (lets face it, this will apply to more people that we care to admit), the object creation limit will not apply. Another well documented cause for 19471 to consider is a change to the default location for new computer objects. If IT or Systems Engineering (whoever maintains A/D) likes to compartmentalize stuff, it is possible that the cluster computer account will be in a OU container where it, itself, won't have permissions to create new computer objects (AG name). Since AG configuration uses the user login account as proxy for access, it may not be object limit. Microsoft makes mention of this. All you need to do is check with A/D administrators and ensure that the cluster account has permissions to the container in which it resides at least for the duration of setup.

    Basically, user login is used as proxy to create new cluster computer object:

    User Login > (has access?) > Create Cluster > New Cluster Computer Object (in container)

    Then, cluster computer object (now not a proxy of setup user login) will attempt to create AGL:

    Cluster Computer Object > (has access?) > Create AG Listener Computer Object (in container)

    The gotcha is the (in container) part. If the location for new computer objects is not default, then the Cluster Computer Object may not have permissions to create the AGL.

    Good luck and welcome to the world of Availability Groups!

  • SQL Surfer '66

    SSCertifiable

    Points: 5152

    Excellent. Thanks. This will save me from trouble in the future.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply