SQL FineBuild Wiki

The SQL 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 SQL FineBuild process is divided into the following steps:

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

SQL FineBuild has a new Owner

To find out more please read why SQL FineBuild has a new Owner.

SQL FineBuild Overview

Item Comment
Introduction
FineBuild Introduction Introduction to what SQL FineBuild is about
FineBuild Design Criteria Principals that guided the SQL FineBuild design
FineBuild Standard Builds The four Standard Builds available in SQL FineBuild
License and Acknowledgements Details of SQL FineBuild Licensing and general acknowledgements
FineBuild Reviews Links to what some people have said about SQL FineBuild
FineBuild Change History Summary of changes to SQL 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
SQL Server Cluster Install Install SQL Server as a Cluster
Large Scale Deployment Using SQL FineBuild Deploying SQL Server across your organisation
Non-English Versions Of SQL Server Installing non-English versions of SQL Server
FineBuild Components Inventory List of all the SQL FineBuild components
FineBuild Parameter Inventory List of all the SQL FineBuild Parameters
FineBuild Troubleshooting How to resolve problems with SQL FineBuild
Best Practice Advice
Best Practice Guidelines Guidelines for what forms Best Practice
SQL Server Administration Best Practice for administering SQL Server
SQL Server Proxy Accounts Management of Proxy Accounts for xp_cmdshell and SQL Agent
DBA Password Store A secure place to store passwords used by DBAs
SQL Server Memory Management Management of memory used by SQL Server components
SQL Server Certificates Configure security Certificates for SQL Server

Top

Install Preparation

The following items prepare the server for a SQL 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, SQL FineBuild must be run using the Administrator context (i.e. Use Run as Administrator or turn User Access Control off).

Item Comment
SQL FineBuild Preparation
SQL Media Preparation Preparing the SQL install media for SQL FineBuild
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 Firewall Port Exceptions Set Firewall Exceptions for SQL Server components
Setup Network Adaptors Rename Network Adaptors to match Cluster Network names
Setup Network Bindings Set correct Network Bindings for cluster install
Folder Preparation
Setup Drive Labels Drive Labels set for all drives used by SQL FineBuild
Setup Network Shares Network shares created for all drives used by SQL 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 Service Permissions Set Service Control permissions
Setup Registry Key Permissions Set Registry Key permissions
Setup WMI Permissions Specify WMI Provider Key permissions
Setup Kerberos Authentication Specify Service Principal Names (SPNs) for Kerberos authentication
Setup Windows Audit Options Specify Windows Audit options
Disable Windows Guest Account Prevent anonymous access to the server

Top

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

Top

Install SQL Pre Install Tasks

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

Item Comment
Setup Slipstream Install 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 Install .Net 2.0 for SQL Server 2005
Install .Net 3.5 Install .Net 3.5 SP1 for all SQL Server versions
Install IIS Install IIS on Windows 2008 and above if needed by other components
Install Windows Installer 4.5 Install Windows Installer 4.5 for SQL 2008 onwards
Install Powershell V1 Install Powershell V1 for SQL Server 2008 and 2008 R2
Install Powershell V2 Install Powershell V2 for all SQL Server versions
Install Windows 2003 KB933789 Registry permissions fix for Windows 2003
Install Windows 2003 KB937444 Filestream compatibility fix for Windows 2003
Install Windows 2008 KB956250 Preparation fix for .Net 4 for Windows 2008
Install .Net 4.0 Required for SQL 2012 and above, but recommended for all versions of SQL Server
Setup Distributed Replay Setup Distributed Replay Utility (DRU)
Install .Net 4.5 Required for SQL Server Data Tools, but recommended for all versions of SQL Server
Setup PS Remote Setup Powershell for remote access
Pre-Requisites Reboot Reboot if needed after pre-requisites installed

SQL Install

Install SQL Server

SQL 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

SQL Install

Install SQL Post Install Tasks

The following items are performed after the SQL Server install

Item Comment
Check SQL Edition Data Check data for the SQL Server Edition that has been installed
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 SQL 2008 KB954961 VS 2005 SP1 fix for SQL Server 2008
Install Visual Studio 2010 SP1 Install VS 2010 SP1 if SQL2014 is installed
Download the ISO from http://go.microsoft.com/fwlink/?LinkId=210710 and copy the contents to Additional Components\VS2010SP1
Setup SSIS Cluster Create SSIS cluster
Setup Cluster Bindings Cluster post-install configuration
Post-Requisites Reboot Reboot if needed after SQL Server and post-requisites installed

