Slipstream SQL Server 2008 Express with Advanced Services and Service Pack 1
Several folks have recently been asking how to slipstream Express with Advanced Services and Service Pack 1. Here are the instructions. Let me know if you encounter any issues.
1. Download “Microsoft® SQL Server® 2008 Express with Advanced Services
2. Download the SQL Server 2008 Service Pack 1 from here. Ensure download the same architecture as you downloaded in step #1.
<For the test of the steps I will be using the x86 architecture package. The same steps apply for x64, however you will need to use the correct package name>
3. Extract the packages as follows:
SQLEXPRADV_x86_ENU.exe /x:c:\temp\ExprADV
SQLServer2008SP1-KB968369-x86-ENU.exe /x:c:\temp\ExprADV\PCU
4. Run these commands to copy files from the SP1 drop to the original media folder
robocopy c:\temp\ExprADV\PCU\x86 c:\temp\ExprADV\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy c:\temp\ExprADV\PCU c:\temp\ExprADV Setup.exe
robocopy c:\temp\ExprADV\PCU c:\temp\ExprADV Setup.rll
5. Create a defaultsetup.ini file to tell Setup where to find the Service Pack
echo [SQLSERVER2008] > c:\temp\ExprADV\x86\defaultSetup.ini
echo PCUSOURCE="<absolute path to PCU folder>\PCU" >> c:\temp\ExprADV\x86\defaultSetup.ini
Where “<absolute path to PCU folder>” would be c:\temp\ExprADV or \\machine\share if you make the \ExprAdv folder available on a share
6. Additional notes:
a. Run setup.exe in the \ExprADV folder
b. Verify the installation works as expect
c. You can package up the merge folder for distribution