FineBuild Wiki

The FineBuild reference material is split between this Wiki and the FineBuild Reference Manual. Over time it is intended to move all material to this Wiki, but for now please look in the Reference Manual for any information not given here.

The FineBuild process is divided into the following steps:

FineBuild Overview
Install Preparation
SQL Install
Fixes Install
Extra Components Install
SQL Configuration
User Configuration

FineBuild Overview

Item Comment
FineBuild Introduction Introduction to what FineBuild is about
FineBuild Design Criteria Principals that guided the FineBuild design
FineBuild Standard Builds The four Standard Builds available in FineBuild
SQL Media Preparation Preparing the SQL install media for FineBuild
License and Acknowledgements Details of FineBuild Licensing and general acknowledgements
FineBuild Reviews Links to what some other people have said about FineBuild
FineBuild Change History Summary of changes to FineBuild Releases
Advanced Features
SQL Media Alternative Folder Names Using alternative names for SQL Media folders
Upgrade from Old Version of SQL Server See Reference Manual
Install SQL Server as a Cluster See Reference Manual
Large Scale Deployment using FineBuild See Reference Manual
Non-English Versions of SQL Server See Reference Manual
Install SQL Server using Altiris See Reference Manual
SQL Server Certificates Configure security Certificates for SQL Server
FineBuild Components Inventory List of all the FineBuild components
FineBuild Troubleshooting How to resolve problems with FineBuild
Best Practice Advice
DBA Password Store A secure place to store passwords used by DBAs
SQL Server Proxy Accounts Management of Proxy Accounts for xp_cmdshell and SQL Agent

Install Preparation

The following items prepare the server for a FineBuild installation.

All installation activity must be performed while logged on using an account that is a member of the local Administrators group on the server on which SQL Server is being installed.

When installing on Windows 2008 or above, FineBuild must be run using the Administrator context (i.e. Use Run as Administrator or turn User Access Control off).

Item Comment
FineBuild Validation
Check Install Requirements Validate that the server can support the requested SQL Server install
Server Preparation
Setup Server Name Server name set to upper case if in mixed case
Setup Service Timeout Service startup timeout adjusted if server is slow
Setup Network Bindings Set correct Network Bindings for cluster install
Rename Network Adaptors Rename Network Adaptors to match Cluster Network names
Folder Preparation
Setup Drive Labels Drive Labels set for all drives used by FineBuild
Setup Network Shares Network shares created for all drives used by FineBuild
Setup Folder Structure Folders created for SQL Server installation
setup System Temp Folder Change location of system Temp folder
Setup User Temp Folder Change location of all user Temp folders
Group Policy Object (GPO) Preparation
GPO Introduction Introduction to Group Policy Objects
Setup Folder Permissions Set permissions for DBA and service accounts
Setup Group Membership Set membership of Windows Groups
Setup User Rights Set Windows Rights and Priviliges
Setup Firewall Port Exceptions Set Firewall Exceptions for SQL Server components
Setup Service Permissions Set Service Control permissions
Setup Registry Key Permissions Set Registry Key permissions
Setup Kerberos Authentication Specify Service Principal Names (SPNs) for Kerberos authentication
Setup WMI Permissions Specify WNI Provider Key permissions
Setup Windows Audit Options Specify Windows Audit options
Disable Windows Guest Account Prevent anonymous access to the server

SQL Install

The SQL Server install process is split internally into 3 sections. All tasks in this process are performed by the FineBuild2InstallSQL script.

Install SQL Pre Install Tasks
Install SQL Server
Install SQL Post Install Tasks

Install SQL Pre Install Tasks

The following items are installed because they are pre-requisites for SQL Server

Item Comment
Setup Slipstream Media Merge SP and CU into install media for SQL 2008 and SQL 2008 R2
Setup MSDTC CID Create new CID (GUID) for local MDTC
Setup MSDTC Network Access Allows MSDTC to be accessed over the network
Setup MSDTC Cluster Create MSDTC Cluster(s) for SQL cluster installs
Install .Net 2.0 This is only installed for SQL Server 2005
Install .Net 3.5 This is required for SQL 2008 onwards
Install IIS IIS is installed on Windows 2008 and above if needed by other components
Install Windows Installer 4.5 This is required for SQL 2008 onwards
Install Powershell V1 This is required for SQL Server 2008 and 2008 R2
Install Powershell V2 This is required for SQL 2012, but is recommended for all versions of SQL Server
Install Windows 2003 KB933789 Registry permissions fix
Install Windows 2003 KB937444 Filestream compatibility fix
Install Windows 2008 KB956250 Preparation fix for .Net 4
Install .Net 4.0 This is required for SQL 2012, but is recommended for all versions of SQL Server
Setup Distributed Replay Setup Distributed Replay Utility (DRU)
Pre-Requisites Reboot Reboot if needed after pre-requisites installed

