Fix: “The current SKU is invalid” when adding second node to SQL 2008 Cluster

Quick post, was building a SQL 2008 Active / Passive cluster today on Windows 2003 x64 and got stuck when adding the second node.

Turns out to be a bug in the install media. Microsoft has a hotfix posted but that doesn’t seem to work correctly.

Got the correct fix from here:

http://forums.techarena.in/server-cluster/1032365.htm

The Workaround:

In the install media folder under \x64 find the DefaultSetup.ini file.

Just comment out the key (while you’re in the file copy the key) and put the key in during the installation.

Worked perfectly.

MSA 500 on Windows 2008

I had a HP MSA 500 G1 and G2 Storage array lying around that I got with some DL380 G3’s. I figured I would buy new DL380 G5’s add in a HBA and I would have a nice shiny new cluster for SQL 2008 x64.

I was dead wrong. First the MSA500 with HBA is not even recognized by the OS. Then I used a Smart Array 6402 Storage Controller card and was able to see the MSA500 in the OS. Still no go, Clustering services in Windows 2008 requires some sort of SCSI protocol v3 which the MSA500 cannot do.

Just figured I would save anyone else the pain of having to order and return all of those parts.

I ended up installing Server 2003 x64 and that’s working great.