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

” from x86 or x64.

 

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