Install SQL Server

FineBuild will run one of the Standard Builds listed below:

Item Comment
FineBuild Main Instance Server Build The normal build for SQL Server database server machines
FineBuild Additional Named Instance Server Build Used if an additional SQL Server Named Instance is required on a database server
FineBuild Workstation Build The normal build for Development Workstations
FineBuild Client Tools Build The normal build for DBA Administration machines

Install SQL Post Install Tasks

The following items are performed after the SQL Server install

Item Comment
Save SQL Edition data Save data for SQL Edition that has been installed
Reset DBA permissions DBA permissions reset where changed by SQL Server install
Install Visual Studio 2005 SP1 Install VS 2005 SP1 if SQL 2005 and BIDS installed
Install Windows 2008 KB932232 VS 2005 SP1 fix for Windows 2008
Install KB954961 VS 2005 SP1 fix for SQL Server 2008
Setup SSIS Cluster SSIS cluster created if requested
Setup Cluster Bindings Cluster post-install configuration
Post-Requisites Reboot Reboot if needed after SQL Server and post-requisites installed

SQL Fixes Install

The following items are included in the SQL Fixes install. All tasks in this process are performed by the FineBuild3InstallFixes script.

Item Comment
Install SQL Service Pack Install requested Service Pack if not already included in Slipstream processing
Install SQL Cumulative Update Install requested Cumulative Update if not already included in Slipstream processing
Install SQL SNAC Update SQL 2008 and above
Install SQL Books Online Update Install latest SQL Server Books Online (BOL) update

Extra Components Install

The following Community and Microsoft components can be optionally be installed by FineBuild. If you do not want to install a given product, then do not download it. The extra components are all installed by the FineBuild4InstallExtras script.

Authors of some of the Community components have donation links. If you use a component then please pay what it is worth to you.

Item Comment
Pre-Requisite Components
Install Baseline Configuration Analyzer Data collection framework for Best Practice Analyzers
Install Report Viewer Enables viewing of Reports in .Net applications
Business Intelligence Components
Install MDX Studio Significant extra functionality for developers of MDX queries
Install BIDS Helper Adds extensive functionality to developers of SSIS packages using the Business Intelligence Development Studio
SSIS and DTS Components
Install DTS Designer Provides the ability to create and edit DTS packages in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
Install DTS Backup 2000 The most effective way of exporting, importing and backing up DTS packages
Install SSIS Dimension Merge SCD A major building block within SSIS for implementing the Kimball methodology
Install SSIS Raw File Reader Examine the contents of SSIS Raw Files
Install SQL 2005 Backward Compatibility Allows legacy DMO applications to run and is a pre-requisite for DTS Designer support
Report Services Components
Install Taskpad View Report A report similar to the Taskpad View in SQL Server 2000
Install Reporting Services Scripter Enables scripting of all Microsoft SQL Server Reporting Services catalog items
Install Linked Report Generator Enables automatic generation of linked reports to any number of Reporting Services folders based on a single base report
SQL Database Components
Install SQL Best Practice Analyzer Allows various aspects of the SQL Server configuration and database configuration to be checked against Microsoft best practice
Install Java DBC Driver Allows Java applications to access SQL Server
Install OLE Provider for DB2 Allows SQL Server to access DB2 databases
Install SQL Cache Manager Allows the DBA to view and manage the SQL Server Plan Cache
Install SQL Internals Viewer Monitoring tool that looks into the SQL Server storage engine and database internals to see how data is physically allocated, organised and stored
Install Master Data Services Provides a framework and repository for managing the key reference data of an organisation
Install SQL Performance Dashboard Provides a number of Custom Reports that assist the management of SQL Server
Install System Views Map Provides a visual summary of the key system views included in SQL Server and the relationships between them
Install Notification Services Allows real-time analysis of streams of data. SQLNS is now obsolete and is replaced by StreamInsight
Install StreamInsight Allows real-time analysis of high-volume streams of data
Install Semantic Search Discover statistically relevant insight through prominent words and similar content in documents stored in Full-Text indexes
Install Data Quality Services Provides a knowledge-driven data cleansing solution
Install Replication Distributor Configures the Distribution databases needed when using SQL Server Replication
SQL Tools Components
Install Access Based Enumeration (ABE) Prevents users who do not have access to the server from discovering information about shares and other details for the server
Install Extended Events Manager Simplifies creating and viewing metadata for Extended Events Sessions
Install PDF Reader Lightweight and stable PDF Reader
Install Process Explorer Helps troubleshoot failures in SQL Server components, SSIS packages, etc.
Install Process Monitor An advanced tool that shows real-time file system, registry and thread activity, often vital in troubleshooting problems within executable code
Install RML Utilities Provides analysis of SQL Server dump information
Install SQL Nexus Helps identify the root cause of SQL Server performance issues
Install Troubleshooting Guide Provides Microsoft best practice information on troubleshooting problems with SQL Server
Install XML Notepad Easy way to edit XML files

