Workhorse Server Role

Previous Site Level Default Values	Lightweight Server Role Next

This page describes the Workhorse Server Role SQL FineBuild deployment file.

The assumptions relating to this role are:

• The operating system has use of 128 GB RAM and 32 processor cores, and may be running as a guest server
• A separate drive letter is used for each type of database file
• SQL Server is the only software installed, apart from installation-standard anti-virus and monitoring tools
• The SSRS Unattended Execution account is required
• The xp_cmdshell proxy account is required
• Some of the servers created within this role require the replication Distributor database
• SQL client tools are not required
• Java connectivity is required
• A Buffer Pool extension file is required if SQL2014 is installed
• A number of servers will be created using this role

Create Role File

Create a role file in the Site SQL Files Folder similar to the example below. Call the file SQLWorkhorse.bat.

REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
REM
CALL "SQLProd.bat" %*       /Type:Full             ^
 /IAcceptLicenseTerms       /Edition:Enterprise    ^
 /VolDataAs:L /VolLogAs:M   /VolBackupAS:J         ^
 /VolData:GF  /VolDataFS:F  /VolDataFT:F /VolLog:H ^
 /VolTemp:T   /VolTempLog:U /VolBackup:J           ^
 /SetupCmdShell:Yes /SetupRSExec:Yes    /SetupSQLTools:No /SetupJavaDBC:Yes ^
 /SetupBPE:Yes /VolBPE:T /BPEFile:400GB

The role file contains all the parameters that define the role. All servers built using this role will use Enterprise Edition of SQL Server. If SQL2014 or above is installed, the BPE file will be created, otherwise these parameters will be ignored.

Create Server File

1. Create an install file for each server similar to the example below. Call the file PDGB01SQLS0020.bat, for use with server PDGB01SQLS0020

   The install file contains the parameters unique to the server, such as the account names and server name.

  REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
  REM
  CALL "SQLWorkhorse.bat" %*                         ^
   /IAcceptLicenseTerms                              ^
   /Server:PDGB01SQLS0020                            ^
   /SAPWD:"UseAL0ngPa55phrase!"                      ^
   /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"  ^
   /CmdshellAccount:"ROOT\AppGB_SQLCS_0001"          ^
    /CmdshellPassword:"j25Fb*ef$36ySIyBW7hZ"         ^
   /RSEXECACCOUNT:"PROD\APPGB_SQLRS_0001"            ^
    /RSEXECPASSWORD:"Prf53g#fdf$Efbv8QGH3"           ^
   /SetupDistributor:Yes

2. Create similar Server files for each of the other servers that will use this role. The /SetupDistributor: parameter should only be included for those servers that will act as a replication distributor.

3. When each install file is run, it runs the role file to pick up the standard role parameters. The role file then runs the environment default values file which in turn will invoke FineBuild with the combined set of parameters.

4. At run time add the /AdminPassword: parameter to specify your password. This will allow SQL FineBuild to log on automatically when it needs to perform a reboot.

Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements

Previous Site Level Default Values	Top	Lightweight Server Role Next