Previous Workhorse Server Role Legacy Server Build Next

Lightweight Server Role

This page describes the Lightweight Server Role SQL FineBuild 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
1) 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.

2) Create an install file for each server similar to the example below. Call the file PDGB01SQLD0231.bat, for use with server PDGB01SQLD0231
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”

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

3) Create similar install files for each of the other servers that will use this role.

4) 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.

Copyright FineBuild Team © 2014 - 2017. License and Acknowledgements
Previous Workhorse Server Role Top Legacy Server Build Next

Last edited Mar 20 at 1:33 PM by EdVassie, version 3