Slipstreaming SQL 2008 with SP2

Though there are lot of articles on how to slipstream a SQL 2008 Setup with a Service Pack for installation. e.g. https://support.microsoft.com/kb/955392/en-us   or https://www.bing.com/search?q=SQL+2008+Slipstream I will add another one here with detailed Step by Step instruction.

 

Use the following steps to create a slipstream merge drop and install SQL 2008 Server with SP2

  1. Create the slipstreamed  media source with the following commands.

'Copy the RTM binary files and all subfolders to E:\SQL2008EE_SLIPPED

‘To extract the SP2 files run the following commands from a command prompt:

SQLServer2008SP2-KB228506:8-IA64-ENU.exe /x:E:\SQL2008EESP2\ia64

SQLServer2008SP2-KB2285068-x64-ENU.exe /x:E:\SQL2008EESP2\x64

SQLServer2008SP2-KB2285068-x86-ENU.exe /x:E:\SQL2008EESP2\x86

 

‘Now copy the current setup.exe and setup.rll

copy E:\SQL2008EE\SQL2008EESP2\x86\setup.exe E:\SQL2008EE_SLIPPED /y

copy E:\SQL2008EE\SQL2008EESP2\x86\setup.rll E:\SQL2008EE_SLIPPED /y

 

‘delete files that must not exist:

del E:\SQL2008EE\SQL2008EESP2\ia64\Microsoft.SQL.Chainer.PackageData.dll

del E:\SQL2008EE\SQL2008EESP2\x64\Microsoft.SQL.Chainer.PackageData.dll

del E:\SQL2008EE\SQL2008EESP2\x86\Microsoft.SQL.Chainer.PackageData.dll

 

‘Create new folder:

Md E:\SQL2008EE_SLIPPED\pcu\ia64

Md E:\SQL2008EE_SLIPPED\pcu\x64

Md E:\SQL2008EE_SLIPPED\pcu\x86

 

‘copy the sp files:

copy E:\SQL2008EESP2\ia64\ia64\*.* E:\SQL2008EE_SLIPPED\pcu\ia64 /y

copy E:\SQL2008EESP2\x64\x64\*.*  E:\SQL2008EE_SLIPPED\pcu\x64 /y

copy E:\SQL2008EESP2\x86\x86\*.*  E:\SQL2008EE_SLIPPED\pcu\x86 /y

 

Change all DefaultSetup.ini files and add PCUSOURCE=.\PCU

The DefaultSetup.ini files are found in each architecture folder (E:\SQL2008EE_SLIPPED\architecture) and should look like this after editing:

 ;SQLSERVER2008 Configuration File
[SQLSERVER2008]
PID="xxxxx-xxxx-xxxxx-xxxxx-xxxxx"
PCUSOURCE=".\PCU"

 'Now you can run the setup.

Cd E:\SQL2008EE_SLIPPED\

setup.exe