Slipstream SQL Server 2008 R2 Service Pack 2

One of the new features added to Microsoft SQL Server 2008 and R2 is the ability to slipstream a service pack into the installation. This streamlines the installation, and reduces human error. Now that SQL Server 2008 R2 SP2 is officially out, here’s how to slipstream SQL Server 2008 R2 Service Pack 2. I’ve updated the instructions from the MSDN SQL 2008 R2 SP1 blog article to reflect SP2 filenames.

1. Download SQL Server 2008 R2 SP2 here. Note that you need to download all three architectures (IA64, x64, x86) even if you never plan on using them.

  • SQLServer2008R2SP2-KB2630458-IA64-ENU.exe
  • SQLServer2008R2SP2-KB2630458-x64-ENU.exe
  • SQLServer2008R2SP2-KB2630458-x86-ENU.exe

2. Copy your original SQL Server 2008 R2 media to a folder (e.g. SQL2008R2_SP2), I used the E drive so my path was E:SQL2008R2_SP2.

3. You now need to extract the packages, using the path to where you copied the original source media.

SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:e:\SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:e:\SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:e:\SQL2008R2_SP2SP

4. Replace the original setup.exe with the SP2 version:

robocopy E:\SQL2008R2_SP2SP E:\SQL2008R2_SP2 Setup.exe

5. Copy all of the files, excluding folders and the Microsoft.SQL.Chainer.PackageData.dll file to overwrite the non-SP2 files.

robocopy E:\SQL2008R2_SP2\SP\x86 E:\SQL2008R2_SP2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy E:\SQL2008R2_SP2\SP\x64 E:\SQL2008R2_SP2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll 
robocopy E:\SQL2008R2_SP2\SP\ia64 E:\SQL2008R2_SP2\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

6. To tell the SQL server installer where to find the service pack files you need to update all three DefaultSetup.ini files. They are located under E:\SQL2008R2_SP2x86, x64 and ia64. Add the following line to the end of each file:

PCUSOURCE=”.SP”

7. Your SP2 slipstream media is now complete. Run Setup.exe like you normally would and enjoy an integrated installation of SQL Server 2008 R2 with SP2.

Update: You may get an installation error if installing on a 64-bit server. You may need to rename the sqlncli.msi file in SP1033_ENU_LPx64setupx64 to sqlncli_amd64.msi.

Print Friendly, PDF & Email

Related Posts

6
Leave a Reply

avatar
5 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
5 Comment authors
Casey MDerek SeamanJohnJoeAnonymous Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Anonymous
Guest
Anonymous

Just test this for x64 and did not need to rename the above file name.

Anonymous
Guest
Anonymous

These instructions were perfect! Was able to create a slipstreamed SQL server 2008 R2 with SP2 installation media for my Windows 8 machine. Thank you for posting this!

Joe
Guest
Joe

Anyone else get an error on the x64 install, right at the last bit that advises: A severe error has occurred on the current command. The results if any should be discarded

John
Guest
John

There's a lot of backslashes missing from your paths. I don't know what happened, they used to be there (I know, because I always refer to your documentation when I need to slipstream – & also happen to have a copy saved, which I checked just now). Without the backslashes it's quite confusing.

For example, in step 5 you have the following command lines listed:
robocopy E:SQL2008R2_SP2SPx86 E:SQL2008R2_SP2x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy E:SQL2008R2_SP2SPx64 E:SQL2008R2_SP2x64 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy E:SQL2008R2_SP2SPia64 E:SQL2008R2_SP2ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

Whereas they used to be:
robocopy E:SQL2008R2_SP2SPx86 E:SQL2008R2_SP2x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy E:SQL2008R2_SP2SPx64 E:SQL2008R2_SP2x64 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy E:SQL2008R2_SP2SPia64 E:SQL2008R2_SP2ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

Casey M
Guest
Casey M

The current text above is missing several ""
In step 3.
SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:e:SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:e:SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:e:SQL2008R2_SP2SP

Should be:
SQLServer2008R2SP2-KB2630458-IA64-ENU.exe /x:e:SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x64-ENU.exe /x:e:SQL2008R2_SP2SP
SQLServer2008R2SP2-KB2630458-x86-ENU.exe /x:e:SQL2008R2_SP2SP

Step 4.
robocopy E:SQL2008R2_SP2SP E:SQL2008R2_SP2 Setup.exe

Should be:
robocopy E:SQL2008R2_SP2SP E:SQL2008R2_SP2 Setup.exe

Step 6.
PCUSOURCE=”.SP”

Should be:
PCUSOURCE=”.SP”

Scroll to Top