-
Notifications
You must be signed in to change notification settings - Fork 10
SQL DB Parameters
EdVassie edited this page Nov 23, 2021
·
8 revisions
| Previous FineBuild General Parameters | SQL AS Parameters Next |
|---|
The parameters that are useful for a SQL DB Install are given below. The parameters cover both the basic install and the provisioning that can be performed by SQL FineBuild.
If you are happy that the default value for a given parameter is right for your organisation then you do not need to provide that parameter. Where relevant, some parameters appear in multiple categories.
When you run SQL FineBuild you should always provide an /AdminPassword: parameter giving your own password in order to log on automatically after a reboot.
The parameters are divided into the following sections. You should always look at the Basic Install parameters, and then look at other parameters you need to provision specific items:
- SQL DB Basic Install
- Account Provisioning
- Always On Provisioning
- Buffer Pool Extension Provisioning
- Cluster Provisioning
- Community Components Provisioning
- Database Mail Provisioning
- Database Maintenance Provisioning
- Data Quality and Master Data Services Provisioning
- Disk Volume and Folder Provisioning
- Distributed Replay Provisioning
- Distributed Transaction Coordinator Provisioning
- External Services Provisioning
- FileStream Provisioning
- Full Text Search Provisioning
- Management Data Warehouse Provisioning
- Network Provisioning
- PolyBase Provisioning
- Replication Provisioning
- Service Pack and Cumulative Update Provisioning
- SQL Agent Provisioning
- SQL Server Configuration Provisioning
- SQL Service Provisioning
- tempdb Provisioning
- Version Upgrade Provisioning
- Special Situations
Parameters that are most commonly used with a SQL DB Install
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDB: | No | Set to YES to install SQL Database Engine |
| /Edition: | EVAL | Edition of SQL Server to be installed |
| /Instance: | MSSQLSERVER | Name of SQL Instance to install |
| /saPwd: | (none) | Password for the sa account |
| /SecurityMode: | (none) | Security Mode of SQL Server |
| /SqlSvcAccount: | (none) | Name of SQL DB Service Account |
| /SqlSvcPassword: | (none) | Password for SQL DB Service Account |
You should also consider the Vol Parameters
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /EnableRANU: | 1 | Enable Run as Normal User (SQL Express Edition only) |
| /ErrorReporting: | 0 | Automatically report errors back to Microsoft |
| /Features: | (none) | Additional Features to include in the FineBuild SQL Server Install |
| /Options: | (none) Additional Options to include in the FineBuild SQL Server Install | |
| /PID: | (discovered) | PID for SQL Server installation. Discovered from Install Media, except for SQL2005 |
| /SQMReporting: | 0 | (SQL 2014 and below) Report SQL Feature usage to Microsoft |
| Parameter | Default | Comment |
|---|---|---|
| /SetupCmdShell: | No | Setup xp_cmdshell Proxy Account |
| /CmdShellAccount: | (none) | Name of xp_Cmdshell Proxy Account |
| /CmdShellPassword: | (none) | Password for xp_Cmdshell Proxy Account |
| /GroupDBA: | (none) | Name of DBA sysadmin group |
| /GroupDBANonSA: | (none) | Name of DBA non sysadmin group |
| /KeyPassword: | (saPwd) | Password for securing Database Key Files, etc |
| /saName: | sa | New name of sa account |
| /saPwd: | (none) | Password for the sa account |
| /SecurityMode: | (none) | Security Mode of SQL Server |
| /SQLOperator: | "SQL Alerts" | Default Operator name for Alert notification |
| /SQLSysadminAccounts: | (none) | Additional SQL sysadmin Accounts |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SetupOldAccounts: | Yes | Configure Old Accounts to remove any redundant accounts |
| /SetupSAAccounts: | Yes | Configure Sysadmin accounts |
| /SetupSAPassword: | Yes | Configure sa Account name and password |
| /SetupStdAccounts: | Yes | Configure Standard Accounts for SQL Server |
| /NTAuthAccount: | "Network Service" | (Windows 2008 R2 and below) Default Service Account name |
| /RoleDBANonSA: | DBA_NonAdmin | DBA Non-Sysadmin System Role name |
The capabilities of following parameters have been superceeded by AutoConfig Processing:
| Parameter | Default | Comment |
|---|---|---|
| /NumLogins: | 20 | Maximum number of Additional Accounts to process |
| /UserLoginnn: | (none) | Additional SQL logins (nn is 01 to NumLogins) |
| /UserPasswordnn: | (none) | Passwords for Additional SQL logins (nn is 01 to NumLogins:) |
| /WinLoginnn: | (none) | Additional Windows logins (nn is 01 to NumLogins) |
Parameters that can be added to the basic install in order to provision for Always On. These parameters are only valid if you are installing on to a Windows Cluster.
| Parameter | Default | Comment |
|---|---|---|
| /SetupAlwaysOn: | No | Setup Always On for a SQL Server Always On Install |
| /SetupAOAlias: | (none) | Setup DNS Alias for Availability Group |
| /SetupAODB: | No | Add existing databases to Availability Group |
| /SetupAOProcs: | (none) | Install procedures for managing Availability Groups |
| /AGName: | (none) | Name of Availability Group (non-clustered only) |
| /AGDagName: | (none) | Name of Distributed Availability Group |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /ClusterNameAO: | (calculated) | Name of Always On Cluster |
| /ClusAOSuffix: | AO | Suffix added to Windows Cluster Name to form the Always On Cluster Name |
| /ClusAOIPSuffix: | (calculated) | TCP final octet for AO Cluster address |
| /EncryptAO: | AES | Encryption algorithm for Always On communications |
| /TCPPortAO: | 5022 | Port for Always On communication |
Parameters for SQL2019 and above:
| Parameter | Default | Comment |
|---|---|---|
| /SetMemOptHybridBP: | (none) | (SQL 2019 and above) Set to ON to use Memory Optimised Hybrid Bufferpool hardware |
Parameters for old style Buffer Pool Extension:
| Parameter | Default | Comment |
|---|---|---|
| /SetupBPE: | No | Configure Buffer Pool Extension |
| /BPEFile: | "100 GB" | Size of BPE File |
| /VolBPE: | (VolTemp) | Volume to host BPE Volume |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /LabBPE: | BPE | Volume Label to be applied to BPE Volume |
Parameters that can be added to the basic install in order to provision a SQL Server Cluster. These parameters are only valid if you are installing on to a Windows Cluster.
Cluster names can either be generated automatically or supplied by you. See Cluster Naming Convention for more details of how this is done.
The following parameters are most commonly used with a SQL Server Cluster Install. You should also see Distributed Transaction Coordinator Provisioning
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDBCluster: | No | Set to YES to install a SQL Server DB Engine Cluster |
| /SetupAPCluster: | No | Enforce Active/Passive cluster configuration |
The following parameters are mandatory for SQL2005 or for installing on Windows 2003, but are not required for more recent versions:
| Parameter | Default | Comment |
|---|---|---|
| /AgtClusterGroup: | (none) | Local Group holding SQL Agent Service Accounts |
| /SQLClusterGroup: | (none) | Local Group holding SQL DB Service Accounts |
| /FTSClusterGroup: | (none) | Name of FTS Cluster Group |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /AgtDomainGroup: | (none) | (SQL2008 and above) Local Group holding SQL Agent Service Accounts (Optional) |
| /ClusterNameSQL: | (calculated) | Name of SQL DB Cluster |
| /ClusterNameAO: | (calculated) | Name of Always On Cluster |
| /ClusterNameFS: | (calculated) | Name of File Server Cluster |
| /ClusAOIPSuffix: | (calculated) | TCP final octet for AO Cluster address |
| /ClusDBIPSuffix: | (calculated) | TCP final octet for SQL DB Cluster address |
| /ClusterTCP: | IPv4 | Default type of IP address to use for SQL DB Cluster |
| /ClusAOSuffix: | AO | Suffix added to Windows Cluster Name to form the Always On Cluster Name |
| /ClusDBSuffix: | DB | Suffix added to Windows Cluster Name to form the DB Engine Cluster Name |
| /ClusWinSuffix: | (none) | Suffix removed from Windows Cluster Name before forming remaining cluster names |
| /ClusStorage: | Available Storage | Name of cluster Available Storage group |
| /ConfirmIPDependencyChange: | 0 | Prompt for IP Dependency Change for Distributed Clusters |
| /NetNameSource: | CLUSTER | CLUSTER: Rename Server adaptors to match names used in the Cluster any other: Rename Cluster adaptors to match names used on the Server |
| /PreferredOwner: | (none) | Preferred Server to own Cluster Roles |
| /SetupClusterShares: | No | Setup Shares for Cluster Volumes |
| /SQLDomainGroup: | (none) | (SQL2008 and above) Local Group holding SQL DB Service Accounts (Optional) |
Parameters that can install and configure Communuity Components
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLBC: | Yes | Install SQL 2005 Backward Compatibility components |
Older components not suitable for SQL2014 and above are listed at Legacy Tools
Parameters that can be added to the basic install in order to provision for Database Mail.
| Parameter | Default | Comment |
|---|---|---|
| /SetupDBMail: | Yes | Configure Database Mail |
| /DBMailProfile: | "Public DB Mail" | Name of default public DB Mail profile |
| /DBAEmail: | (none) | Email Address for DBA Alert Messages |
| /MailServer: | (none) | Mail Server Name or Alias |
| /SQLEmail: | (DBAEmail) | DBMail public Email Address |
| Parameter | Default | Comment |
|---|---|---|
| /SetupDBAManagement: | Yes | Setup basic DBA management routines |
| /SetupDBOpts: | Yes | Setup FineBuild Standard Database Options |
| /SetupGenMaint: | Yes | Configure Generic Maintenance Processes |
| /DBAEmail: | (none) | Email Address for DBA Alert Messages |
| /SetBackupStart: | "21:00:00" | Time Database Full Backups will start |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /DBA_DB: | DBA_Data | Database name to hold DBA routines |
| /DBOwner: | DBOwner | Name of default Database Owner account |
| /JobCategory: | Database Maintenance | Name of Job Category for Database Maintenance jobs |
| /SetBackupRetain: | 23 | Number of hours a Full or Differential Backup will be retained |
| /SetBackupLogFreq: | 60 | Number of minutes between Database Log Backups |
| /SetBackupLogRetain: | 24 | Number of hours a Log Backup will be retained |
| Parameter | Default | Comment |
|---|---|---|
| /SetupDQ: | (none) | Setup Data Quality Services |
| /SetupDQC: | (Yes | Setup Data Quality Client |
| /SetupMDS: | (none) | Setup Master Data Services (MDS) |
| /SetupMDSC: | (none) | Install Master Data Services Client |
| /DQPassword: | (saPwd) | Password for Data Quality Services |
| /MDSAccount: | (none) | Name of MDS Account |
| /MDSPassword: | (none) | Password for MDS Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /MDSDB: | MDSData | Name of Master Data Services database |
| /MDSPort: | 5091 | Port for Master Data Services Web Site |
| /MSDSite: | MDS | Name of MDS Web Site |
Depending on the SQL Server version, the /Vol... parameters can specify either a Drive Letter, a Share Name, a File URI, or a CSV path
| Parameter | Default | Comment |
|---|---|---|
| /VolData: | (System Drive) | Volume to host SQL DB data files |
| /VolBackup: | (VolData) | Volume to host SQL DB backup files |
| /VolDataFS: | (VolData) | Volume to host SQL DB Filestream files |
| /VolDataFT: | (VolData) | Volume to host Full Text files |
| /VolTemp: | (VolData) | Volume to host tempdb data files |
| /VolLog: | (VolData) | Volume to host SQL DB log files |
| /VolLogTemp: | (VolLog) | Volume to host tempdb log file |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /DirDBA: | "DBA Files" | Folder name to hold DBA files |
| /DirSQL: | MSSQL | Folder name to hold SQL Server database files, etc |
| /LabBackup: | "Backup" | Volume Label to be applied to Backup Volume |
| /LabData: | "SQL Data" | Volume Label to be applied to SQL Data Volume |
| /LabDataFS: | "FS Data" | Volume Label to be applied to SQL FileStream Volume |
| /LabDataFT: | "FT Data" | Volume Label to be applied to SQL Full Text Volume |
| /LabDBA: | "DBA Misc" | Volume Label to be applied to DBA Files Volume |
| /LabLog: | "SQL Log" | Volume Label to be applied to SQL Log Volume |
| /LabLogTemp: | "Temp Log" | Volume Label to be applied to SQL tempdb Log Volume |
| /LabSysDB: | "SQL SysDB" | Volume Label to be applied to SQL System Databases Volume |
| /LabTemp: | "SQL Temp" | Volume Label to be applied to SQL tempdb data Volume |
| /PathSQLSP: | "..\Service Packs" | Path to Service Packs folder |
| /SQLProgDir: | "Microsoft SQL Server" | High-level folder name for SQL Server programs |
Parameters to provision Distributed Replay.
For SQL2008 R2 and below these functions are provided via Install RML Utilities.
| Parameter | Default | Comment |
|---|---|---|
| /SetupDRUCLT: | Yes | Setup Distributed Replay Client |
| /SetupDRUCtlr: | (none) | Setup Distributed Replay Controller |
| /CltSvcAccount: | (none) | Name of Distributed Replay Client Service Account |
| /CltSvcPassword: | (none) | Password for Distributed Replay Client Service Account |
| /CtlrSvcAccount: | (none) | Name of Distributed Replay Controller Service Account |
| /CtlrSvcPassword: | (none) | Password for Distributed Replay Controller Service Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /CltStartupType: | Manual | Distributed Replay Controller Service startup type |
| /CtlrStartupType: | Manual | Distributed Replay Controller Service startup type |
Distributed Transaction Coordinator items are normally only relevant for a Cluster Install
| Parameter | Default | Comment |
|---|---|---|
| /SetupDTCCID: | Yes | Setup new CID for MSDTC |
| /SetupDTCCluster: | (none) | Setup MSDTC Cluster |
| /SetupDTCNetAccess: | No | Setup MSDTC Network Access |
| /VolDTC: | (System Drive) | Volume to host MSDTC data |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /ClusDTCIPSuffix: | (calculated) | TCP final octet for DTC Cluster address |
| /ClusDTCSuffix: | TC | Suffix added to Windows Cluster Name to form the MSDTC Cluster Name |
| /DTCMultiInstance: | Yes | Create a dedicated MSDTC Cluster for each SQL DB Instance Cluster |
| /LabDTC: | MSDTC | Volume Label to be applied to MSDTC Volume |
| /TCPPortDTC | 13300 | Port for DTC communication |
| Parameter | Default | Comment |
|---|---|---|
| /SetupAnalytics: | (none) | Setup External Advanced Analytics Server |
| /SetupPython: | (none) | Install Python Services |
| /SetupRServer: | (none) | Install R Services |
| /ExtSvcAccount: | (none) | Name of External Services Service Account |
| /ExtSvcPassword: | (none) | Password for External Services Service Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SQLSharedMR: | Yes | Configure R Services to be shared with SQL Server |
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDBFS: | Yes | Install SQL Server Filestream components |
| /FileStreamLevel: | 2 | Level of Filestream provisioning |
| /FileStreamShareName: | FS(instance) | Share Name for Filestream |
| /LabDataFS: | "FS Data" | Volume Label to be applied to SQL FileStream Volume |
| /VolDataFS: | (VolData) | Volume to host FileStream files |
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDBFT: | Yes | Install SQL Server Full Text Search components |
| /SetupSemantics: | Yes | Install Semantic Search |
| /FTSVCAccount: | "NT Service" | Name of Full Text Search Account |
| /FTSVCPassword: | (none) | Password for Full Text Search Account |
| /VolDataFT: | (VolData) | Volume to host Full Text files |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /LabDataFT: | "FT Data" | Volume Label to be applied to SQL Full Text Volume |
| /SetupFT: | Yes | Configure SQL Server Full Text options (if installed) |
| Parameter | Default | Comment |
|---|---|---|
| /SetupManagementDW: | (none) | Configure Management Data Warehouse |
| /ManagementServer: | (none) | Name or Alias of server to host Management Data Warehouse |
| /MDWAccount: | (none) | Name of MDW Data Collector Proxy Account |
| /MDWPassword: | (none) | Password for MDW Data Collector Proxy Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /ManagementDW: | ManagementDW | Database name for Management Data Warehouse |
| Parameter | Default | Comment |
|---|---|---|
| /NetNameSource: | Cluster | Source for renaming Network Adaptor names |
| /TCPPort: | 1433 | Port for SQL Server |
| /TCPPortDAC: | 1434 | Port for SQL Server DAC |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /DisableNetworkProtocols: | 0 | (SQL2005 Only) Disable specified network protocols |
| /NPEnabled: | 1 | (SQL2008 and above) Enable Named Pipes Protocol |
| /TCPEnabled: | 1 | Enable TCP Protocol |
| Parameter | Default | Comment |
|---|---|---|
| /SetupPolyBase: | (none) | Install PolyBase |
| /PBDMSSvcAccount: | (none) | Name of PolyBase Data Mover Service Account |
| /PBDMSSvcPassword: | (none) | Password for PolyBase Data Mover Service Account |
| /PBEngSvcAccount: | (none) | Name of PolyBase Engine Service Account |
| /PBEngSvcPassword: | (none) | Password for PolyBase Engine Service Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /PBPortRange: | "16450-16460" | PolyBase Port Range |
| /PBScaleout: | True | Enable Scaleout for PolyBase |
| /PBDMSSvcStartupType: | Automatic | PolyBase Data Mover Service startup type |
| /PBEngSvcStartupType: | Automatic | PolyBase Engine Service startup type |
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDBRepl: | Yes | Install SQL Server Replication components |
| /SetupDistributor: | No | Setup SL Server Replication Distributor Database |
| /DistributorDatabase: | Distribution | Name of Replication Distribution database |
| /DistributorPassword: | (saPwd) | Password for Replication Distribution |
These parameters are relevant only for /Type:FIX processing and when installing SQL 2008 R2 and below
| Parameter | Default | Comment |
|---|---|---|
| /SetupSP: | Yes | Install SQL Server Service Pack |
| /SetupSPCU: | Yes | Configure SQL Server Cumulative Update |
| /SetupSPCUSnac: | Yes | Configure SQL Server Native Client update |
| /SPLevel: | (varies) | Desired Service Pack Level. Varies dependent on SQL Version |
| /SPCULevel: | (varies) | Desired Cumulative Update Level. Varies dependent on SQL Version |
Parameters that can be added to the Basic Install in order to provision SQL Agent:
| Parameter | Default | Comment |
|---|---|---|
| /AgentJobHistory: | 500 | Number of history records to be kept for a given SQL Agent Job |
| /AgentMaxHistory: | 20000 | Maximum number of Job History records to be kept |
| /AgtSvcAccount: | (SqlSvcAccount) | Name of SQL Agent Service Account |
| /AgtSvcPassword: | (SqlSvcPassword) | Password for SQL Agent Service Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SetupSQLDBAG: | Yes | Install SQL Agent components |
| /SetupSQLAgent: | Yes | Configure SQL Agent Properties |
| /AGTSvcStartupType: | Automatic | (SQL2008 and above) SQL Agent service startup type |
| /AGTAutoStart: | 1 | (SQL2005 only) SQL Agent service startup type |
Parameters that control SQL Server configuration
| Parameter | Default | Comment |
|---|---|---|
| /SetupGovernor: | (none) | Setup Resource Governor |
| /SetupNonSaAccounts: | Yes | Configure DBA Non-Sysadmin Group |
| /SetupParam: | Yes | Configure SQL Startup Parameters |
| /SetupPBM: | Yes | Configure Policy Based Management |
| /SetupSnapshot: | Yes | Configure Snapshot Isolation |
| /SetupSQLDebug: | (none) | Setup Stored Procedure Remote Debugging ports |
| /SetupStretch: | No | Configure Azure Stretch Database support |
| /CollationSQL: | "Latin1_General_CI_AS" | Collation setting for SQL DB Engine |
| /SetCLREnabled: | 1 | Enable CLR |
| /SetCostThreshold: | 20 | Cost Threshold for Parallelism |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SetupDisableSA | Yes | Disable sa account |
| /SetupServices: | Yes | Configure SQL Service Recovery |
| /SetupServiceRights: | Yes | Configure service access rights |
| /SetupSQLInst: | Yes | Configure SQL Instance Properties |
| /SetupSQLServer: | Yes | Configure SQL Server Surface Area |
| /SetupSysDB: | Yes | Configure System Database options |
| /SetupSysIndex: | Yes | Configure additional indexes for System Databases |
| /SetupSysManagement: | Yes | Configure System DB Management |
| /AuditLevel: | 2 | Level of auditing within SQL Server |
| /MaxDop: | (calculated) | Maximum Degree of Parallelism (based on number of Processors) |
| /NumErrorLogs: | 30 | Number of SQL Server Errorlogs to be retained |
| /NumTF: | 20 | Maximum number of Trace Flag (/TFnn:) parameters to configure |
| /SetOptimizeForAdHocWorkloads: | 1 | Enable Optimize for Ad-Hoc Workloads |
| /SetRemoteAdminConnections: | 1 | Enable Remote Management of SQL Server |
| /SetRemoteProcTrans: | 0 | Enable MSDTC support for Remote Procedure execution |
| /SqlMaxMemory: | (calculated) | Maximum memory for SQL Server |
| /SqlMinMemory: | (calculated) | Minimum memory for SQL Server |
| /TallyCount: | 1000000 | Number of rows for Tally table |
| /TCPPortDebug: | (various) | Ports for Visual Studio SQL Debug. Ports vary by VS version |
| /TFnn: | (none) | Additional SQL Server Startup Trace Flags (nn is 01 to (NumTF)) |
Parameters that provision the various services associated with SQL Server. These can normally be left at their default values.
| Parameter | Default | Comment |
|---|---|---|
| /AgtSvcAccount: | (SqlSvcAccount) | Name of SQL Agent Service Account |
| /AgtSvcPassword: | (SqlSvcPassword) | Password for SQL Agent Service Account |
| /CltSvcAccount: | (none) | Name of Distributed Replay Client Service Account |
| /CltSvcPassword: | (none) | Password for Distributed Replay Client Service Account |
| /CtlrSvcAccount: | (none) | Name of Distributed Replay Controller Service Account |
| /CtlrSvcPassword: | (none) | Password for Distributed Replay Controller Service Account |
| /ExtSvcAccount: | (none) | Name of External Services Service Account |
| /ExtSvcPassword: | (none) | Password for External Services Service Account |
| /PBDMSSvcAccount: | (none) | Name of PolyBase Data Mover Service Account |
| /PBDMSSvcPassword: | (none) | Password for PolyBase Data Mover Service Account |
| /PBEngSvcAccount: | (none) | Name of PolyBase Engine Service Account |
| /PBEngSvcPassword: | (none) | Password for PolyBase Engine Service Account |
| /SqlSvcAccount: | (none) | Name of SQL DB Service Account |
| /SqlSvcPassword: | (none) | Password for SQL DB Service Account |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /AGTSvcStartupType: | Automatic | (SQL2008 and above) SQL Agent service startup type |
| /AGTAutoStart: | 1 | (SQL2005 only) SQL Agent service startup type |
| /BrowserSvcAccount: | "NT Service" | Name of SQL Browser Service Account |
| /BrowserSvcPassword: | (none) | Password for SQL Browser Service Account |
| /BrowserSvcStartupType: | Manual | (SQL2008 and above) SQL Browser service startup type |
| /CltStartupType: | Manual | Distributed Replay Controller Service startup type |
| /CtlrStartupType: | Manual | Distributed Replay Controller Service startup type |
| /FTSVCAccount: | "NT Service" | Name of Full Text Search Account |
| /FTSVCPassword: | (none) | Password for Full Text Search Account |
| /PBDMSSvcStartupType: | Automatic | PolyBase Data Mover Service startup type |
| /PBEngSvcStartupType: | Automatic | PolyBase Engine Service startup type |
| /SQLAutoStart: | 1 | (SQL2005 only) SQL DB service startup type |
| /SQLSvcStartupType: | Automatic | (SQL2008 and above) SQL DB service startup type |
| /SQLBrowserAutoStart: | 0 | (SQL2005 only) SQL Browser service startup type |
| /SQLWriterAutoStart: | 0 | (SQL2005 only) SQL VDI Writer service startup type |
| /TelvcAccount: | (none) | Name of SQL Telemetry Service Account |
| /TelSvcPassword: | (none) | Password for SQL Telemetry Service Account |
| /TelSvcStartupType: | Manual | SQL Telemetry service startup type |
| /WriterSvcStartupType: | Manual | (SQL2008 and above) SQL VDI Writer service startup type |
Parameters that can be added to the Basic Install in order to provision tempdb.
| Parameter | Default | Comment |
|---|---|---|
| /SetupTempDb: | Yes | Configure tempdb options |
| /SetMemOptTempdb: | (none) | (SQL2019 and above) Set to ON to enable Memory Optimised Tempdb |
| /SqlTempdbFileSize: | "200 MB" | Size of tempdb data files |
| /SqlTempdbLogFileSize: | "50 MB" | Size of tempdb log file |
| /VolLogTemp: | (VolLog) | Volume to host tempdb log file |
| /VolTemp: | (VolData) | Volume to host tempdb data files |
The following parameters can normally be left at their default values:
| Parameter | Default | Comment |
|---|---|---|
| /SqlTempdbFileCount: | (calculated) | Number of files for tempdb |
| /LabLogTemp: | TempLog | Volume Label to be applied to volume hosting tempdb log file |
| /LabTemp: | TempData | Volume Label to be applied to volume hosting tempdb data files |
Parameters that can be added to the Basic Install in order to provision an upgrade to a new version of SQL Server.
| Parameter | Default | Comment |
|---|---|---|
| /FailoverClusterRollOwnership: | (none) | Automatically Fail Over cluster during SQL Version upgrade |
| /FTUpgradeOption: | (none) | Upgrade Option for Full Text Search |
| /UseSysDB: | (none) | Use existing System Databases in upgrade |
- Non-English Versions Of SQL Server - please refer to the link for details of the parameters you need
Copyright FineBuild Team © 2018 - 2021. License and Acknowledgements
| Previous FineBuild General Parameters | Top | SQL AS Parameters Next |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP