Sunday, September 2, 2012

Error Installing SQL Server Cluster - The cluster resource could not be brought online

Error when creating a SQL Server cluster:



"The following error has occurred:
The cluster resource 'SQL Server (InstanceName)' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)"

The following error shows up in the System event log:


"Cluster network name resource 'resource_name' failed to create its associated computer object in domain 'ad.weil.com' for the following reason: Unable to create 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 'computer_object' 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 'computer_object' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool."



This was due to inadequate permissions for the computer account of the Windows cluster.  The cluster computer object needs the "Read All Properties" and "Create Computer Objects" permission in the domain. Once those permissions were granted, the install completed successfully.

Here is the Microsoft article that details the permissions needed.

No comments:

Post a Comment