Tuesday, May 10, 2016

Clustered role has exceeded its failover threshold.


Error: Clustered role 'SQL Server (MSSQLSERVER)' has exceeded its failover threshold.  It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state.  No additional attempts will be made to bring the role online or fail it over to another node in the cluster.  Please check the events associated with the failure.  After the issues causing the failure are resolved the role can be brought online manually or the cluster may attempt to bring it online again after the restart delay period.

Solution:
In the Active Directory Open the OU that hold the clustering and from the properties choose the security tab and then add the Cluster computer name.
Allow the Cluster computer name to create child objects.