This project has moved and is read-only. For the latest updates, please go here.

Previous FineBuild Parameter Syntax FineBuild Setup Parameters Next

FineBuild Static Parameters

This page lists the parameters that do not normally need to be changed when running SQL FineBuild.

The Static Parameters are found in all five nodes within the SQL FineBuild Config file:

Global Node
BuildServer Node
BuildWorkstation Node
BuildClient Node
Files Node

Global Node

The keywords in the Global node are used in all of the Builds. Where a keyword has the same name as a SQL Server install parameter, it fulfills the same function.
Parameter Value Usage
/AgentJobHistory: 500 See Configure SQL Agent History Properties
/AgentMaxHistory: 20000 See Configure SQL Agent History Properties
/AgtSVCStartupType: Automatic See BOL for details
/ASProviderMSOlap: 1 OLAP provider run in-process
/ASServerMode: Mutidimensional See BOL for details
/ASSVCStartupType: Manual See BOL for details
/AuditLevel: 2 See Configure SQL Instance Security Properties
/BrowserSVCStartupType: Manual See BOL for details
/ASCollation: Latin1_General_CI_AS Collation for Analysis Services
/CLSIdDTExec: SQL Version dependant Class Id for DTSExec program
/CLSIdSQL: SQL Version dependant Class Id for SQL Server Service executable
/CLSIdSQLSetup: SQL Version dependant Class Id for SQL Server Setup program
/CLSIdSSIS: SQL Version dependant Class Id for SSIS Service executable
/CSVRoot: ClusterStorage Root folder name for CSVs
/DBA_DB: DBA_Data See Create DBA Database
/DBMailProfile: Public DB Mail See Configure Database Mail
/DBOwnerAccount: DBOwner See Configure Database Owner Account
/DirDBA: DBAFiles High-level folder to hold DBA team data
/DirSQL: SQLFiles High-level folder to hold SQL Server database files
/DirTempUser: Temp Folder for User temporary files
/DirTempWin: Temp Folder for Windows temporary files
/DistributionDatabase: Distribution See Install Replication Distributor
/DTCMultiInstance: Yes See Setup MSDTC Cluster
/EnableRanu: 1 See BOL for details
/ErrorReporting: 0 See BOL for details
/FilePerm: “Administrators”:F “Users”:R Global permissions to be applied to all high-level folders. These are augmented by DBA group and service account permissions
/FileStreamLevel: 2 Filestream functionality level
/ISSVCStartupType: Automatic See BOL for details
/Language: ENU Language code for files
/ManagementDW: ManagementDW See Configure Management Data Warehouse
/NativeOS: SQL Version dependant Version of Windows for which SQL Server was designed
/NPEnabled: 1 See BOL for details
/NumErrorLogs: 31 See Configure Errorlog Retention
/NumLogins: 20 See Configure User Accounts
/NumTF: 20 Maximum number of Trace Flags to search for
/RSInstallMode: DefaultNative Mode Install mode for Reporting Services
/RSShpInstallMode DefaultSharePointMode Reporting Services SharePoint install mode
/RSSQLLocal: 1 See BOL for details
/RSSVCStartupType: Automatic Startup mode for Reporting Services
/SpeedTest: 5.0 See Setup Service Timeout
/SQLCollation: Latin1_General_CI_AS Collation for SQL Server
/SQLSVCStartType: Automatic See BOL for details
/SQMReporting: 0 See BOL for details
/SSISDB: SSISDB Name of SSIS Catalog DB
/TCPEnabled: 1 See BOL for details
/TCPPort: 1433 TCP Port for default SQL instance
/TCPPortAS: 2383 See Configure AS Instance General Properties
/TCPPortDAC: 1434 TCP Port for Dedicated Administrator Connection
/TCPPortDTC: 13300 TCP Port for MSDTC
/Tempdb File: 200 MB Size for each tempdb file
/TF01: to /TF09: Trace Flag value See Configure SQL Startup Parameters
/WriterSVCStartupType: Manual Startup mode for SQL VSS Writer service

Strings Subnode

The Strings parameters contain values specific for each of the Builds.

If a non-English version of SQL Server is installed, then the values for some of these keywords may need to be changed.

The vaues for the Menu... parameters can change depending on the SQL Server version being installed. The Config file shows the values used.
Parameter Value Usage
/AnyKey: Press any key Language-specific prompt
/ClusASSuffix: AS See Cluster Naming Convention
/ClusDBSuffix: DB See Cluster Naming Convention
/ClusDTCSuffix: TC See Cluster Naming Convention
/ClusISSuffix: IS See Cluster Naming Convention
/ClusPESuffix: PE See Cluster Naming Convention
/ClusPMSuffix: PM See Cluster Naming Convention
/ClusRSSuffix: RS See Cluster Naming Convention
/ClusStorage: Available Storage See Setup Cluster Storage Group
/LabBackup: Backup See Setup Drive Labels
/LabBackupAS: AS Backup See Setup Drive Labels
/LabDRU: DRU See Setup Drive Labels
/LabBPE: BPE See Setup Drive Labels
/LabData: SQL Data See Setup Drive Labels
/LabDataAS: AS Data See Setup Drive Labels
/LabDataFS: FS Data See Setup Drive Labels
/LabDataFT: FT Data See Setup Drive Labels
/LabDBA: DBA Misc See Setup Drive Labels
/LabLog: SQL Log See Setup Drive Labels
/LabLogAS: AS Log See Setup Drive Labels
/LabLogTemp: Temp Log See Setup Drive Labels
/LabProg: Programs See Setup Drive Labels
/LabSysDB: SQL SysDB See Setup Drive Labels
/LabSystem: System See Setup Drive Labels
/LabTemp: SQL Temp See Setup Drive Labels
/LabTempAS: AS Temp See Setup Drive Labels
/LabTempWin: Temp See Setup Drive Labels
/LocalAdmin: Administrators Local administrators account name within SQL Server
/MenuAccessories: Windows Version dependant Windows ‘Accessories’ menu name
/MenuAdminTools: Administrative Tools Windows 'Administrative Tools' menu name
/MenuBOL: SQL Version dependant SQL Server Books Online menu name
/MenuConfigTools: SQL Version dependant SQL ‘Configuration Tools’ menu name
/MenuPerfTools: SQL Version dependant SQL ‘Performance Tools’ menu name
/MenuPrograms: Windows Version dependant Windows ‘Programs’ item on Start menu
/MenuSQL2005: Microsoft SQL Server 2005 SQL 2005 menu name
/MenuSQL2008: Microsoft SQL Server 2008 SQL 2008 menu name
/MenuSQL2008R2: Microsoft SQL Server 2008 R2 SQL 2008 R2 menu name
/MenuSQL2012: Microsoft SQL Server 2012 SQL 2012 menu name
/MenuSQL2014: Microsoft SQL Server 2014 SQL 2014 menu name
/MenuSQL2016: Microsoft SQL Server 2014 SQL 2016 menu name
/MenuSQLAS: SQL Version dependant Analysis Services menu name
/MenuSQLDocs: SQL Version dependant SQL ‘Documentation and Tutorials’ menu name
/MenuSQLIS: Integration Services Integration Services menu name
/MenuSQLNS: SQL Version dependant Notification Services menu name
/MenuSQLRS: Reporting Services Reporting Services menu name
/MenuSSMS: SQL Version dependant SQL Server Management Studio menu name
/MenuSSMSExp: SQL Version dependant SSMS menu name for SQL Server Express
/NTAuthAccount: NT AUTHORITY\Network Service Local Network Service account name
/PathAddComp: ..\Additional Components See SQL Media Alternative Folder Names
/PathSQLMedia: ..\SQLMedia See SQL Media Alternative Folder Names
/PathSQLSP: ..\Service Packs See SQL Media Alternative Folder Names
/ResponseNo: N “No” response to Windows commands
/ResponseYes: Y “Yes” response to Windows commands
/SQLProgDir: Microsoft SQL Server SQL Server program folder name
/SQLRecoveryComplete Recovery Complete Message in SQL Error Log when start-up recovery has completed

BuildServer Node

The keywords in this node control the fine details of what is installed for a normal Server build.
Parameter Value Usage
/Features: (none) Additional install features required for local standards
/Options: (none) Additional install options required for local standards
/spConfigureCLREnabled: 1 See Configure SQL Server Surface Area
/spConfigureCostThreshold: Cost Threshold for Parallelism (Default 20)
/spConfigureMaxServerMemory: (none) See Configure SQL Instance Memory Properties
/spConfigureOptimizeForAdHocWorkloads: 0 See Configure SQL Server Surface Area
/spConfigureRemoteAdminConnections: 1 See Configure SQL Server Surface Area
/spConfigureRemoteProcTrans: 0 See Configure SQL Server Surface Area
/spConfigurexpCmdshell: 0 See Configure SQL Server Surface Area

BuildWorkstation Node

The keywords in this node control the fine details of what is installed for a normal Workstation build.
Parameter Value Usage
/Features: (none) Additional install features required for local standards
/Options: (none) Additional install options required for local standards
/spConfigureCLREnabled: 1 See Configure SQL Server Surface Area
/spConfigureCostThreshold: Cost Threshold for Parallelism (Default 20)
/spConfigureMaxServerMemory: (none) See Configure SQL Instance Memory Properties
/spConfigureOptimizeForAdHocWorkloads: 0 See Configure SQL Server Surface Area
/spConfigureRemoteAdminConnections: 1 See Configure SQL Server Surface Area
/spConfigureRemoteProcTrans: 0 See Configure SQL Server Surface Area
/spConfigurexpCmdshell: 0 See Configure SQL Server Surface Area

BuildClient Node

The keywords in this node control the fine details of what is installed for a normal Client build.
Parameter Value Usage
/Features: (none) Additional install features required for local standards
/Options: (none) Additional install options required for local standards

Files Node

The keywords in this node contain the file names of components that will be used in the Build process. If an update for any file is downloaded, the new file name should replace the existing file name.

A list of these parameters is not included in this SQL FineBuild Parameter Inventory.

Copyright FineBuild Team © 2014 - 2016. License and Acknowledgements
Previous FineBuild Parameter Syntax Top FineBuild Setup Parameters Next

Last edited Nov 14, 2016 at 1:54 PM by EdVassie, version 9