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
	Introduction
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
Top