SQL 2005 Media Preparation
| Previous SQL Media Preparation | FineBuild Initialisation Next |
|---|
Before FineBuild can be used, the install media must be prepared. This section explains what needs to be done.
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 2005 can only be installed on Windows XP or Windows 2003 through to Windows 7 or Windows 2008 R2. It can not be installed on Windows 8 or Windows 2012 or above.
The install media for SQL Server 2005 supplied by Microsoft is is normally downloaded from the internet or supplied on a single DVD. Some old install media is supplied on 2 CDs. Each edition of SQL Server 2005 (e.g. Standard Edition 32-bit, Enterprise Edition 64-bit) has its own set of install media. 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 |
| Site SQL Files Folder | Repository for files needed for a large-scale rollout of SQL FineBuild |
| Additional Components | Additional Microsoft and community components used in this build |
| SQL2005 | Folder to contain all SQL Server 2005 install media |
| FineBuild | Install scripts. These are described in FineBuild Components Inventory |
| Service Packs | Service Pack and Hotfix install media |
| SQL2005_Dev_X64 | SQL Server install media from Microsoft |
The procedure for preparing the install media for 32-bit Developer 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 19 December 2020, but they may change if new versions of these components are released or non-English versions are downloaded. The file names given in the SQL2005Config.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.
The following items must be completed before FineBuild can be used.
This section prepares the SQL install media for use by FineBuild.
-
Create a folder on a Network Drive
This can be called SQL Install or any other name you prefer
-
Create a sub-folder of SQL Install to hold files needed for a large-scale rollout of SQL Server
This can have any name you prefer. See [Site SQL Files Folder](Site SQL Files Folder) for details
-
Create a sub-folder of SQL Install called SQL2005
-
Copy the SQL 2005 FineBuild folder into the SQL2005 folder
-
Create a sub-folder of SQL2005 called SQL2005_Dev_X64
-
Copy the following folders into the SQL2005_Dev_X64 folder:
Source Destination Servers folder from DVD media, or contents of CD1 SQL2005_Dev_X64\Servers Tools folder from DVD media, or contents of CD2 SQL2005_Dev_X64\Tools If your install media is in an ISO file, this can be browsed using Pismo File Mount
The following items are required in order to allow the SQL Server install to run
-
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
-
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
-
If you are installing on Windows Vista or Windows 2008 or above:
There are no pre-requisite components that need to be installed on these operating systems
-
If you are installing on Windows XP or Windows 2003:
You must install following components either before or as part of running SQL FineBuild:
Component Download Location NLS Windows 2003 Permissions fix See Install Windows 2003 KB933789 N
The following items are optional. If you do not want a given component then do not download it.
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.
-
Download the follolwing recommended updates to the SQL Server install media
Copy the files into the Additional Components folder
Component Download Location NLS Windows Installer 4.5 See Install Windows Installer 4.5 N .Net 3.5 See Install .Net 3.5 Y .Net 4.0 See Install .Net 4.0 Y Powershell V2 See Install PowerShell V2 N -
If you Install .Net 4.0 on Windows 2003:
You must also Install KB925336
FineBuild can optionally include SQL Server Service Packs and Cumulative Updates in the SQL install process.
-
Create a sub-folder of SQL2005 called Service Packs
-
Download the required Service Pack for SQL Server 2005
The Service Pack must be placed in a sub-folder of the SQL2005\Service Packs folder, as shown in the table below. All Service Packs are cumulative, so if you want to install Service Pack 4 you do not need to also install the previous Service Packs.
Component Sub Folder Download Location NLS SQL 2005 SP4 SP4 KB2463332 Y SQL 2005 SP3 SP3 KB955706 Y SQL 2005 SP2 SP2 KB921896 Y SQL 2005 SP1 SP1 FineBuild does not support installing SQL 2005 SP1 Y For more details see Install SQL Service Pack
-
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\SP4). 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 SQL2005Config.xml configuration file holds details of Cumulative Updates up to SP4 CU5. 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. Note that SP4 CU4 and CU5 are security patches not shown in the CU list for SP4.
Service Pack Cumulative Update List SP4 KB2485757 SP3 KB960598 SP2 KB937137 For more details see Install SQL Cumulative Update
-
Special items for SQL 2005 SP4
If you download SQL 2005 SP4, it is recommended that you also download the fix below into the Service Packs\SP4 folder. This is known within FineBuild as CU5 for SP4, and is the most recent publicly available fix for SQL Server 2005
Component Download Location NLS SP4 Security Fix KB 2716427 KB2716427 Y If the Business Intelligence Development Studio (BIDS) component is included in the SQL 2005 install and you also install SP4, then you must also Install Visual Studio 2005 SP1
FineBuild can optionally include various Microsoft and Community components in the SQL install process.
-
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 BOL Update Jan 2009 See Install SQL Books Online update Y DTS Backup 2000 See Install DTS Backup 2000 N DTS Designer See Install DTS Designer N Java DBC Driver See Install Java DBC Driver Y MDX Studio See Install MDX Studio N OLE Provider for DB2 See Install OLE Provider for DB2 N Plan Explorer See Install Plan Explorer 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 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 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 See Install Visual Studio 2005 SP1 Y VS 2005 SP1 fix for Windows 2008 and above See Install Windows 2008 KB932232 Y 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
-
SQL FineBuild will use AutoConfig Processing to install site-specific components and process site-specific scripts
The following components are recommended to be included in AutoConfig Processing \SQLTools sub-folder:
Item Description Miscellaneous Tools Notepad++ Very good plain text editor
Wiki: https://notepad-plus-plus.org/
Download: https://notepad-plus-plus.org/downloads/ -
The SQL SQL2005 Developer Edition X86 install media is now ready for use
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous SQL Media Preparation | Top | FineBuild Initialisation Next |
|---|