This project has moved. For the latest updates, please go here.

Previous SQL Media Preparation FineBuild Initialisation Next

SQL 2008 R2 Media Preparation

Before FineBuild can be used, the install media must be prepared. This section explains what needs to be done.

Overview

The install media preparation includes downloading the items below. Ensure you comply with your site standards regarding downloading, virus checking and licensing of this software.

SQL Server 2008R2 can be installed on Windows XP or Windows 2003 through to Windows 8.1 or Windows 2012 R2. It can not be installed on Windows 10 or Windows 2016.

Mandatory Items SQL Server Install Media
Pre-Requisite media
Optional Items Upgrades to SQL Install Media
SQL Service Packs and Cumulative Updates
Microsoft and Community Components

Each of the editions Express, Workgroup, Web, Standard, Enterprise, Data Center, and Developer Editions has its own install media. You should obtain the correct media for the edition you want to install.

When the preparation is complete, the install media will contain the folders shown below, but you can also use SQL Media Alternative Folder Names.

Folder Description
SQL Install Top-level folder containing all SQL Server install media
Additional Components Additional Microsoft and community components used in this build
SQL2008R2 Folder to contain all SQL Server 2008R2 install media
FineBuild Install scripts. These are described in FineBuild Components Inventory
Service Packs Service Pack and Hotfix install media
SQL2008R2_Ent SQL Server install media from Microsoft

SQL 2008 R2 Media Folders.png

Install Media Preparation Example

The procedure for preparing the install media for Enterprise Edition is described below. A similar process is used to prepare the install media for all other SQL Server Editions except for Express Edition. Please see SQL Media Alternative Folder Names for the folder names to use for other SQL Server editions.

The download locations given below were correct as of 17 August 2016, but they may change if new versions of these components are released or non-English versions are downloaded. The file names given in the SQL2008R2Config.xml configuration file for these components should be updated if the file name of a component has changed. Products that have national language support for at least one non-English language are shown by a NLS value of Y.

Mandatory Items

The following items must be completed before FineBuild can be used.

SQL Server Install Media

This section prepares the SQL install media for use by FineBuild.

1) Create a folder on a Network Drive. This can be called SQL Install or any other name you prefer.

2) Create a sub-folder called SQL2008R2

3) Copy the FineBuild folder into the SQL2008R2 folder

4) Create a sub-folder of SQL2008R2 called SQL2008R2_Ent

5) Copy into SQL2008R2_Ent the contents of install media DVD for SQL Server 2008 R2 Enterprise Edition. If your install media is in an ISO file, this can be browsed using Pismo File Mount.

Pre-Requisite media

The following items are required in order to allow the SQL Server install to run

1) Create a sub-folder of SQL Install called Additional Components
  • This folder is used to hold all additional install media. For some components, you will be told to put the media into a sub-folder of Additional Components.
  • The same Additional Components folder can be used for all versions of FineBuild.
2) If you are installing on Windows XP or Windows 2003, you must install the latest Service Pack for the operating system, andalso install the following components:

Component Download Location NLS
Windows 2003 Permissions fix See Install Windows 2003 KB933789 N
Windows 2003 Filestream Fix See Install Windows 2003 KB937444 N

3) If you are installing on Windows 8 or Windows 2012 or above, you must install the latest Service Pack for the operating system, andalso install the following components:

Component Download Location NLS
.Net 3.5 See Install .Net 3.5 Y

4) It is recommended that the version of NTRIGHTS.EXE and REG.EXE supplied with FineBuild are replaced by versions from a trusted source. See Setup Utilities for details.

Optional Items

The following items are optional. If you do not want a given component then do not download it.

Upgrades to SQL Install Media

FineBuild can optionally upgrade various components supplied in the SQL install media to more recent versions. If you want to take advantage of this, then download the components listed below.
1) Download the follolwing recommended updates to the SQL Server install media

Component Download Location NLS
.Net 4.0 See Install .Net 4.0 Y
.Net 4.5 See Install .Net 4.5 Y
Powershell V2 See Install PowerShell V2 N

2) If you Install .Net 4.0 on Windows 2003, you must also Install KB925336.

SQL Service Packs and Cumulative Updates

FineBuild can optionally include SQL Server Service Packs and Cumulative Updates in the SQL install process.

