Missing Windows Installer cache files prevent SQL Server 2008 R2 Service Pack from installing

When trying to install a SQL Server 2008 & 2008 R2 Service Pack you may see the following error:

1612 The installation source for this product is not 
available. Verify that the source exists and that you can 
access it.

These issues can occur when the Windows Installer database files (.msi) or the Windows Installer patch files (.msp) are missing from the Windows Installer cache, which is located in %windir%\installer.

To resolve this issue go to KB969052 and run the FindSQLInstallsOnly.vbs from a command prompt. The output file sql_install_details.txt will contain information on the missing files and will advise where to copy these missing files to. Follow the instructions and once all the missing files have been replaced re-run the script and the output file should confirm the existance of the missing file(s), it should be similar to the below:

SQLServerXXXXXX.msi exists on the LastUsedSource path, 
no actions needed.

After you have confirmed there are no more missing files re-attempt the SQL Server Service Pack installation and this time it should be successfull. I have seen this issue a handful of times in the past and it is worth noting KB969052 so that you can respond swiftly, especially if you are running according to a tight maintenance window.

Seeing “The current SKU is invalid” when adding another node to a SQL Server 2008 failover cluster

I performed some maintenance work last Sunday which involved adding two new nodes to an existing two-node SQL Server 2008 failover cluster. During the installation of SQL Server 2008 I encountered the following error:

The current SKU is invalid.

This is a known bug and occurs because the installation files include a custom Defaultsetup.ini file that contains the product key (typically a volume license). There is a fix for this bug in Cumulative update package 1 for SQL Server 2008, click here to visit the relevant KB article.

I chose a quick fix which was to open the Defaultsetup.ini file (found in the x64 folder) which should look as below:

:SQLSERVER2008 Configuration File
[SQLSERVER2008]
PID="xxxxx-xxxxx-xxxxx-xxxxx-xxxxx"

Make a note of the product key and then remove everything on the line containing the PID so it looks like this:

:SQLSERVER2008 Configuration File
[SQLSERVER2008]

Save the file and then go through the installation again. The only difference will be that you are required to manually enter the product key as it will not be pre-populated with the value you deleted earlier.

Details of this bug can be found here. and applies to SQL Server 2008. I did notice that others have experienced the same problem with SQL Server 2008 R2 and applied the same fix.