Windows server 2008 iso free download - Windows 7 and Windows Server 2008 R2 SP1 ISO, Windows Server 2003 R2 Platform SDK ISO Download, ISO Mounter for Windows Server, and many more programs. You have been tasked to install SQL Server 2008 R2 on a server and you need to have the latest Service Pack as well, but want to accomplish it in one.

Aug 5, 2016

How To Slipstream SQL Server 2008 R2 and SQL Server 2008 R2 SP3

Introduction

Neele neele ambar par mp3 song download 320kbps. You have been tasked to install SQL Server 2008 R2 on a server and you need to have the latest Service Pack as well, but want to accomplish it in one installation. Well no fear slipstream to the rescue. In this post we will cover how to slipstream SQL Server 2008 R2 SP3 to a fresh SQL Server 2008 R2 installation.

What You Need

  • SQL Server 2008 R2 installation media
  • SQL Server 2008 R2 SP3
Sql server 2008 r2 iso

Download SQL Server 2008 R2 SP3 from https://www.microsoft.com/en-us/download/details.aspx?id=44271

SQLServer2008R2SP3-KB2979597-x64-ENU.exe
SQLServer2008R2SP3-KB2979597-x86-ENU.exe

Perform The Slipstream

Here are the steps:

For this post I have used C:SQLServer2008R2 as my location for the media and patch, replace with your choice of directories.

Copy your original SQL Server 2008 R2 source media to C:SQLServer2008R2.

Extract each of the SQL Server 2008 SP3 packages to C:SQLServer2008R2SP as follows:

2
robocopyC:SQLServer2008R2SPx86C:SQLServer2008R2x86/XF Microsoft.SQL.Chainer.PackageData.dll
robocopyC:SQLServer2008R2SPx64C:SQLServer2008R2x64/XF Microsoft.SQL.Chainer.PackageData.dll

Determine if you have a DefaultSetup.INI at the following locations:

C:SQLServer2008R2x86
C:SQLServer2008R2x64

If you have a DefaultSetup.INI at the above locations, add the following lines to each DefaultSetup.INI:

If you do not have a DefaultSetup.INI, create one with the following content:
;SQLSERVER2008 R2 Configuration File

2
PCUSOURCE='.SP'

and copy to the following locations
C:SQLServer2008R2x86
C:SQLServer2008R2x64

This file will tell the setup program where to locate the SP source media that you previously extracted.

Run setup.exe as normal.

Conclusion

As we can see the process is not hard to slipstream the latest service pack into your SQL Server 2008 R2 installation

  1. Brilliant quick and useful and worked a treat many thanks

  2. This is brilliant! I had to install replication as an addition to a pre-existing SQL 2008 R2 install that was updated to SP3 long after the original install. Replication services wouldn’t install for me on this server until I discovered this gem and ran through the above process. This was a HUGE help!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

modelaserq.netlify.app© 2020