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, 2016Neele 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.
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
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.
As we can see the process is not hard to slipstream the latest service pack into your SQL Server 2008 R2 installation
Brilliant quick and useful and worked a treat many thanks
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!
This site uses Akismet to reduce spam. Learn how your comment data is processed.