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

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=”CORPUsername” /SQLSVCPASSWORD=”Password”
/AGTSVCACCOUNT=”CORPUsername”, /AGTSVCPASSWORD=”Password”
/INDICATEPROGRESS

Leave a Reply

Your email address will not be published. Required fields are marked *