. 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 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
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 Power Configuration || Power Configuration adjusted to Maximum |
| 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 |
| Setup No TCP Offload || Disable TCP Offload |
| || 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 No Drive Indexing || Disable Contents Indexing 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 |
The SQL Server install process is split internally into 3 sections. All tasks in this process are performed by the
The following items are installed because they are pre-requisites for SQL Server
The following items are included in the SQL Fixes install. All tasks in this process are performed by the
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
Authors of some of the Community components have donation links.
The following items perform the best-practice configuration of SQL Server. The SQL Configuration items are performed by the
Copyright © 2011 - 2014 Edward Vassie.