Main Instance Server Build

Previous FineBuild Standard Builds	Additional Named Instance Server Build Next

This is the normal build for SQL Server database server machines.

• The components are installed on multiple disks as described in the /Vol... Parameters
• All services needing access to the network are run using specified SQL Service Accounts
• To install an additional named instance to a server, please see Additional Named Instance Server Build
• To install SQL Server in a Windows Cluster are given in SQL Server Cluster Install

This Build can also be used to upgrade a SQL instance. Upgrades from SQL Server 2000 onwards are supported, depending on the capabilities of the version being upgraded to.

This section includes:

• Build Contents
• The SQLFineServer File
• Residual Interactive Tasks
• Install Processing

Build Contents

This build will contain the following components:

• SQL Server Database Engine
• SQL Server Replication
• Full-Text Search
• Analysis Services (where valid for the SQL Edition)
• Integration Services
• Reporting Services
• Service Pack and/or Cumulative Update
• Legacy Components
• Server-based Community Routines

This Build can optionally install the following components, where valid for the SQL Edition:

• Data Quality Services
• Master Data Services
• PowerBI Server (in place of SSRS)
• PolyBase
• R Services
• Python
• StreamInsight
• SSQL Server Tools

The SQLFineServer File

The SQLFineServer.bat file should be used to install a main instance of SQL Server on to a multi-disk server. This file is not intended for use with Express Edition.

The drive letters used as examples in the rest of this document relate to those used in the example below.

Preparation

1. Prepare the SQL FineBuild install media as described in SQL Media Preparation.

2. Complete all the non-automated processes described in Install Preparation. The automated portions of Install Preparation will be performed by the SQLFineServer script.

3. Take a copy of the SQLFineServer.bat file and change the account names and passwords as required for your site. The main options for this file are described below.

4. Run the FineBuild install by using your copy of SQLFineServer.bat. If .Net 3.5 SP1 has not already been installed on your server, a reboot may be performed after this has been installed. FineBuild will continue automatically after you logon following the reboot.

Syntax and Options

See FineBuild Parameter Syntax for more details of the parameters that have been used.

REM Copyright © 2008 - 2014 Edward Vassie.  Distributed under Ms-Pl License
REM
CALL "SqlFineBuild.bat" %*     /Type:Full                  /IAcceptLicenseTerms    ^
 /SAPWD:"UseAL0ngPa55phrase!"  ^
 /GroupDBA:"GBGGDBAS01"        /GroupDBANonSA:"GBGGDBAN01"                         ^
 /DrvProg:C                    ^
 /DrvBackup:I /DrvData:JF /DrvDataFT:F /DrvLog:KG /DrvTemp:T                       ^
 /SQLSVCAccount:"ROOT\ServGB_SQLDB_0001"                                           ^
   /SQLSVCPassword:"Argyt$6hsGGWMP894s4Gw2b73GS2o0"                                ^
 /AGTSVCACCOUNT:"ROOT\ServGB_SQLAG_0001"                                           ^
   /AGTSVCPASSWORD:"F6tbmd*nf!dfGFrcQnm84g4K7zwq2j"                                ^
 /ASSVCACCOUNT:"ROOT\ServGB_SQLAS_0001"                                            ^
   /ASSVCPASSWORD:"kE44bmutFGS579*bssJW84f=Rb6ehj"                                 ^
 /FTSVCACCOUNT:"ROOT\ServGB_SQLFT_0001"                                            ^
   /FTSVCPASSWORD:"w$Yhfb84nmkl5r*hsdFR7yNs2$ynd6"                                 ^
 /ISSVCACCOUNT:"ROOT\ServGB_SQLIS_0001"                                            ^
   /ISSVCPASSWORD:"bSHG5iuf9DFF#dw2!F5sKSIw43tnb7"                                 ^
 /RSSVCACCOUNT:"ROOT\ServGB_SQLRS_0001"                                            ^
   /RSSVCPASSWORD:"Orfd450!#DTWjn63hw45JDD873hk84"                                 ^
 /BROWSERSVCACCOUNT:"ROOT\ServGB_SQLBR_0001"                                       ^
   /BROWSERSVCPASSWORD:"w#d6gh*ge$dvnHHq1knbtd$Wd68Zj9"                            ^
 /SetupCmdShell:Yes          ^
 /CmdshellAccount:"ROOT\AppGB_SQLCS_0001"                                          ^
   /CmdshellPassword:"j25Fb*ef$36ySIyBW7hZ"                                        ^
 /SETUPRSEXEC:Yes            ^
 /RSEXECACCOUNT:"PROD\APPGB_SQLRS_0001"                                            ^
   /RSEXECPASSWORD:"Prf53g#fdf$Efbv8QGH3"

If the values for the various accounts and passwords are not given, they will default to the values provided for the SQL Server service account (apart from the /BROWSERSVCACCOUNT: and /FTSVCACCOUNT: values which default to the local NETWORK SERVICE account).

All passwords should comply with site standards for complexity, and it is recommended that service account passwords are at least 30 characters long. All passwords should be stored in the DBA Password Store

The ConfigCmdShell keyword controls the configuration of the proxy account to be used if xp_cmdshell is to be run by users who do not have Sysadmin authority within SQL Server. If the value of /CONFIGCMDSHELL: is YES, then the /CMDSHELLACCOUNT: and /CMDSHELLPASSWORD: keywords are required. If you do not require the xp_cmdshell proxy, then remove these keywords.

The /RSEXECACCOUNT: and /RSEXECPASSWORD: keywords specify the Report Services unattended execution account. If this is not required then remove these keywords.

Residual Interactive Tasks

The following tasks must be completed manually after the completion of the FineBuild process.

1. Preparatory Tasks

   a) Complete the Preparatory Tasks starting with Setup Service Permissions and then all remaining tasks up to Final Preparation as described in the FineBuild Reference Manual.

2. Configuration Tasks

   a) For Windows 2003 and XP, perform the Configure COM Security processing.

   b) Review if any of the Configure SQL Server Certificates is required.

   c) Review if any SQL Server Proxy Accounts are required.

   d) SQL2008R2 and below only If SQL Mail is being used, the Configure Outlook Mail Profile processing in the FineBuild Reference Manual is required.

Install Processing

Details of the install processing for each version of SQL Server can be found in FineBuild Main Instance Server Build

Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements

Previous FineBuild Standard Builds	Top	Additional Named Instance Server Build Next