Site Level Default Values - SQL-FineBuild/Common GitHub Wiki

Previous Sample Role Files	Workhorse Server Role Next

This page describes the Site Level SQL FineBuild deployment file. The purpose of this file is to hold the parameters that define the environment (Production, Development, etc) and which will be common to all SQL Server installations in that environment.

A suggested approach is to use the FineBuild Parameter Inventory and review each of the pages in Parameters by Function as a checklist for what may be useful to your organisation. The source of each parameter used can be documented using /Comment: parameters.

The assumptions relating to this role are:

A separate Defaults file will be created for each of the Production, Test, and Development environments
Role Files will be created for each Physical Role, to build servers that use the architecture described in Scale Up and Scale Out

Create a file in the Site SQL Files Folder similar to the example below. Call the file SQLDev.bat and use accounts and server names used by your organisation
- The site Dev file defines and enforces the accounts and major storage locations for all SQL FineBuild installations
- All servers that are built using these parameters will by default install SQL Server 2019. If you want to use a different default version of SQL Server, then change the value of the SQLVERSION variable
- The /Comment: parameters are optional, but help in documenting the options chosen

  @ECHO OFF
  REM Copyright FineBuild Team © 2014 - 2021.  Distributed under Ms-Pl License
  REM
  REM ACME Development Environment specification
  REM For Parameter details see https://github.com/SQL-FineBuild/Common/wiki/FineBuild-Parameter-Inventory
  REM
  IF '%SQLVERSION%' == '' SET SQLVERSION=SQL2019
  CALL "..\%SQLVERSION%\FineBuild\SQLFineBuild.bat" %*     ^
  /Comment:"FineBuild: https://github.com/SQL-FineBuild/Common/wiki/FineBuild-General-Parameters"            ^
  /Comment:"General Environment Parameters"                ^
   /IAcceptLicenseTerms                                    ^
   /Edition:Developer                                      ^
   /Type:Full                                              ^
  /Comment:"Windows Configuration Parameters"              ^
   /OUPath:"Servers.Development Servers.Database Servers"  ^
  /Comment:"Windows Security Parameters"                   ^
   /SetupCompliance:YES                                    ^
  /Comment:"SQL DB: https://github.com/SQL-FineBuild/Common/wiki/SQL-DB-Parameters"                          ^
  /Comment:"SQL DB Accounts"                               ^
   /SetupCMDShell:YES                                      ^
   /CMDSHELLACCOUNT:"ROOT\AppGB_SQLCS_D01"                 /CMDSHELLPASSWORD:"j25Fb*ef$36ySIyBW7hZ"          ^
   /GroupDBA:"GBGGDBAS01"                                  ^
   /GroupDBANonSA:"GBGGDBAN01"                             ^
   /SAPWD:"UseAL0ngPa55phrase!"                            ^
  /Comment:"Community Components"                          ^
   /SETUPDB2OLE:NO                                         ^
  /Comment:"SQL DB Configuration"                          ^
   /SetupSQLDebug:Yes                                      ^
  /Comment:"SQL DB Database Mail"                          ^
   /DBAEmail:"[email protected]"                       ^
   /MAILSERVER:"Acme.Mail.root.local"                      ^
  /Comment:"SQL DB Database Maintenance"                   ^
   /SetBackupRetain:1440                                   ^
   /SetBackupLogRetain:192                                 ^
  /Comment:"SQL DB Data Quality and Master Data"           ^
   /MDSACCOUNT:"ROOT\AppGB_SQLMD_D01"                      /MDSPASSWORD:"7K$dnbb#q!~Vu9s5CxN3"               ^
  /Comment:"SQL DB Disk Volume and Folder"                 ^
   /VolDBA:"\\SOFS-DEV\DBAData"                            ^
   /VolBackup:"\\SOFS-DEV\SQLBackup"                       ^
  /Comment:"SQL DB Distributed Replay"                     ^
   /CTLRSVCACCOUNT:"ROOT\SrvGB_SQLDS_D1$"                  ^
   /CLTSVCACCOUNT:"ROOT\SrvGB_SQLDC_D1$"                   ^
  /Comment:"SQL DB External Services"                      ^
   /EXTSVCACCOUNT:"ROOT\SrvGB_SQLES_D1$"                   ^
  /Comment:"SQL DB Management Data Warehouse"              ^
   /ManagementServer:DBSQLDEV                              ^
   /MDWACCOUNT:"ROOT\AppGB_SQLMW_D01"                      /MDWPASSWORD:"Q5vnf3h$ym*mnrHJdgLc"               ^
  /Comment:"SQL DB Full Text"                              ^
   /FTSVCACCOUNT:"ROOT\SrvGB_SQLFT_D1$"                    ^
  /Comment:"SQL DB PolyBase"                               ^
   /PBDMSSvcAccount:"ROOT\SrvGB_SQLPB_D1$"                 ^
   /PBEngSvcAccount:"ROOT\SrvGB_SQLPB_D1$"                 ^
  /Comment:"SQL DB SQL Agent"                              ^
   /AGTSVCACCOUNT:"ROOT\SrvGB_SQLAG_D1$"                   ^
  /Comment:"SQL AS: https://github.com/SQL-FineBuild/Common/wiki/SQL-AS-Parameters"                          ^
  /Comment:"SQL AS Accounts"                               ^
   /ASSVCACCOUNT:"ROOT\SrvGB_SQLAS_D1$"                    ^
  /Comment:"SQL RS: https://github.com/SQL-FineBuild/Common/wiki/SQL-RS-Parameters"                          ^
  /Comment:"SQL RS Accounts"                               ^
   /RSSVCACCOUNT:"ROOT\SrvGB_SQLRS_D1$"                    ^
  /Comment:"SQL RS Alias"                                  ^
   /RSALIAS:"ReportsDev"                                   ^
  /Comment:"SQL RS Unattended Execution"                   ^
   /RSEMAIL:"[email protected]"                        ^
   /RSEXECACCOUNT:"ROOT\AppGB_SQLRS_D01"                   /RSEXECPASSWORD:"Prf53g#fdf$Efbv8QGH3"            ^
  /Comment:"SQL RS Configuration"                          ^
   /CatalogServer:ReportsDev                               ^   
   /SetHeaderLength:65534                                  ^
   /SetWorkingSetMaximum:8000000                           ^
  /Comment:"SQL IS: https://github.com/SQL-FineBuild/Common/wiki/SQL-IS-Parameters"                          ^
  /Comment:"SQL IS Accounts"                               ^
   /ISSVCACCOUNT:"ROOT\SrvGB_SQLIS_D1$"

Create similar files called SQLProd.bat and SQLTest.bat for use with those environments

SQL Service Accounts has recommendations about the use of service accounts

Previous Sample Role Files	Top	Workhorse Server Role Next