Detailed investigation showed it was a permission issue in the Active directory. We were getting following error in even viewer:
Start of Logs
Cluster network name resource 'SQL Network Name (SQL Cluster Name)' failed to create its associated computer object in domain 'Domain Name' for the following reason: unable to update the password for computer account.
The text for the associated error code is: Access is denied.
Please work with your domain administrator to ensure that:
- The cluster identity 'Windows Cluster Name$' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'Windows Cluster Name$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
End of Logs
We consulted with our system team and the following link and were able to resolve the issue
Thank you.