Previous FineBuild Standard Builds Additional Named Instance Server Build Next

Main Instance Server Build

This is the normal build for SQL Server database server machines. The components are installed on multiple disks as described in the /Drv... 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 FineBuild Additional Named Instance Server Build.

Details for installing 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.

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:

  • Data Quality Services (where valid for the SQL Edition)
  • Master Data Services (where valid for the SQL Edition)
  • StreamInsight (where valid for the SQL Edition)
  • 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 details of the colours used in the code example and other syntax details.

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 given in blue 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

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 - 2015. License and Acknowledgements

Previous FineBuild Standard Builds Top Additional Named Instance Server Build Next

Last edited Apr 27, 2015 at 5:03 PM by EdVassie, version 16