Archive

Archive for the ‘Cluster Installation Issues (Part1) Win2008’ Category

The SKU is invalid on Adding Node to SQL Server Failover Cluster

January 15, 2011 Leave a comment

After creating new SQL Server failover cluster node and try doing a failover you will get the error

ERROR:-
The Action ‘move to node xyz’ didn’t complete. An error occurred moving the clustered service or application ‘SQLClusResourcegroup4’. The operation failed because either the specified cluster node is not the owner of the group or the node is not a possible owner of the group.

Reason:

The fail over node may not be designated as a possible owner for all the resources in the group that you want to failover.

Solution:

Add the node on the passive node as “Add node to SQL Server Failover Cluster”

While doing so you may get the error “The current SKU is invalid”

I was able to work around it by running setup.exe from command prompt and it bypasses this issue.

Run the setup from command prompt

  1. Run the command prompt “Run as Administrator”
  2. Code

setup.exe /ACTION=AddNode /INSTANCENAME=”MSSQLSERVER”
/SQLSVCACCOUNT=”CORP\Username” /SQLSVCPASSWORD=”Password”
/AGTSVCACCOUNT=”CORP\Username”, /AGTSVCPASSWORD=”Password”
/INDICATEPROGRESS