This project has moved and is read-only. For the latest updates, please go here.

Previous SQL Media Preparation FineBuild Initialisation Next

SQL 2016 Express Edition 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 2016 can only be installed on Windows 8 or Windows 2012 and above.

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

FineBuild works with all variations of Express Edition, but the recommended variation is Express Edition with Advanced Services. SQL FineBuild will automatically detect which Express Edition install file you are using from the list below:

Express Variation Download
SQL Express with Advanced Services 32-bit SQLEXPRADV_x86.EXE
SQL Express with Advanced Services 64-bit SQLEXPRADV_x64.EXE
SQL Express with Tools 32-bit SQLEXPRWT_x86.EXE
SQL Express with Tools 64-bit SQLEXPRWT_x64.EXE
Basic SQL Express 32-bit SQLEXPR_x86.EXE
Basic SQL Express 64-bit SQLEXPR_x64.EXE

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
SQL2016 Folder to contain all SQL Server 2016 install media
FineBuild Install scripts. These are described in FineBuild Components Inventory
Service Packs Service Pack and Hotfix install media
SQL2016_Exp SQL Server install media from Microsoft

SQL 2016 Express Edition Media Folders.png

Install Media Preparation Example

The procedure for preparing the install media for Express Edition is described below.

The download locations given below were correct as of 17 August 2016 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 SQL2016Config.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.

Many of the Wiki pages referred to below do not yet show details for SQL2016. In these cases the details for SQL2014 will apply.

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 SQL2016

3) Copy the FineBuild folder into the SQL2016 folder

4) Create a sub-folder of SQL2016 called SQL2016_Exp

5) Copy into SQL2016_Exp the SQL Server 2016 Express installation file into SQLMedia folder

Pre-Rrequisite 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) Download the following mandatory routines into the Additional Components folder

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

3) 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.

4) If you are planning to install SQL 2016 on Windows 2012, then you must install the latest Service Pack for the operating system before you run FineBuild.

5) If you are planning to install SQL 2016 on Windows 2012 R2 or Windows 8.1, then you must install KB2919355 (also known as Update 1) before you run FineBuild.

The components listed in 4) and 5) are not included in the current version of FineBuild.

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) There are no optional upgrades to the SQL Install Media currently available.

SQL Service Packs and Cumulative Updates

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

1) Create a sub-folder of SQL2016 called Service Packs

2) Download the required Service Pack for SQL Server 2016

At the time of writing, no Service Packs have been released for SQL 2016.

3) 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\SP1). 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 SQL2016Config.xml configuration file holds details of Cumulative Updates up to RTM 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
RTM Latest CU

IMPORTANT As a minimum you should include KB3164398 with your SQL 2016 install media, as this fixes a critical problem with the original RTM install media. If you install SQL 2016 RTM CU1 or higher you do not need to download KB3164398 as this is included in CU1.

For more details see Install SQL Cumulative Update.

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
BOL Local Install See Install SQL Books Online Update Y
Java DBC Driver See Install Java DBC Driver Y
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 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
SSDT-BI See Install SSDT-BI Y
Sumatra PDF viewer See Install PDF Reader Y
Taskpad View custom report See Install Taskpad View Report 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

2) The SQL2016 Express Edition install media is now ready for use.

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

Last edited Aug 24, 2016 at 5:04 PM by EdVassie, version 2