Installation of SQLServer2005/2008/2012 Fails on Windows2008 Cluster.
Posted by Karthick P.K on March 26, 2009
Installation of SQLServer2005/20082012 on Windows2008/2012 Cluster might fail with error mentioned below
Erorr1
The following error has occurred:
The cluster resource SQL Server could not be brought online due to an error bringing the dependency resource ‘SQL Network Name ( )’ online. Refer to the Cluster Events in the Failover Cluster Manager for more information.
Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.
——————————
Erorr2:
The cluster identity ‘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 ‘SCLUSTERNAME$’ has ‘Full Control’ permission to that computer object using the Active Directory Users and Computers tool.
ERR [RES] Network Name <SQL Network Name (VSServerName)>: Computer account VSServerName couldn’t be re-enabled. status 5
INFO [NM] Received request from client address ASPMB9000D05N1.
INFO [NM] Received request from client address ASPMB9000D05N1.
ERR [RHS] Online for resource SQL Network Name (VSServerName) failed.
INFO [RCM] HandleMonitorReply: ONLINERESOURCE for ‘SQL Network Name (VSServerName)’, gen(2) result 5018.
INFO [RCM] TransitionToState(SQL Network Name (VSServerName)) OnlinePending–>ProcessingFailure.
ERR [RCM] rcm::RcmResource::HandleFailure: (SQL Network Name (VSServerName))
ERR [RES] Network Name <SQL Network Name (VSServerName)>: Unable to create computer account VSServerName on DC \\ay.xz.dc, in default Computers container, status 5
Cause
When you create a new clustered network name, a computer object (computer account) for that clustered service or application must be created in the Active Directory domain.
This computer object is created by the computer object of the cluster itself. This computer abject of the cluster is responsible for creating the computer object for "SQL Virtual Server" in active directory . If the computer object of the cluster itself does not have the appropriate permissions, it cannot create or update the computer object for "SQL Virtual Server" . So the installation of SQL Server would fail.
To resolve this issue Grant "Create Computer Objects" permission for the computer object created for the cluster (Computer Name object(CNO)).
For additional info on this Refer: http://technet.microsoft.com/en-us/library/cc773451(WS.10).aspx
Regards
Karthick PK
MSSQLWIKI 
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] Installation of SQLServer2005/2008 Fails on Windows2008 Cluster. […]
Maximum Shred said
Thankss foor sharing your info. I truly appreciate
your efforts and I will be waitng for your next write ups
thanks once again.