Skip to main content
Sign In
San Diego Computer & Network Consulting Experts 
Go Search
 
Home
Our Microsoft Expertise
Our Services
Microsoft Solutions Blog
About Gilham Consulting
Contact Us
Support Portal
  

 

z
Home > Gilham Consulting Microsoft Notepad > Posts > Fixing Invalid SKU Errors When Installing SQL Server 2008 on a Windows 2008 Cluster
Fixing Invalid SKU Errors When Installing SQL Server 2008 on a Windows 2008 Cluster

A weird issue happened to me when installing SQL 2008 on a 4-Node cluster Windows 2008 x64 cluster.

After having issues installing from an extracted ISO, I had to manually install .Net framework 3.5 and Windows Installer 4.5 hotfixes from the redist directory of the SQL install. Thought I was in the clear, when 2 of the 4 nodes wouldn't let me install SQL 2008 failing with an "Invalid SKU" error.

The solution found on Microsoft's site was:

The solution to adding second time is add the additional node(s) with command line from the SQL 2008 source files:

setup.exe /q /ACTION=AddNode /INSTANCENAME="<Insert Instance Name>" /SQLSVCACCOUNT="<SQL account used on other nodes>" /SQLSVCPASSWORD="<password for SQL account>" /AGTSVCACCOUNT="<SQL Server Agent account used on other nodes>", /AGTSVCPASSWORD="<SQL Server Agent account password>"

Reference:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036

Comments

found a good fix

I found this command and it allowed me to install easily

setup.exe /ACTION=AddNode /INSTANCENAME="MSSQLSERVER"

taken from the bottom of this thread:

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/13a256b0-b95b-46a7-92d5-17a0b763f8dd/
at 12/19/2008 9:36 PM

How to fix invalid SKU error in sql 2008 cluster node setup

Another work around for this is to uninstall the 2008 support files after each node install and let the installer reinstall them clean for each node (instance) added.
at 8/11/2009 8:26 PM

Two Instances

Hi all,

I have installed SQl server2008 twice on my machine. when I installed for the First time some components was missing. So I installed second time but by mistake I installed with another instance name. As i have Windows7 installed on my machine there is some compatibility issue with SQL server2008. I have downloaded the service pack for that and tried to install it but getting error:

TITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

A failure was detected for a previous installation, patch, or repair for instance 'UMESHSQL2008' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,Analysis_Server_Full,RS_Server_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

Error code 0x84B20001.

Please help me why this is happening..

Thanks
at 4/16/2010 3:55 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


CommentUrl


Attachments

 Latest Reader Comments

OCS 2007 R2 support for SQL 2008 DB mirroringSQL Server 2008 Mirroring in Standard Edition
what about iPhone 4.0?Configuring Exchange Server 2007 ActiveSync for iPhone OS 3.1 (and prior)
CAS Array in Hyper-VHow to setup an Exchange 2010 CAS Array to Load Balance MAPI
Disallow all agents except SharePoint?Useful SharePoint 2007 (MOSS 2007 SEO) configuration with robots.txt file for public facing SharePoint 2007 sites.
Cloud PBXMicrosoft OCS 2010 Is Coming To Unified Communications, PBX Killer
smart cardHow To: Configure Microsoft Remote Desktop Client and Smart Card Authentication
Profiles missing from ImportImporting and Deleting User Profiles in Sharepoint;Filtering Disabled Users from Import; Managing MySite of Deleted Users
Thank youManual Uninstall of SQL 2005 (32bit / 64bit) SQL Server or Express (including Reporting Services)
Auto-deletes all mysites after Full Import ScheduleImporting and Deleting User Profiles in Sharepoint;Filtering Disabled Users from Import; Managing MySite of Deleted Users
PerfectManual Uninstall of SQL 2005 (32bit / 64bit) SQL Server or Express (including Reporting Services)

 Subscribe and Bookmark

 Last 20 Articles

Category
SharePoint 2010 Search Features (Including FAST)
Sharepoint 2010
 
Remote Desktop Connection Manager (RDCMan)
Windows Deployment
 
SharePoint Server 2010 Product Licensing Details
Sharepoint 2010
 
Manage Windows 7 Power Options from the Command Line
Windows Deployment
 
Download details: Windows Phone 7 Training Kit for Developers - April 2010 CTP
Windows Mobile
 
Clustering Remote Desktop Connection (RDC) Broker for High Availability when Deploying Microsoft VDI
Virtualization
 
SharePoint 2010 Reference .Net Software Development Kit (SDK)
Sharepoint 2010
 
Microsoft Private Cloud “AppFabric” Prepares for Release
Cloud Computing
 
Malware and Virus Scanning Architecture in Forefront Threat Management Gateway (TMG) 2010
Security
 
Best Practices Analyzer (BPA) for HYPER-V (RTM and R2)
Virtualization
 
Microsoft Threat Management Gateway (TMG) 2010 - Key Features & Capabilities
Security
 
The forecast is sunny for [Microsoft] cloud services.
Cloud Computing
 
Microsoft announces "RemoteFX," the Calista-based Hyper-V-requiring PC-over-IP competitor
Virtualization
 
Dynamic Memory (aka Memory Overcommit) Coming To Hyper-V
Virtualization
 
SharePoint Overwhelms Business Intelligence - Gartner
Sharepoint 2010
 
Active Directory Power Tool: AD Explorer (and Editor)
Active Directory
 
Protect your Business Information for Free using Encrypting File System (EFS)
Security
 
How to: Integrate Office Communications Server (OCS) 2007 R2 with Exchange 2010 OWA/CAS
Exchange 2010
 
Microsoft Forefront Identity Manager (FIM) 2010 Released
Security
 
Microsoft Thinks VDI Might Not be the Answer to Every Desktop Scenario
Windows Deployment
 


Contact Us  |   San Diego, California

Copyright 2007-2009 Gilham Consulting - All rights reserved