Lightweight Server Role

Previous Workhorse Server Role	Legacy Server Build Next

This page describes the Lightweight Server Role deployment file.

The assumptions relating to this role are:

• The operating system has use of 4 processor cores and 16 GB RAM, and is running as a guest server
• All software is installed on the system drive, with separate drives for the data and log files
• SSAS is required
• SSRS is not required
• SQL Server is the only software installed, apart from installation-standard anti-virus and monitoring tools
• 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 SQLLightweight.bat.

REM Copyright FineBuild Team © 2014 - 2016.  Distributed under Ms-Pl License
REM
CALL "SQLProd.bat" %*       /Type:Full            ^
 /IAcceptLicenseTerms       /Edition:Standard     ^
 /SetupSQLAS:Yes /SetupSQLRS:No /VolData:E  /VolLog:F

The role file contains all the parameters that define the role. All servers built using this role will use Standard Edition of SQL Server.

Create Server File

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

   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 "SQLLightweight.bat" %*                       ^
   /IAcceptLicenseTerms                              ^
   /Server:PDGB01SQLD0231                            ^
   /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"

2. Create similar Server files for each of the other servers that will use this role.

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 invokes 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 Workhorse Server Role	Top	Legacy Server Build Next