Site Level Default Values

Previous Sample Role Files	Workhorse Server Role Next

This page describes the Site Level SQL FineBuild deployment file.

The assumptions relating to this role are:

• A separate Defaults file will be created for each of the Production, Test, and Development environments
• A DNS Vanity Name will be used to identify the Mail Server for the Database Mail configuration
• A Management Server will be defined to host MDS, MDW, Distributed Replay Controller, etc.

1. 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
   • The /Comment: parameters are optional, but they relate to the section headings in the FineBuild Parameter Inventory
   • It identifies the site email server
   • It identifies an Alias that points to the server that hosts the Master component of Master/Target facilities within SQL Server
   • 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

  @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:"General Environment Parameters"                ^
   /IAcceptLicenseTerms                                    ^
   /Edition:Developer                                      ^
   /SetupCompliance:YES                                    ^
   /SetupSQLDebug:Yes                                      ^
   /OUPath:"Servers.Development Servers.Database Servers"  ^
   /SSLCert:"Wildcard Cert 2021-2022"                      ^
   /Type:Full                                              ^
  /Comment:"SQL DB Accounts"                               ^
   /SetupCMDShell:YES                                      ^
   /CMDSHELLACCOUNT:"ROOT\AppGB_SQLCS_D01"                 ^
   /CMDSHELLPASSWORD:"j25Fb*ef$36ySIyBW7hZ"                ^
   /GroupDBA:"GBGGDBAS01"                                  ^
   /GroupDBANonSA:"GBGGDBAN01"                             ^
   /SAPWD:"UseAL0ngPa55phrase!"                            ^
   /SQLSVCAccount:"ROOT\SrvGB_SQLDB_D1$"                   ^
  /Comment:"SQL DB Database Mail"                          ^
   /DBAEmail:"SQL.ALERTS@root.local"                       ^
   /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 Community Components"                   ^
   /SETUPDB2OLE:NO                                         ^
  /Comment:"SQL DB SQL Agent"                              ^
   /AGTSVCACCOUNT:"ROOT\SrvGB_SQLAG_D1$"                   ^
  /Comment:"SQL AS Accounts"                               ^
   /ASSVCACCOUNT:"ROOT\SrvGB_SQLAS_D1$"                    ^
  /Comment:"SQL RS Accounts"                               ^
   /RSSVCACCOUNT:"ROOT\SrvGB_SQLRS_D1$"                    ^
  /Comment:"SQL RS Alias"                                  ^
   /RSALIAS:"ReportsDev"                                   ^
  /Comment:"SQL RS Unattended Execution"                   ^
   /RSEMAIL:"ReportsDev@root.local"                        ^
   /RSEXECACCOUNT:"ROOT\AppGB_SQLRS_D01"                   ^
   /RSEXECPASSWORD:"Prf53g#fdf$Efbv8QGH3"                  ^
  /Comment:"SQL RS Configuration"                          ^
   /CatalogServer:ReportsDev                               ^   
   /SetHeaderLength:65534                                  ^
   /SetWorkingSetMaximum:8000000                           ^
  /Comment:"SQL IS Accounts"                               ^
   /ISSVCACCOUNT:"ROOT\SrvGB_SQLIS_D1$"                                                            

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

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

Previous Sample Role Files	Top	Workhorse Server Role Next