Workhorse Server Role

Previous Sample Role Files	Lightweight Server Role Next

This page describes Workhorse Server Role deployment. This consists of the following steps:

• Workhorse Role Assumptions
• Create Role File
• Create Server File
• Install Process

Workhorse Role Assumptions

The assumptions relating to this role are:

• A number of servers will be created using this role
• 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 or above is installed

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    ^
 /SiteRole:Workhorse                               ^
 /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
• All servers built using this role will run the AutoConfig Processing scripts in the \Workhorse sub-folder
• 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 PDGB01SQLD0020.bat, for use with server PDGB01SQLD0020

   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:PDGB01SQLD0020                            ^
   /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

   SQL Service Accounts has recommendations about the use of service accounts. The parameters relating to all accounts could be moved to the SQLWorkhorse.bat file if the same accounts and passwords are used on all servers

   The /SetupDistributor: parameter should only be included for those servers that will act as a replication distributor

Install Process

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

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

Previous Sample Role Files	Top	Lightweight Server Role Next