Archive

Archive for the ‘SQL Server 2008 Installation’ 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

SQL Server 2008 Cluster installation on Windows 2003 Server.

June 14, 2010 Leave a comment

Download the Attachment using the link to check how to install SQL Server 2008 on Windows 2003 Cluster

SQL Server 2008 Cluster installation on Windows 2003 Server