SQL Configuration

The following items perform the best-practice configuration of SQL Server. The SQL Configuration items are performed by the FineBuild5ConfigureSQL script

Item Comment
Configure SQL Server Services
Configure COM Security Allow access to Integration Services from remote servers
Configure SQL Network Protocols Configure custom port for SQL Server
Configure Service Account Names Apply Service Accounts not allowed by SQL Server install
Configure SQL Startup Parameters Add best-practice Flags to SQL Server startup parameters
Configure SQL Service Recovery Set actions to take if a SQL Service fails
Configure SQL Server Instances
Configure SQL Server Surface Area Set SQL Server surface area using SP_Configure
Configure Errorlog Retention Increase number of Errorlog files retained
Backup Service Master Key Save a copy of the Service Master Key
Configure Database Mail Configure Database Mail profile
Configure SQL Mail Configure legacy SQL Mail profile
Configure SQL Server Memory Use Set maximum memory allowed for SQL Server
Configure SQL Server Login Audit Options Configure auditing of SQL Logon activity
Configure SQL Server Parallelism Options Set optimum maximum parallelisation for queries
Configure SQL Agent Job Tokens Configure ability to use variables (Tokens) in SQL Agent T-SQL jobs
Configure SQL Agent Job History Extend retention of SQL Agent job history data
Configure Analysis Services Backup folder Set default folder for Analysis Services backups
Configure Analysis Services Management API Allow use of Analysis Services Management API
Configure Accounts
Configure standard accounts Setup accounts needed within SQL Server
Configure Database Owner account Setup low-privilidge account to own user databases
Configure Sysadmin accounts Setup authorities for sysadmin accounts
Configure DBA Non-Sysadmin group Setup authorities for DBA non-Sysadmin group
Disable SA account Disable and optionally rename the SA account
Configure xp_cmdshell Proxy account Setup xp_cmdshell proxy account
Configure Reporting Services Administrator account Set DBA Sysadmin group as SSRS Administrators
Configure Reporting Services Unattended Execution account Setup SSRS Unatended Execution account
Backup Reporting Services Encryption Keys Save a copy of the SSRS Encryption Keys
Configure User Accounts
Configure Database Options
Configure msdb database Move msdb files to standard locations
Configure tempdb database Move tempdb files to standard locations and set number of files
Configure Full-Text Search location (SQL 2005 only) Move Full-Text files to specified drive
Configure Full-Text Search performance Set optimum max full-text crawl range
Configure SQL Server Management
Configure System Management routines Create routines to assist in managing SQL Server
Configure DBA Database Create database for DBA routines
Configure DBA Management processes Add DBA routines to DBA Database
Configure Management Data Warehouse SQL 2008 and above
Start MDW Data Collection SQL 2008 and above
Configure Policy Based Management SQL 2008 and above
Configure Generic Maintenance Routines See Reference Manual
Configure standard database properties See Reference Manual
Configure SQL Agent Job corrections Some SQL Agent jobs set up by Microsoft are fixed to cope with a Cluster Install
Configure SQL Server menu items Set up Menu items for SQL Server components

User Configuration

Item Comment
Books Online Configuration See Reference Manual
Command Window Settings See Reference Manual
SSMS Configuration See Reference Manual
Disable Install Login See Reference Manual

Copyright © 2011 - 2012 Edward Vassie. License and Acknowledgements

Last edited Nov 22, 2012 at 3:18 PM by EdVassie, version 28