Cluster events on SQL 2016

  • We are getting this error below in the cluster event:

    " The computer object associated with the cluster network name resource 'Cluster Name' could not be updated in domain  during the Password change operation.

    The text for the associated error code is: Access is denied.

    The cluster identity may lack permissions required to update the object. Please work with your domain administrator to ensure that the cluster identity can update computer objects in the domain."

    But, we are able to connect to SQL Instances without any issue, can this error be fixed if the cluster is provided the full control on CNO?

    Thanks in advance.

     

     

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Did you get any joy on this??

    I am getting this error too.

    The computer object associated with the cluster network name resource 'Cluster Name' could not be updated in domain 'xxxxz.local' during the

    Password change operation.

    The text for the associated error code is: Access is denied.

    The cluster identity 'MYSQLCLUS$' may lack permissions required to update the object. Please work with your domain administrator to ensure that the cluster identity can update computer objects in the domain.

    This has been working since mid may but today failed every hour no permission have been changed.

     

     

  • You must check permissions in AD, maybe objects have been moved to different OUs with different permissions attached to them. For this to work the CNO (Cluster Name Object = AD-Object with name of the Windows Clusters) in AD needs Full Control on any of the VCOs (Virtual Computer Objects = AD-Object with the name of the SQL-Instances)

    You should give your AD-Admins the following article and have them check that all the required permissions are still in place.

    see also https://docs.microsoft.com/en-us/windows-server/failover-clustering/prestage-cluster-adds

Viewing 4 posts - 1 through 3 (of 3 total)

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