Vidhya Sagar – Blog

In this podcast we are going to install SQL Server 2008 Clustering on Windows server 2008. I’ve already made my both the nodes clustered with Windows server 2008 and the details are below.

Below are the list of SQL Server 2008 editions supporting clustering.

• SQL Server 2008 Enterprise Edition (16-node failover clustering)
• SQL Server 2008 Standard Edition (2-node failover clustering)
• SQL Server 2008 Developer Edition

Download the Video

File Size : 26.2 MB
Video Size: 800 x 600
Duration  : 29:31 min

Issues Faced:

Problem : While adding node 2 to SQL Cluster, I’ve executed the SQL Server 2008 setup on node 1 but it gives the below error.

The current SKU is invalid.

Upon searching in internet I found a issue link in Microsoft connect for this, you can check it here http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036.

Resolution:

Below are the list of workarounds to use to avoid this problem

• Run SQL Server 2008 setup on Node 2 and add that node to SQL Cluster. (I’ve tried this and worked as charm)
• Copy SQL Server 2008 setup to local disk and open DefaultSetup.ini file, copy the product key to some other file and remove the product key from the file. Now run the setup in Node 1 and enter the product key manually when asked in setup wizard.
• Microsoft has a Knowledge base article for this. This has been rectified in SP1, hence install SP1 before installing SQL Server 2008, this will update the setup support files. Check http://support.microsoft.com/kb/957459 for more.