1) Download the required Service Pack for SQL Server 2008 R2

The Service Pack must be placed in a sub-folder of the \Service Packs folder, as shown in the table below. All Service Packs are cumulative, so if you want to install Service Pack 3 you do not need to also install the previous Service Packs.

Component Sub Folder Download Location NLS
SQL 2008 R2 SP3 SP3 KB2979597 Y
SQL 2008 R2 SP2 SP2 KB2630458 Y
SQL 2008 R2 SP1 SP1 KB2528583 Y

For more details see Install SQL Service Pack.

2) Download the required Cumulative Update for the Service Pack

The Cumulative Update must be placed in the same folder as the Service Pack (eg \Service Packs\SP3). All Cumulative Updates for a Service Pack are cumulative, so if you install Cumulative Update 5 you do not need to also install the previous Cumulative Updates.

The SQL2008R2Config.xml configuration file holds details of Cumulative Updates up to SP3 CU1. If additional Cumulative Updates have been downloaded, update the configuration file accordingly.

The table below gives the KB Article to find the list of Cumulative Updates for your Service Pack.

Service Pack Cumulative Update List
SP3 No list is available
SP2 KB2730301
SP1 KB2567616
RTM KB981356

For more details see Install SQL Cumulative Update.

3) Download the SQL Server Native Client (SNAC) update, if one has been published for the CU.

See Install SNAC update for details.
4) Special items for SQL 2008 R2 SP3

If you download SQL 2008 R2 SP3, it is recommended that you also download the fix below into the Service Packs\SP3 folder. This is known within FineBuild as CU2 for SP3, and is the most recent publicly available fix for SQL Server 2008 R2, and provides support for TLS 1.2 for SQL 2008R2.

Component Download Location NLS
SP3 Security Fix KB 3135244 https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3144114&kbln=en-us Y

Microsoft and Community Components

FineBuild can optionally include various Microsoft and Community components in the SQL install process.

1) Download the following Microsoft and Community components into the Additional Components folder. If you do not want a given component then do not download it.

It is suggested that where any of the Community components are used, a donation is made to the author of the component

Component Download Location NLS
Baseline Configuration Analyzer See Install Baseline Configuration Analyzer N
BIDS Helper See Install BIDS Helper N
DTS Backup 2000 See Install DTS Backup 2000 N
DTS Designer See Install DTS Designer N
Extended Events Manager See Install Extended Events Manager N
Java DBC Driver See Install Java DBC Driver Y
MDX Studio See Install MDX Studio N
Notification Services See Install Notification Services N
OLE Provider for DB2 See Install OLE Provider for DB2 N
Plan Explorer See Install Plan Explorer N
Plan Explorer SSMS Addin See Install Plan Explorer SSMS Addin N
Report Viewer Component See Install Report Viewer N
RML Utilities See Install RML Utilities N
RS Linked Report Generator See Install Linked Report Generator N
RS Scripter See Install Reporting Services Scripter N
SQL Cache Manager See Install SQL Cache Manager N
SQL Internals Viewer See Install SQL Internals Viewer N
SQL Nexus See Install SQL Nexus N
SQL Performance Dashboard See Install SQL Performance Dashboard N
SQL Server Best Practice Analyzer See Install SQL Best Practice Analyzer N
SSIS Dimension Merge SCD See Install SSIS Dimension Merge SCD N
SSIS Raw File reader See Install SSIS Raw File Reader N
StreamInsight See Install StreamInsight Y
Sumatra PDF viewer See Install PDF Reader Y
System Views Map See Install System Views Map N
Taskpad View custom report See Install Taskpad View Report N
Visual Studio 2005 SP1 fix for SQL 2008 R2 See Install VS 2005 SP1 KB954961 N
Windows Access Based Enumeration See Install Access Based Enumeration N
Windows Process Explorer See Install Process Explorer N
Windows Process Monitor See Install Process Monitor N
XML Notepad 2007 See Install XML Notepad N
ZoomIt See Install ZoomIt N

3) The SQL2008 R2 Enterprise Edition install media is now ready for use.

Copyright FineBuild Team © 2011 - 2016. License and Acknowledgements
Previous SQL Media Preparation Top FineBuild Initialisation Next

Last edited Aug 24, 2016 at 5:12 PM by EdVassie, version 17