SQL Install

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 SNAC Update Install SQL Server Native Client (SNAC) update
Install SQL Books Online Update Install latest SQL Server Books Online (BOL) update
Post Fix Tasks Tasks required after fixes have been installed

Top

Extra Components Install

The following Community and Microsoft components can be optionally be installed by SQL 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
Install SSDT Install SQL Server Data Tools
Download the ISO from http://download.microsoft.com/download/2/0/7/20778CB3-15FE-4DA5-9B2D-73A794364908/SSDTDec2012_VS2010_EN.iso and copy the contents to Additional Components\SSDT
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
Install Plan Explorer Simplifies the process of understanding SQL Execution Plans
Install Plan Explorer SSMS Addin Adds Plan Explorer functionality into SSMS
Install Zoomit Zoom into a portion of your Windows display

Top

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 Instance Properties Configure SQL Server Instance Properties
Configure SQL Agent Properties Configure SQL Agent Properties
Configure Analysis Services Instance Configure Analysis Services Instance
Configure Integration Services Instance Configure Integration Services Instance
Configure Notification Services Instance Configure Notification Services Instance
Configure Reporting Services Instance Configure Reporting Services Instance
Configure Accounts
Configure Standard Accounts Setup accounts needed within SQL Server
Configure Sysadmin Accounts Setup authorities for sysadmin accounts
Configure DBA Non-Sysadmin Group Setup authorities for DBA non-Sysadmin Group
Configure SA Account Disable and optionally rename the sa Account
Configure xp_cmdshell Proxy Account Setup the xp_cmdshell Proxy Account
Configure Database Owner Account Setup low-privilige account to own user databases
Configure User Accounts Add end-user accounts to SQL Server
Configure Reporting Services Administration Accounts Configure Administration Accounts for Reporting Services
Configure Reporting Services Unattended Execution Account Setup account for SSRS Unattended report execution
Backup Reporting Services Encryption Keys Backup encryption keys used by Repoering Services
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 System Index Enhancements Additional indexes for System Tables to improve performance
Configure Full-Text options Set optimum Full-Text Search options
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 Processes Configure backup and other maintenance for all databases
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

Top

User Configuration

Item Comment
Books Online Configuration See Reference Manual
Command Window Settings See Reference Manual
SSMS Configuration See Reference Manual
Configure Visual Studio Preferences See Reference Manual
Configure Internet Preferences See Reference Manual
Configure Windows Preferences See Reference Manual
Configure 'My Documents' location See Reference Manual
Disable Install Login See Reference Manual


Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Top

Last edited Mar 28 at 9:54 AM by EdVassie, version 44

Comments

EdVassie Jun 27, 2012 at 4:07 PM 
Hi Suwanee,

I have added this to the list of future changes for FineBuild. However, this problem was fixed for Windows 2008 and above. For details on how to fix the problem for Windows 2003, see KB 929491

dbajmc_Suwanee Jun 8, 2012 at 8:31 PM 
Please include information for performing "Disk Partitioning Alignment" on SQL 2005\2008 the correct way. This does seem to be that much of an issue in SQL 2008+ . (http://msdn.microsoft.com/en-us/library/dd758814(v=sql.100).aspx )

But it would be great if you include it with the FINDBuild project; I always look forward to your updates. :)

EdVassie Jan 6, 2012 at 1:51 PM 
Hi dbatag, the information about the SQL Server Configuration items is curently found in the Reference Manual. The plan is that all items on this page will get links as I migrate the Reference Manual online. More work is planned for this in March 2012, but until then I have another project I have to work on.

dbatag Jan 5, 2012 at 1:29 AM 
All Items in SQL Server Configuration doesn;t have the link. It would be great, if you could provide more information on Master Data Services too

Thanks
DBATAG
<a href="http://www.sqlServer-Training.com/">www.sqlServer-Training.com</a>

dbatag Jan 5, 2012 at 1:29 AM 
All Items in SQL Server Configuration doesn;t have the link. It would be great, if you could provide more information on Master Data Services too

Thanks
DBATAG
http://sqlServer-Training.com/