Installation of SQLServer2005/2008 Fails on Windows2008 Cluster.

Installation of SQLServer2005/2008 on Windows2008 Cluster might fail with error mentioned below

 

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 service or application, 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 installtion of SQLServer 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: https://technet.microsoft.com/en-us/library/cc773451(WS.10).aspx

Regards

Karthick PK