Good day Lucas Peñaloza,
I hope you''ll find something useful in the following explanation, and if it helps you get more insight into the issue, it's appreciated to accept the answer.
Using the Repair Active Directory Object function in Failover Cluster Manager is a safe, supported, and non-destructive operation when performed correctly. However, there are important operational considerations to be aware of to avoid downtime.
Potential Drawbacks & Mitigations:
- The repair process will temporarily take the Cluster Name resource offline. This means client connections relying on the cluster network name (e.g.,
\\ClusterName\Share) will be briefly interrupted. SQL Server client connections using the SQL Server Network Name will drop and must reconnect. Schedule the repair during a maintenance window. Before starting, manually bring the Cluster Name resource offline in a controlled manner to gracefully inform connected clients.
- The repair action requires that the cluster nodes can communicate with each other and with a domain controller. If there are underlying network or cluster communication issues, the repair may fail or hang. You can run
Test-Cluster to validate cluster health before attempting the repair. Ensure all nodes have network connectivity to a domain controller.
- The function resets the
Reset Password and Write permissions for the cluster computer object (CLPWGIRSQL$) to the default. If your environment uses custom permissions on this object, they will be reverted to the defaults. So you need to document any custom permissions before the repair. They can be reapplied afterwards if necessary.
For the procedure to be safe, I recommend:
Pre-Check: In Failover Cluster Manager, under Cluster Core Resources, note which node currently owns the Cluster Name resource.
Initiate Repair:
Right-click the Cluster Name resource.
Select More Actions > Repair Active Directory Object.
If the option is grayed out, you must first right-click and choose Take Offline. Confirm, then the repair option should become available.
Monitor: The resource will go offline, perform the repair (which resets the password and permissions in AD), and then come back online. This typically takes 30-60 seconds.
Verification: After the repair, check the cluster events for a successful operation (Event ID 1207 or similar). Also, verify the cluster name resource is online and that clients can connect.
If the repair function fails or you can't afford any resource downtime, the alternative is the manual password reset method using netdom resetpwd or PowerShell's Reset-ComputerMachinePassword from a domain controller. This can be done without taking the cluster resource offline, but it requires direct domain controller access and may need to be coordinated with the domain administrator.
Should you have any questions, feel free to ask.
VP