| title | SQL Server installation - Command Prompt parameters | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.date | 07/26/2019 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.prod | sql | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.technology | install | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.reviewer | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.topic | conceptual | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| helpviewer_keywords |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.assetid | df40c888-691c-4962-a420-78a57852364d | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| author | MashaMSFT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ms.author | mathoma | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| monikerRange | >=sql-server-2016||=sqlallproducts-allversions |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
Before you run SQL Server Setup, review Planning a SQL Server Installation.
Installing a new instance of SQL Server at the command prompt enables you to specify the features to install and how they should be configured. You can also specify silent, basic, or full interaction with the Setup user interface.
Note
When installing through the command prompt, [!INCLUDEssNoVersion] supports full quiet mode by using the /Q parameter, or Quiet Simple mode by using the /QS parameter. The /QS switch only shows progress, does not accept any input, and displays no error messages if encountered. The /QS parameter is only supported when /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/install is specified.
Regardless of the installation method, you are required to confirm acceptance of the software license terms as an individual or on behalf of an entity, unless your use of the software is governed by a separate agreement such as a Microsoft volume licensing agreement or a third-party agreement with an ISV or OEM.
The license terms are displayed for review and acceptance in the Setup user interface. Unattended installations (using the /Q or /QS parameters) must include the /IACCEPTSQLSERVERLICENSETERMS parameter. You can review the license terms separately at Microsoft Software License Terms.
Note
Depending on how you received the software (for example, through Microsoft volume licensing), your use of the software may be subject to additional terms and conditions.
Command prompt installation is supported in the following scenarios:
-
Installing, upgrading, or removing an instance and shared components of SQL Server on a local computer by using syntax and parameters specified at the command prompt.
-
Installing, upgrading, or removing a failover cluster instance.
-
Upgrading from one [!INCLUDEssNoVersion] edition to another edition of [!INCLUDEssNoVersion].
-
Installing an instance of [!INCLUDEssNoVersion] on a local computer by using syntax and parameters specified in a configuration file. You can use this method to copy an installation configuration to multiple computers, or to install multiple nodes of a failover cluster installation.
When you install [!INCLUDEssNoVersion] at the command prompt, specify Setup parameters for your installation at the command prompt as part of your installation syntax.
Note
For local installations, you must run Setup as an administrator. If you install [!INCLUDEssNoVersion] from a remote share, you must use a domain account that has read and execute permissions on the remote share. For failover cluster installations, you must be a local administrator with permissions to login as a service, and to act as part of the operating system on all failover cluster nodes.
Use the following guidelines to develop installation commands that have correct syntax:
-
/PARAMETER
-
/PARAMETER=true/false
-
/PARAMETER=1/0 for Boolean types
-
/PARAMETER="value" for all single-value parameters. Using double quotation marks is recommended, but required if the value contains a space
-
/PARAMETER="value1" "value2" "value3" for all multiple-value parameters. Using double quotation marks is recommended, but required if the value contains a space
Exceptions:
/FEATURES, which is a multivalued parameter, but its format is/FEATURES=AS,RS,ISwithout a space, comma-delimited
Examples:
-
/INSTANCEDIR=c:\Pathis supported. -
/INSTANCEDIR="c:\Path"is supported
Important
When installing [!INCLUDEssNoVersion], if you specify the same directory path for INSTANCEDIR and SQLUSERDBDIR, SQL Server Agent and Full Text Search do not start due to missing permissions.
Note
The relational server values support the additional terminating backslash formats (backslash or two backslash characters) for the path.
Important
The value for the /PID parameter should be enclosed in double quotation marks.
| Parameter | Values | Required | Description |
|---|---|---|---|
/ACTION = |
- Install - PrepareImage - CompleteImage - Upgrade - Repair - Rebuilddatabase - Unintall - PrepareFailoverCluster - InstallFailoverCluster - CompleteFailoverCluster - AddNode - RemoveNode |
Required | Determines the SQL Server workflow, such as intalling SQL Server, preparing a Sysprep image, or preparing a failover cluster for a SQL Server installation. |
/IACCEPTPYTHONLICENSETERMS |
Blank | Required with /Q or /QS parameter. | Only used during a quiet installation that includes the Anaconda Python package. Required to acknowledge acceptance of Python license terms. |
/IACCEPTROPENLICENSETERMS |
Blank | Required with /Q or /QS parameter. | Only used during a quiet installation that includes R Services. Required to acknowledge acceptance of R Open license terms. |
/ENU |
Blank | Optional | Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
/UpdateEnabled |
Blank | Optional | Specify whether SQL Server setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, SQL Server setup will include updates that are found. |
/UpdateSource = |
MU, or <path to file> |
Optional | Specify the location where SQL Server setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default, SQL Server setup will search Microsoft Update or a Windows Update Service through the Windows Server Update Services. |
/CONFIGURATIONFILE = |
<path to file> |
Optional | Specifies the ConfigurationFile to use. |
/FEATURES = |
SQL, SQLEngine, Replication, FullText, DQ, Polybase, AdvancedAnalytics, SQL_INST_MR, SQL_INST_MPY, AS, RS, RS_SHP, RS_SHPWFE, DQC, IS, MDS, SQL_SHARED_MPY, SQL_SHARED_MR, Toos, BC, Conn, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, SDK, LocalDB | Required | Selects the feature to modify. For a detailed list, see Feature parameters. |
/ROLE = |
SP_AS_ExistingFarm, SPI_AS_NewFarm, AllFeatures_WithDefaults | Optional | Used to install a preconfigured selection of features. For more information, see Role parameters. |
/HELP, /? |
Blank | ||
/INDICATEPROGRESS |
Blank | Optional | Specifies that the verbose Setup log file is piped to the console. |
/INSTALLSHAREDDIR = |
A file path. Default is %Program Files%\Microsoft SQL Server |
Optional | Specifies a nondefault installation directory for 64-bit shared components. Cannot be set to %Program Files(x86)%\Microsoft SQL Server. |
/INSTALLSHAREDWOWDIR = |
A fail path. Default is %Program Files(x86)%\Microsoft SQL Server |
Optional | Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system. Cannot be set to %Program Files%\Microsoft SQL Server. |
/INSTANCEDIR = |
A file path. | Optional | Specifies a nondefault installation directory for instance-specific components. |
/INSTANCEID = |
A string value. | Optional | Specifies a nondefault value for an InstanceID. |
/INSTANCENAME = |
A string value. | Required | Specifies a SQL Server instance name. |
/PID = |
A string value. | Optional | Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used. |
Q, /QUIET |
Blank | Optional | Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
/QS, /QUIETSIMPLE |
Blank | Optional | Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
UIMODE |
| Parameter | Values | Required | Description |
|---|---|---|---|
| /SUPPRESSPRIVACYSTATEMENTNOTICE | Blank | Optional | Only used for installation. Suppresses the privacy notice statement. By using this flag, you are agreeing with the privacy notice. |
| /IACCEPTSQLSERVERLICENSETERMS | Blank | Required only when the /Q or /QS parameter is specified for unattended installations. | Only used for installation. Required to acknowledge acceptance of the license terms. |
| Parameter | Values | Required | Description |
|---|---|---|---|
/PBENGSVCACCOUNT= |
A string value. Default is NT Authority\NETWORK SERVICE | Optional | Specifies the account for the Polybase engine service. |
/PBDMSSVCPASSWORD = |
A string value. | Optional | Specifies the password for the Polybase engine service account. |
/PBENGSVCSTARTUPTYPE = |
Automatic (default), disabled, manual. | Optional | Specifies the startup mode for the PolyBase engine service. |
/PBPORTRANGE = |
Numeric value - numeric value | Optional | Specifies a port range with at least 6 ports for PolyBase services. Example: /PBPORTRANGE=16450-16460 |
/PBSCALEOUT |
True, False | Optional | Specifies if the SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. |
Before you install a [!INCLUDEssDEnoversion] failover cluster instance, review the following articles:
-
[Hardware and Software Requirements for Installing [!INCLUDEssSQL15]](../../sql-server/install/hardware-and-software-requirements-for-installing-sql-server.md)
-
Always On Failover Cluster Instances (SQL Server)
[!IMPORTANT]
All failover cluster installation commands require an underlying Windows cluster. All the nodes that will be part of a [!INCLUDEssDEnoversion] failover cluster must be part of the same Windows cluster.
Test and modify the following failover cluster installation scripts to meet the needs of your organization.
Use the parameters in the following table to develop command-line scripts for failover cluster installation.
For more information about Integrated Installation, see Always On Failover Cluster Instances (SQL Server).
Note
To add more nodes after the installation, use Add Node action.
| [!INCLUDEssDEnoversion] component | Parameter | Details |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate the failover cluster installation work flow. Supported value: InstallFailoverCluster |
| [!INCLUDEssDEnoversion] Setup Control | /IACCEPTSQLSERVERLICENSETERMS Required only when the /Q or /QS parameter is specified for unattended installations. |
Required to acknowledge acceptance of the license terms. |
| [!INCLUDEssDEnoversion] Setup Control | /ENU Optional |
Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERGROUP Optional |
Specifies the name of the resource group to be used for the [!INCLUDEssDEnoversion] failover cluster. It can be the name of an existing cluster group or the name of a new resource group. Default value: SQL Server (<InstanceName>) |
| PolyBase | /PBENGSVCACCOUNT Optional |
Specifies the account for the engine service. The default is NT Authority\NETWORK SERVICE. |
| PolyBase | /PBDMSSVCPASSWORD Optional |
Specifies the password for the engine service account. |
| PolyBase | /PBENGSVCSTARTUPTYPE Optional |
Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual. |
| PolyBase | /PBPORTRANGE Optional |
Specifies a port range with at least 6 ports for PolyBase services. Example:/PBPORTRANGE=16450-16460 |
| PolyBase | /PBSCALEOUT Optional |
Specifies if the [!INCLUDEssDEnoversion] instance will be used as a part of PolyBase Scale-out computational group. Supported values: True, False |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateEnabled Optional |
Specify whether SQL Server setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, SQL Server setup will include updates that are found. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateSource Optional |
Specify the location where SQL Server setup will obtain product updates. The valid values are "MU" to search [!INCLUDEmsCoName] Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default, SQL Server setup will search [!INCLUDEmsCoName] Update or a Windows Update Service through the Windows Server Update Services. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /ERRORREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled |
| [!INCLUDEssDEnoversion] Setup Control | /FEATURES Required |
Specifies components to install. |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTALLSHAREDDIR Optional |
Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server |
| [!INCLUDEssDEnoversion] Setup Control | /INSTALLSHAREDWOWDIR Optional |
Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system. Default is %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files%\Microsoft SQL Server |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCEDIR Optional |
Specifies nondefault installation directory for instance-specific components. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCEID Optional |
Specifies a nondefault value for an InstanceID. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration. |
| [!INCLUDEssDEnoversion] Setup Control | /PID Optional |
Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
| [!INCLUDEssDEnoversion] Setup Control | /QS or /QUIETSIMPLE Optional |
Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
| [!INCLUDEssDEnoversion] Setup Control | /SQMREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies feature usage reporting for SQL Server. Supported values: 1=enabled 0=disabled |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies the console window would be hidden or closed. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERDISKS Optional |
Specifies the list of shared disks to be included in the [!INCLUDEssDEnoversion] failover cluster resource group. Default value: The first drive is used as the default drive for all databases. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERIPADDRESSES Required |
Specifies an encoded IP address. The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. Supported IP types include DHCP, IPv4, and IPv6. You can specify multiple failover cluster IP addresses with a space in between. See the following examples: FAILOVERCLUSTERIPADDRESSES=DEFAULTFAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1 |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERNETWORKNAME Required |
Specifies the network name for the new [!INCLUDEssDEnoversion] failover cluster. This name is used to identify the new [!INCLUDEssDEnoversion] failover cluster instance on the network. |
| SQL Server Agent | /AGTSVCACCOUNT Required |
Specifies the account for the SQL Server Agent service. |
| SQL Server Agent | /AGTSVCPASSWORD Required |
Specifies the password for SQL Server Agent service account. |
| [!INCLUDEssASnoversion] | /ASBACKUPDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] backup files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup |
| [!INCLUDEssASnoversion] | /ASCOLLATION Optional |
Specifies the collation setting for [!INCLUDEssASnoversion]. Default value: Latin1_General_CI_AS |
| [!INCLUDEssASnoversion] | /ASCONFIGDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] configuration files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config |
| [!INCLUDEssASnoversion] | /ASDATADIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data |
| [!INCLUDEssASnoversion] | /ASLOGDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] log files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log |
| [!INCLUDEssASnoversion] | /ASSYSADMINACCOUNTS Required |
Specifies the administrator credentials for [!INCLUDEssASnoversion]. |
| [!INCLUDEssASnoversion] | /ASTEMPDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] temporary files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp |
| [!INCLUDEssASnoversion] | /ASPROVIDERMSOLAP Optional |
Specifies whether the MSOLAP provider can run in-process. Default value: 1=enabled |
| [!INCLUDEssASnoversion] | /ASSERVERMODE Optional |
Specifies the server mode of the [!INCLUDEssASnoversion] instance. Valid values in a cluster scenario are MULTIDIMENSIONAL or TABULAR. ASSERVERMODE is case-sensitive. All values must be expressed in upper case. For more information about the valid values, see Install Analysis Services in Tabular Mode. |
| [!INCLUDEssDEnoversion] | /INSTALLSQLDATADIR Required |
Specifies the data directory for [!INCLUDEssNoVersion] data files. The data directory must to specified and on a shared cluster disk. |
| [!INCLUDEssDEnoversion] | /SAPWD Required when /SECURITYMODE=SQL |
Specifies the password for the [!INCLUDEssNoVersion] SA account. |
| [!INCLUDEssDEnoversion] | /SECURITYMODE Optional |
Specifies the security mode for [!INCLUDEssNoVersion]. If this parameter is not supplied, then Windows-only authentication mode is supported. Supported value: SQL |
| [!INCLUDEssDEnoversion] | /SQLBACKUPDIR Optional |
Specifies the directory for backup files. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup |
| [!INCLUDEssDEnoversion] | /SQLCOLLATION Optional |
Specifies the collation settings for [!INCLUDEssNoVersion]. The default value is based on the locale of your Windows operating system. For more information, see Collation Settings in Setup. |
| [!INCLUDEssDEnoversion] | /SQLSVCACCOUNT Required |
Specifies the startup account for the [!INCLUDEssNoVersion] service. |
| [!INCLUDEssDEnoversion] | /SQLSVCPASSWORD Required |
Specifies the password for SQLSVCACCOUNT. |
| [!INCLUDEssDEnoversion] | /SQLSYSADMINACCOUNTS Required |
Use this parameter to provision logins to be members of the sysadmin role. |
| [!INCLUDEssDEnoversion] | /SQLUSERDBDIR Optional |
Specifies the directory for the data files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBDIR Optional |
Specifies the directories for tempdb data files. When specifying more than one directory, separate the directories with a blank space. If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)NOTE: This parameter is added to RebuildDatabase scenario as well. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGDIR Optional |
Specifies the directory for tempdb log file. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)Note: This parameter is added to RebuildDatabase scenario as well. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILECOUNT Optional |
Specifies the number of tempdb data files to be added by setup. This value can be increased up to the number of cores. Default value: 1 for [!INCLUDEssExpress] 8 or the number of cores, whichever is lower for all other editions Important: The primary database file for tempdb will still be tempdb.mdf. The additional tempdb files are named as tempdb_mssql_#.ndf where # represents a unique number for each additional tempdb database file created during setup. The purpose of this naming convention is to make them unique. Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] is not supported for configuring this parameter. Setup installs only 1 tempdb data file. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILESIZE Optional |
Introduced in [!INCLUDEssSQL15]. Specifies the initial size of each tempdb data file. Default = 8 MB. Min = 8 MB. Max = 1024 MB (262,144 MB for [!INCLUDEssSQL14]. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILEGROWTH Optional |
Specifies the file growth increment of each tempdb data file in MB. A value of 0 indicates that automatic growth is off and no additional space is allowed. Setup allows the size up to 1024. Default value: 64 Allowed range: Min = 0, Max = 1024 |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGFILESIZE Optional |
Specifies the initial size of the tempdb log file in MB. Setup allows the size up to 1024. Default value: 4 for [!INCLUDEssExpress] 8 for all other editions Allowed range: Min = default value (4 or 8), Max = 1024 |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGFILEGROWTH Optional |
Introduced in [!INCLUDEssSQL15]. Specifies the initial size of each tempdb log file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions. Min = (4 or 8 MB). Max = 1024 MB (262,144 MB for [!INCLUDEssSQL14] |
| [!INCLUDEssDEnoversion] | /SQLUSERDBLOGDIR Optional |
Specifies the directory for the log files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data |
| FILESTREAM | /FILESTREAMLEVEL Optional |
Specifies the access level for the FILESTREAM feature. Supported values: 0 =Disable FILESTREAM support for this instance. (Default value) 1=Enable FILESTREAM for [!INCLUDEtsql] access. 2=Enable FILESTREAM for [!INCLUDEtsql] and file I/O streaming access. (Not valid for cluster scenarios) 3=Allow remote clients to have streaming access to FILESTREAM data. |
| FILESTREAM | /FILESTREAMSHARENAME Optional Required when FILESTREAMLEVEL is greater than 1. |
Specifies the name of the windows share in which the FILESTREAM data will be stored. |
| SQL Server Full Text | /FTSVCACCOUNT Optional |
Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEfirstref_longhorn] or higher. ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon. If the values are not provided the Full-text Filter Launcher Service will be disabled. You have to use SQL Server Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account |
| SQL Server Full Text | /FTSVCPASSWORD Optional |
Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEfirstref_longhorn] or higher. |
| [!INCLUDEssISnoversion] | /ISSVCACCOUNT Required |
Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE |
| [!INCLUDEssISnoversion] | /ISSVCPASSWORD Required |
Specifies the [!INCLUDEssISnoversion] password. |
| [!INCLUDEssISnoversion] | /ISSVCStartupType Optional |
Specifies the startup mode for the [!INCLUDEssISnoversion] service. |
| [!INCLUDEssRSnoversion] | /RSINSTALLMODE Optional |
Specifies the Install mode for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssRSnoversion] | /RSSVCACCOUNT Required |
Specifies the startup account for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssRSnoversion] | /RSSVCPASSWORD Required |
Specifies the password for the startup account for [!INCLUDEssRSnoversion] service. |
| [!INCLUDEssRSnoversion] | /RSSVCStartupType Optional |
Specifies the startup mode for [!INCLUDEssRSnoversion]. |
We recommend that you use Service SID instead of domain groups.
The [!INCLUDEssDE] and [!INCLUDEssASnoversion] are the only components that are cluster-aware. Other features are not cluster-aware and do not have high availability through failover.
To install a single-node [!INCLUDEssDEnoversion] failover cluster instance with the [!INCLUDEssDE] and [!INCLUDEssASnoversion], default instance.
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/InstallFailoverCluster /InstanceName=MSSQLSERVER /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\UserName>" /ASDATADIR=<Drive>:\OLAP\Data /ASLOGDIR=<Drive>:\OLAP\Log /ASBACKUPDIR=<Drive>:\OLAP\Backup /ASCONFIGDIR=<Drive>:\OLAP\Config /ASTEMPDIR=<Drive>:\OLAP\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'" /FAILOVERCLUSTERNETWORKNAME="<Insert Network Name>" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;Cluster Network;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="MSSQLSERVER" /Features=AS,SQL /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /SQLSYSADMINACCOUNTS="<DomainName\UserName> /IACCEPTSQLSERVERLICENSETERMS
Use the parameters in the following table to develop command-line scripts for failover cluster prepare. This is the first step in advanced cluster installation, where you have to prepare the failover cluster instances on all the nodes of the failover cluster. For more information, see Always On Failover Cluster Instances (SQL Server).
| [!INCLUDEssDEnoversion] component | Parameter | Description |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate the failover cluster prepare work flow. Supported value: PrepareFailoverCluster |
| [!INCLUDEssDEnoversion] Setup Control | /IACCEPTSQLSERVERLICENSETERMS Required only when the /Q or /QS parameter is specified for unattended installations. |
Required to acknowledge acceptance of the license terms. |
| [!INCLUDEssDEnoversion] Setup Control | /ENU Optional |
Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateEnabled Optional |
Specify whether SQL Server setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, SQL Server setup will include updates that are found. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateSource Optional |
Specify the location where SQL Server setup will obtain product updates. The valid values are "MU" to search [!INCLUDEmsCoName] Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default, [!INCLUDEssNoVersion] setup will search [!INCLUDEmsCoName] Update or a Windows Update Service through the Windows Server Update Services. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /ERRORREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 0=disabled 1=enabled |
| [!INCLUDEssDEnoversion] Setup Control | /FEATURES Required |
Specifies components to install. |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTALLSHAREDDIR Optional |
Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server |
| [!INCLUDEssDEnoversion] Setup Control | /INSTALLSHAREDWOWDIR Optional |
Specifies a nondefault installation directory for 32-bit shared components. Supported only on a 64-bit system. Default is %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files%\Microsoft SQL Server |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCEDIR Optional |
Specifies nondefault installation directory for instance specific components. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCEID Optional |
Specifies a nondefault value for an InstanceID. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration. |
| PolyBase | /PBENGSVCACCOUNT Optional |
Specifies the account for the engine service. The default is NT Authority\NETWORK SERVICE. |
| PolyBase | /PBDMSSVCPASSWORD Optional |
Specifies the password for the engine service account. |
| PolyBase | /PBENGSVCSTARTUPTYPE Optional |
Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual. |
| PolyBase | /PBPORTRANGE Optional |
Specifies a port range with at least 6 ports for PolyBase services. Example:/PBPORTRANGE=16450-16460 |
| PolyBase | /PBSCALEOUT Optional |
Specifies if the [!INCLUDEssDEnoversion] instance will be used as a part of PolyBase Scale-out computational group. Supported values: True, False |
| [!INCLUDEssDEnoversion] Setup Control | /PID Optional |
Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
| [!INCLUDEssDEnoversion] Setup Control | /QS or /QUIETSIMPLE Optional |
Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
| [!INCLUDEssDEnoversion] Setup Control | /SQMREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies feature usage reporting for SQL Server. Supported values: 0=disabled 1=enabled |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies that the console window is hidden or closed. |
| SQL Server Agent | /AGTSVCACCOUNT Required |
Specifies the account for the SQL Server Agent service. |
| SQL Server Agent | /AGTSVCPASSWORD Required |
Specifies the password for SQL Server Agent service account. |
| [!INCLUDEssASnoversion] | /ASSVCACCOUNT Required |
Specifies the account for the [!INCLUDEssASnoversion] service. |
| [!INCLUDEssASnoversion] | /ASSVCPASSWORD Required |
Specifies the password for the [!INCLUDEssASnoversion] service. |
| [!INCLUDEssDEnoversion] | /SQLSVCACCOUNT Required |
Specifies the startup account for the SQL Server service. |
| [!INCLUDEssDEnoversion] | /SQLSVCPASSWORD Required |
Specifies the password for SQLSVCACCOUNT. |
| FILESTREAM | /FILESTREAMLEVEL Optional |
Specifies the access level for the FILESTREAM feature. Supported values: 0 =Disable FILESTREAM support for this instance. (Default value) 1=Enable FILESTREAM for [!INCLUDEtsql] access. 2=Enable FILESTREAM for [!INCLUDEtsql] and file I/O streaming access. (Not valid for Cluster scenarios) 3=Allow remote clients to have streaming access to FILESTREAM data. |
| FILESTREAM | /FILESTREAMSHARENAME Optional Required when FILESTREAMLEVEL is greater than 1. |
Specifies the name of the windows share in which the FILESTREAM data will be stored. |
| SQL Server Full Text | /FTSVCACCOUNT Optional |
Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEfirstref_longhorn] or higher. ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon. If the values are not provided the Full-text Filter Launcher Service will be disabled. You have to use SQL Server Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account |
| SQL Server Full Text | /FTSVCPASSWORD Optional |
Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEfirstref_longhorn] or higher. |
| [!INCLUDEssISnoversion] | /ISSVCACCOUNT Required |
Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE |
| [!INCLUDEssISnoversion] | /ISSVCPASSWORD Required |
Specifies the [!INCLUDEssISnoversion] password. |
| [!INCLUDEssISnoversion] | /ISSVCStartupType Optional |
Specifies the startup mode for the [!INCLUDEssISnoversion] service. |
| [!INCLUDEssRSnoversion] | /RSINSTALLMODE Available only on Files only mode. |
Specifies the Install mode for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssRSnoversion] | /RSSVCACCOUNT Required |
Specifies the startup account for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssRSnoversion] | /RSSVCPASSWORD Required |
Specifies the password for the startup account for [!INCLUDEssRSnoversion] service. |
| [!INCLUDEssRSnoversion] | /RSSVCStartupType Optional |
Specifies the startup mode for [!INCLUDEssRSnoversion]. |
We recommend that you use Service SID instead of domain groups.
To perform the "Preparation" step of a failover cluster advanced installation scenario for the [!INCLUDEssDE] and [!INCLUDEssASnoversion].
Run the following command at the command prompt to prepare a default instance:
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/PrepareFailoverCluster /InstanceName=MSSQLSERVER /Features=AS,SQL /INDICATEPROGRESS /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx" /IACCEPTSQLSERVERLICENSETERMS
Run the following command at the command prompt to prepare a named instance:
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/PrepareFailoverCluster /InstanceName="<Insert Instance name>" /Features=AS,SQL /INDICATEPROGRESS /ASSVCACCOUNT="<DomainName\UserName>" /ASSVCPASSWORD="xxxxxxxxxxx" /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="xxxxxxxxxxx" /AGTSVCACCOUNT="<DomainName\UserName>" /AGTSVCPASSWORD="xxxxxxxxxxx" /IACCEPTSQLSERVERLICENSETERMS
Use the parameters in the following table to develop command-line scripts for failover cluster complete. This is the second step in the advanced failover cluster install option. After you have run prepare on all the failover cluster nodes, you run this command on the node that owns the shared disks. For more information, see Always On Failover Cluster Instances (SQL Server).
| [!INCLUDEssDEnoversion] component | Parameter | Description |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate the failover cluster complete work flow. Supported value: CompleteFailoverCluster |
| [!INCLUDEssDEnoversion] Setup Control | /ENU Optional |
Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERGROUP Optional |
Specifies the name of the resource group to be used for the [!INCLUDEssDEnoversion] failover cluster. It can be the name of an existing cluster group or the name of a new resource group. Default value: [!INCLUDEssNoVersion] (<InstanceName>) |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /ERRORREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies the error reporting for [!INCLUDEssNoVersion]. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 1=enabled 0=disabled |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration |
| [!INCLUDEssDEnoversion] Setup Control | /PID Optional |
Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter is not specified, Evaluation is used. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
| [!INCLUDEssDEnoversion] Setup Control | /QS or /QUIETSIMPLE Optional |
Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
| [!INCLUDEssDEnoversion] Setup Control | /SQMREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies feature usage reporting for [!INCLUDEssNoVersion]. Supported values: 1=enabled 0=disabled |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies that the console window is hidden or closed. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERDISKS Optional |
Specifies the list of shared disks to be included in the [!INCLUDEssDEnoversion] failover cluster resource group. Default value: The first drive is used as the default drive for all databases. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERIPADDRESSES Required |
Specifies an encoded IP address. The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. Supported IP types include DHCP, IPv4, and IPv6. You can specify multiple failover cluster IP addresses with a space in between. See the following examples: FAILOVERCLUSTERIPADDRESSES=DEFAULTFAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1 |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERNETWORKNAME Required |
Specifies the network name for the new [!INCLUDEssDEnoversion] failover cluster. This name is used to identify the new [!INCLUDEssDEnoversion] failover cluster instance on the network. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIRMIPDEPENDENCYCHANGE | Indicates the consent to set the IP address resource dependency to OR for multi-subnet failover clusters. For more information, see Create a new SQL Server Failover Cluster (Setup). Supported Values: 0 = False (Default) 1 = True |
| [!INCLUDEssASnoversion] | /ASBACKUPDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] backup files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup |
| [!INCLUDEssASnoversion] | /ASCOLLATION Optional |
Specifies the collation setting for [!INCLUDEssASnoversion]. Default value: Latin1_General_CI_AS |
| [!INCLUDEssASnoversion] | /ASCONFIGDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] configuration files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config |
| [!INCLUDEssASnoversion] | /ASDATADIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data |
| [!INCLUDEssASnoversion] | /ASLOGDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] log files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log |
| [!INCLUDEssASnoversion] | /ASSERVERMODE Optional |
Specifies the server mode of the Analysis Services instance. Valid values in a cluster scenario are MULTIDIMENSIONAL or TABULAR. ASSERVERMODE is case-sensitive. All values must be expressed in upper case. For more information about the valid values, see Install Analysis Services in Tabular Mode. |
| [!INCLUDEssASnoversion] | /ASSYSADMINACCOUNTS Required |
Specifies the administrator credentials for [!INCLUDEssASnoversion]. |
| [!INCLUDEssASnoversion] | /ASTEMPDIR Optional |
Specifies the directory for [!INCLUDEssASnoversion] temporary files.Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp |
| [!INCLUDEssASnoversion] | /ASPROVIDERMSOLAP Optional |
Specifies whether the MSOLAP provider can run in-process. Default value: 1=enabled |
| [!INCLUDEssDEnoversion] | /INSTALLSQLDATADIR Required |
Specifies the data directory for [!INCLUDEssNoVersion] data files. The data directory must to specified and on a shared cluster disk. |
| [!INCLUDEssDEnoversion] | /SAPWD Required when /SECURITYMODE=SQL |
Specifies the password for the [!INCLUDEssNoVersion] SA account. |
| [!INCLUDEssDEnoversion] | /SECURITYMODE Optional |
Specifies the security mode for [!INCLUDEssNoVersion]. If this parameter is not supplied, then Windows-only authentication mode is supported Supported value: SQL |
| [!INCLUDEssDEnoversion] | /SQLBACKUPDIR Optional |
Specifies the directory for backup files. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup |
| [!INCLUDEssDEnoversion] | /SQLCOLLATION Optional |
Specifies the collation settings for [!INCLUDEssNoVersion]. The default value is based on the locale of your Windows operating system. For more information, see Collation Settings in Setup. |
| [!INCLUDEssDEnoversion] | /SQLSYSADMINACCOUNTS Required |
Use this parameter to provision logins to be members of the sysadmin role. |
| [!INCLUDEssDEnoversion] | /SQLUSERDBDIR Optional |
Specifies the directory for the data files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data |
| [!INCLUDEssDEnoversion] | /SQLUSERDBLOGDIR Optional |
Specifies the directory for the log files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data |
| [!INCLUDEssRSnoversion] | /RSINSTALLMODE Available on files only mode. |
Specifies the Install mode for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBDIR Optional |
Specifies the directories for tempdb data files. When specifying more than one directory, separate the directories with a blank space. If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)NOTE: This parameter is added to RebuildDatabase scenario as well. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGDIR Optional |
Specifies the directory for tempdb log file. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)Note: This parameter is added to RebuildDatabase scenario as well. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILECOUNT Optional |
Specifies the number of tempdb data files to be added by setup. This value can be increased up to the number of cores. Default value: 1 for [!INCLUDEssExpress] 8 or the number of cores, whichever is lower for all other editions. Important: The primary database file for tempdb will still be tempdb.mdf. The additional tempdb files are named as tempdb_mssql_#.ndf where # represents a unique number for each additional tempdb database file created during setup. The purpose of this naming convention is to make them unique. Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] is not supported for configuring this parameter. Setup installs only 1 tempdb data file. |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILESIZE Optional |
Introduced in [!INCLUDEssSQL15]. Specifies the initial size of each tempdb data file. Default = 8 MB. Min = 8 MB. Max = 1024 MB (262,144 MB for [!INCLUDEssSQL14]). |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBFILEGROWTH Optional |
Specifies the file growth increment of each tempdb data file in MB. A value of 0 indicates that automatic growth is off and no additional space is allowed. Setup allows the size up to 1024. Default value: 64 Allowed range: Min = 0, Max = 1024 |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGFILESIZE Optional |
Specifies the initial size of the tempdb log file in MB. Setup allows the size up to 1024. Default value: 4 for [!INCLUDEssExpress] 8 for all other editions Allowed range: Min = default value (4 or 8), Max = 1024 |
| [!INCLUDEssDEnoversion] | /SQLTEMPDBLOGFILEGROWTH Optional |
Introduced in [!INCLUDEssSQL15]. Specifies the initial size of each tempdb log file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions. Min = (4 or 8 MB). Max = 1024 MB (262,144 MB for [!INCLUDEssSQL14] |
To perform the "Completion" step of a failover cluster advanced installation scenario for the [!INCLUDEssDE] and [!INCLUDEssASnoversion]. Run the following command on the computer that will be the active node in the failover cluster to make it usable. You must run the "CompleteFailoverCluster" action on the node that owns the shared disk in the [!INCLUDEssASnoversion] failover cluster.
Run the following command at the command prompt to complete failover cluster installation for a default instance:
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/CompleteFailoverCluster /InstanceName=MSSQLSERVER /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\Username>" /ASDATADIR=<Drive>:\OLAP\Data /ASLOGDIR=<Drive>:\OLAP\Log /ASBACKUPDIR=<Drive>:\OLAP\Backup /ASCONFIGDIR=<Drive>:\OLAP\Config /ASTEMPDIR=<Drive>:\OLAP\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'>:" /FAILOVERCLUSTERNETWORKNAME="<Insert FOI Network Name>" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;Cluster Network;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="MSSQLSERVER" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSYSADMINACCOUNTS="<DomainName\UserName>"
Run the following command at the command prompt to complete failover cluster installation for a named instance:
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/CompleteFailoverCluster /InstanceName="<Insert Instance Name>" /INDICATEPROGRESS /ASSYSADMINACCOUNTS="<DomainName\UserName>" /ASDATADIR=<Drive>:\KATMAI\Data /ASLOGDIR=<drive>:\KATMAI\Log /ASBACKUPDIR=<Drive>:\KATMAI\Backup /ASCONFIGDIR=<Drive>:\KATMAI\Config /ASTEMPDIR=<Drive>:\KATMAI\Temp /FAILOVERCLUSTERDISKS="<Cluster Disk Resource Name - for example, 'Disk S:'>" /FAILOVERCLUSTERNETWORKNAME="CompNamedFOI" /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;ClusterNetwork1;xxx.xxx.xxx.x" /FAILOVERCLUSTERGROUP="<Insert New Group Name>" /INSTALLSQLDATADIR="<Drive>:\<Path>\MSSQLSERVER_KATMAI" /SQLCOLLATION="SQL_Latin1_General_CP1_CS_AS" /SQLSYSADMINACCOUNTS="<DomainName\Username>"
Use the parameters in the following table to develop command-line scripts for failover cluster upgrade. For more information, see [Upgrade a [!INCLUDEssDEnoversion] failover Cluster Instance (Setup)](../../sql-server/failover-clusters/windows/upgrade-a-sql-server-failover-cluster-instance-setup.md) and Always On Failover Cluster Instances (SQL Server).
| [!INCLUDEssDEnoversion] component | Parameter | Description |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate the installation workflow. Supported value: Upgrade |
| [!INCLUDEssDEnoversion] Setup Control | /IACCEPTSQLSERVERLICENSETERMS Required only when the /Q or /QS parameter is specified for unattended installations. |
Required to acknowledge acceptance of the license terms. |
| [!INCLUDEssDEnoversion] Setup Control | /ENU Optional |
Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateEnabled Optional |
Specify whether SQL Server setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, SQL Server setup will include updates that are found. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateSource Optional |
Specify the location where SQL Server setup will obtain product updates. The valid values are "MU" to search [!INCLUDEmsCoName] Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default, [!INCLUDEssNoVersion] setup will search [!INCLUDEmsCoName] Update or a Windows Update Service through the Windows Server Update Services. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /ERRORREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEssSQL15] to send feedback to Microsoft](https://support.microsoft.com/kb/3153756). In older versions this specifies the error reporting for SQL Server. For more information, see Privacy Statement for the Microsoft Error Reporting Service. Supported values: 0=disabled 1=enabled |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | / INSTANCEDIR Optional |
Specifies a non-default installation directory for shared components. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCEID Required when you upgrade from [!INCLUDEssKatmai] or higher. Optional when you upgrade from [!INCLUDEssVersion2005] |
Specifies a nondefault value for an InstanceID. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration. |
| [!INCLUDEssDEnoversion] Setup Control | /PID Optional |
Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. |
| [!INCLUDEssDEnoversion] Setup Control | /SQMREPORTING Optional |
Has no effect in [!INCLUDEssSQL15]. In older versions this specifies feature usage reporting for SQL Server. Supported values: 0=disabled 1=enabled |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies that the console window is hidden or closed. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERROLLOWNERSHIP | Specifies the failover behavior during upgrade. |
| SQL Server Browser Service | /BROWSERSVCSTARTUPTYPE Optional |
Specifies the startup mode for SQL Server Browser service. Supported values: Automatic Disabled Manual |
| SQL Server Full-Text | /FTUPGRADEOPTION Optional |
Specifies the Full-Text catalog upgrade option. Supported values: REBUILD RESET IMPORT |
| [!INCLUDEssISnoversion] | /ISSVCACCOUNT Required |
Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE |
| [!INCLUDEssISnoversion] | /ISSVCPASSWORD Required |
Specifies the [!INCLUDEssISnoversion] password. |
| [!INCLUDEssISnoversion] | /ISSVCStartupType Optional |
Specifies the startup mode for the [!INCLUDEssISnoversion] service. |
| [!INCLUDEssRSnoversion] | /RSUPGRADEDATABASEACCOUNT Optional |
The property is only used when upgrading a SharePoint mode Report Server that is version 2008 R2 or earlier. Additional upgrade operations are performed for report servers that use the older SharePoint mode architecture, which was changed in [!INCLUDEssSQL11] [!INCLUDEssRSnoversion]. If this option is not included with the command line installation, the default service account for the old report server instance is used. If this property is used, supply the password for the account using the /RSUPGRADEPASSWORD property. |
| [!INCLUDEssRSnoversion] | /RSUPGRADEPASSWORD Optional |
Password of the existing Report Server service account. |
Use the parameters in the following table to develop command-line scripts for AddNode.
| [!INCLUDEssDEnoversion] component | Parameter | Description |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate AddNode work flow. Supported value: AddNode |
| [!INCLUDEssDEnoversion] Setup Control | /IACCEPTSQLSERVERLICENSETERMS Required only when the /Q or /QS parameter is specified for unattended installations. |
Required to acknowledge acceptance of the license terms. |
| [!INCLUDEssDEnoversion] Setup Control | /ENU Optional |
Use this parameter to install the English version of [!INCLUDEssNoVersion] on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateEnabled Optional |
Specify whether [!INCLUDEssNoVersion] setup should discover and include product updates. The valid values are True and False or 1 and 0. By default, SQL Server setup will include updates that are found. |
| [!INCLUDEssDEnoversion] Setup Control | /UpdateSource Optional |
Specify the location where SQL Server setup will obtain product updates. The valid values are "MU" to search [!INCLUDEmsCoName] Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default, [!INCLUDEssNoVersion] setup will search [!INCLUDEmsCoName] Update or a Windows Update Service through the Windows Server Update Services. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration. |
| PolyBase | /PBENGSVCACCOUNT Optional |
Specifies the account for the engine service. The default is NT Authority\NETWORK SERVICE. |
| PolyBase | /PBDMSSVCPASSWORD Optional |
Specifies the password for the engine service account. |
| PolyBase | /PBENGSVCSTARTUPTYPE Optional |
Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual. |
| PolyBase | /PBPORTRANGE Optional |
Specifies a port range with at least 6 ports for PolyBase services. Example:/PBPORTRANGE=16450-16460 |
| PolyBase | /PBSCALEOUT Optional |
Specifies if the [!INCLUDEssDEnoversion] instance will be used as a part of PolyBase Scale-out computational group. Supported values: True, False |
| [!INCLUDEssDEnoversion] Setup Control | /PID Optional |
Specifies the product key for the edition of SQL Server. If this parameter is not specified, Evaluation is used. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
| [!INCLUDEssDEnoversion] Setup Control | /QS or /QUIETSIMPLE Optional |
Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies that the console window is hidden or closed. |
| [!INCLUDEssDEnoversion] Setup Control | /FAILOVERCLUSTERIPADDRESSES Required |
Specifies an encoded IP address. The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. Supported IP types include DHCP, IPv4, and IPv6. You can specify multiple failover cluster IP addresses with a space in between. See the following examples: FAILOVERCLUSTERIPADDRESSES=DEFAULTFAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1For more information, see [Add or Remove Nodes in a [!INCLUDEssDEnoversion] failover Cluster (Setup)](../../sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup.md). |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIRMIPDEPENDENCYCHANGE Required |
Indicates the consent to set the IP address resource dependency to OR for multi-subnet failover clusters. For more information, see [Add or Remove Nodes in a [!INCLUDEssDEnoversion] failover Cluster (Setup)](../../sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup.md). Supported values: 0 = False (Default) 1 = True |
| SQL Server Agent | /AGTSVCACCOUNT Required |
Specifies the account for the SQL Server Agent service. |
| SQL Server Agent | /AGTSVCPASSWORD Required |
Specifies the password for SQL Server Agent service account. |
| [!INCLUDEssASnoversion] | /ASSVCACCOUNT Required |
Specifies the account for the [!INCLUDEssASnoversion] service. |
| [!INCLUDEssASnoversion] | /ASSVCPASSWORD Required |
Specifies the password for the [!INCLUDEssASnoversion] service. |
| [!INCLUDEssDEnoversion] | /SQLSVCACCOUNT Required |
Specifies the startup account for the SQL Server service. |
| [!INCLUDEssDEnoversion] | /SQLSVCPASSWORD Required |
Specifies the password for SQLSVCACCOUNT. |
| [!INCLUDEssISnoversion] | /ISSVCPASSWORD Required |
Specifies the [!INCLUDEssISnoversion] password. |
| [!INCLUDEssRSnoversion] | /RSINSTALLMODE Available in Files only mode |
Specifies the Install mode for [!INCLUDEssRSnoversion]. |
| [!INCLUDEssRSnoversion] | /RSSVCPASSWORD Required |
Specifies the startup account password for the [!INCLUDEssRSnoversion] service. |
The [!INCLUDEssDE] and [!INCLUDEssASnoversion] are the only components that are cluster-aware. Other features are not cluster-aware and do not have high availability through failover.
To add a node to an existing failover cluster instance with the [!INCLUDEssDE] and [!INCLUDEssASnoversion].
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/AddNode /INSTANCENAME="<Insert Instance Name>" /SQLSVCACCOUNT="<SQL account that is used on other nodes>" /SQLSVCPASSWORD="<password for SQL account>" /AGTSVCACCOUNT="<SQL Server Agent account that is used on other nodes>", /AGTSVCPASSWORD="<SQL Server Agent account password>" /ASSVCACCOUNT="<AS account that is used on other nodes>" /ASSVCPASSWORD="<password for AS account>" /INDICATEPROGRESS /IACCEPTSQLSERVERLICENSETERMS /FAILOVERCLUSTERIPADDRESSES="IPv4;xx.xxx.xx.xx;ClusterNetwork1;xxx.xxx.xxx.x" /CONFIRMIPDEPENDENCYCHANGE=0
Use the parameters in the following table to develop command-line scripts for RemoveNode. To uninstall a failover cluster, you must run RemoveNode on each failover cluster node. For more information, see Always On Failover Cluster Instances (SQL Server).
| [!INCLUDEssDEnoversion] component | Parameter | Description |
|---|---|---|
| [!INCLUDEssDEnoversion] Setup Control | /ACTION Required |
Required to indicate RemoveNode work flow. Supported value: RemoveNode |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIGURATIONFILE Optional |
Specifies the ConfigurationFile to use. |
| [!INCLUDEssDEnoversion] Setup Control | /HELP, H, ? Optional |
Displays the usage options for the parameters. |
| [!INCLUDEssDEnoversion] Setup Control | /INDICATEPROGRESS Optional |
Specifies that the verbose Setup log file will be piped to the console. |
| [!INCLUDEssDEnoversion] Setup Control | /INSTANCENAME Required |
Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration. |
| [!INCLUDEssDEnoversion] Setup Control | /Q or /QUIET Optional |
Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations. The /Q parameter overrides the input of the /QS parameter. |
| [!INCLUDEssDEnoversion] Setup Control | /QS or /QUIETSIMPLE Optional |
Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages. |
| [!INCLUDEssDEnoversion] Setup Control | /HIDECONSOLE Optional |
Specifies that the console window is hidden or closed. |
| [!INCLUDEssDEnoversion] Setup Control | /CONFIRMIPDEPENDENCYCHANGE Required |
Indicates the consent to set the IP address resource dependency from OR to AND for multi-subnet failover clusters. For more information, see [Add or Remove Nodes in a [!INCLUDEssDEnoversion] failover Cluster (Setup)](../../sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup.md). Supported values: 0 = False (Default) 1 = True |
To remove a node from an existing failover cluster instance with the [!INCLUDEssDE] and [!INCLUDEssASnoversion].
setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/9b9625163856e69195e4f2b7ebcfcf9cc07e1ed2/docs/database-engine/install-windows/RemoveNode /INSTANCENAME="<Insert Instance Name>" [/INDICATEPROGRESS] /CONFIRMIPDEPENDENCYCHANGE=0
You can configure the SQL Server services by using a built-in account, local account, or domain account.
Note
When you use a managed service account, virtual account, or a built-in account, you should not specify the corresponding password parameters. For more information about these service accounts, see New Account Types Available with [!INCLUDEwin7] and [!INCLUDEwinserver2008r2] section in Configure Windows Service Accounts and Permissions.
For more information about service account configuration, see Configure Windows Service Accounts and Permissions.
| [!INCLUDEssDEnoversion] component | Account parameter | Password parameter | Startup type |
|---|---|---|---|
| SQL Server Agent | /AGTSVCACCOUNT | /AGTSVCPASSWORD | /AGTSVCSTARTUPTYPE |
| [!INCLUDEssASnoversion] | /ASSVCACCOUNT | /ASSVCPASSWORD | /ASSVCSTARTUPTYPE |
| [!INCLUDEssDEnoversion] | /SQLSVCACCOUNT | /SQLSVCPASSWORD | /SQLSVCSTARTUPTYPE |
| [!INCLUDEssISnoversion] | /ISSVCACCOUNT | /ISSVCPASSWORD | /ISSVCSTARTUPTYPE |
| [!INCLUDEssRSnoversion] | /RSSVCACCOUNT | /RSSVCPASSWORD | /RSSVCSTARTUPTYPE |
To install specific features, use the /FEATURES parameter and specify the parent feature or feature values in the following table. For a list of features that are supported by the editions of SQL Server, see [Editions and Supported Features for [!INCLUDEssSQL15]](../../sql-server/editions-and-supported-features-for-sql-server-2016.md).
| Parent feature parameter | Feature parameter | Description |
|---|---|---|
| SQL | Installs the [!INCLUDEssDEnoversion], Replication, Fulltext, and [!INCLUDEssDQSServer]. | |
| SQLEngine | Installs just the [!INCLUDEssDEnoversion]. | |
| Replication | Installs the Replication component along with [!INCLUDEssDEnoversion]. | |
| FullText | Installs the FullText component along with [!INCLUDEssDEnoversion]. | |
| DQ | Copies the files required for completing the [!INCLUDEssDQSServer] installation. After completing SQL Server installation, you must run the DQSInstaller.exe file to complete the [!INCLUDEssDQSServer] installation. For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation. This also installs [!INCLUDEssDEnoversion]. | |
| PolyBase | Installs PolyBase components. | |
| AdvancedAnalytics | Installs SQL Server 2017 Machine Learning Services or SQL Server 2016 R Services (In-Database). | |
| SQL_INST_MR | Applies to SQL Server 2017 Machine Learning Services. Pair with AdvancedAnalytics to install R Open and proprietary R packages. | |
| SQL_INST_MPY | Applies to SQL Server 2017 Machine Learning Services. Pair with AdvancedAnalytics to install Anaconda and proprietary Python packages. | |
| AS | Installs all [!INCLUDEssASnoversion] components. | |
| RS | Installs all [!INCLUDEssRSnoversion] components. | |
| RS_SHP | Installs [!INCLUDEssRSnoversion] components for SharePoint. | |
| RS_SHPWFE | Installs [!INCLUDEssRSnoversion] Add-In for SharePoint products. | |
| DQC | Installs [!INCLUDEssDQSClient]. | |
| IS | Installs all [!INCLUDEssISnoversion] components. | |
| MDS | Installs [!INCLUDEssMDSshort]. | |
| SQL_SHARED_MPY | Installs Python packages for SQL Server 2017 Machine Learning Server (Standalone) | |
| SQL_SHARED_MR | Installs R packages for SQL Server 2016 R Server (Standalone) or SQL Server 2017 Machine Learning Server (Standalone) | |
| Tools* | Installs client tools and SQL Server Books Online components. | |
| BC | Installs backward compatibility components. | |
| Conn | Installs connectivity components. | |
| DREPLAY_CTLR | Installs Distributed Replay controller | |
| DREPLAY_CLT | Installs Distributed Replay client | |
| SNAC_SDK | Installs SDK for [!INCLUDEmsCoName] SQL Server Native Client | |
| SDK | Installs the software development kit. | |
| LocalDB** | Installs LocalDB, an execution mode of [!INCLUDEssExpress] targeted to program developers. |
*[!INCLUDEssManStudioFull] (SSMS) is now in a stand-alone installer that is separate from the [!INCLUDEssCurrent] installer. For details, see Install SQL Server Management Studio from the command line.
**LocalDB is an option when installing any SKU of [!INCLUDEssExpress]. For more information, see SQL Server 2016 Express LocalDB.
| Parameter and values | Description |
|---|---|
| /FEATURES=SQLEngine | Installs the [!INCLUDEssDE] without replication and full-text. |
| /FEATURES=SQLEngine,FullText | Installs the [!INCLUDEssDE] and full-text. |
| /FEATURES=SQL,Tools | Installs the complete [!INCLUDEssDE] and all tools. |
| /FEATURES=BOL | Installs SQL Server Books Online components to view and manage help content. |
| /FEATURES=SQLEngine,PolyBase | Installs the PolyBase engine. |
The setup role or /Role parameter is used to install a preconfigured selection of features. The SSAS roles install an SSAS instance in either an existing SharePoint farm, or a new un-configured farm. Two setup roles are provided to support each scenario. You can only choose one setup role to install at a time. If you choose a setup role, Setup installs the features and components that belong to the role. You cannot vary the features and components that are designated for that role. For more information about how to use the feature role parameter, see Install Power Pivot from the Command Prompt.
The AllFeatures_WithDefaults role is the default behavior for editions of [!INCLUDEssExpress] and reduces the number of dialog boxes presented to the user. It can be specified from the command line when installing a SQL Server edition that is not [!INCLUDEssExpress].
| Role | Description | Installs... |
|---|---|---|
| SPI_AS_ExistingFarm | Installs [!INCLUDEssASnoversion] as a [!INCLUDEssGemini] named instance on an existing [!INCLUDESPS2010] farm or standalone server. | [!INCLUDEssASnoversion] calculation engine, preconfigured for in-memory data storage and processing. [!INCLUDEssGemini] solution packages Installer program for the [!INCLUDEssGeminiClient] SQL Server Books Online |
| SPI_AS_NewFarm | Installs [!INCLUDEssASnoversion] and [!INCLUDEssDE] as a [!INCLUDEssGemini] named instance on a new, un-configured Office [!INCLUDESPS2010] farm or standalone server. SQL Server Setup will configure the farm during feature role installation. | [!INCLUDEssASnoversion] calculation engine, preconfigured for in-memory data storage and processing. [!INCLUDEssGemini] solution packages SQL Server Books Online [!INCLUDEssDE] Configuration Tools [!INCLUDEssManStudioFull] |
| AllFeatures_WithDefaults | Installs all features that are available with the current edition. Adds the current user to the SQL Server sysadmin fixed server role. On [!INCLUDEfirstref_longhorn] or higher and when the operating system is not a domain controller, the [!INCLUDEssDE], and [!INCLUDEssRSnoversion] are defaulted to use the NTAUTHORITY\NETWORK SERVICE account, and [!INCLUDEssISnoversion] is defaulted to use the NTAUTHORITY\NETWORK SERVICE account. This role is enabled by default in editions of [!INCLUDEssExpress]. For all other editions, this role is not enabled but can be specified through the UI or with command line parameters. |
For editions of [!INCLUDEssExpress], installs only those features available in the edition. For other editions, installs all [!INCLUDEssNoVersion] features. The AllFeatures_WithDefaults parameter can be combined with other parameters which override the AllFeatures_WithDefaults parameter settings. For example, using the AllFeatures_WithDefaults parameter and the /Features=RS parameter overrides the command to install all features and only installs [!INCLUDEssRSnoversion], but honors the AllFeatures_WithDefaults parameter to use the default service account for [!INCLUDEssRSnoversion]. When using the AllFeatures_WithDefaults parameter along with the /ADDCURRENTUSERASSQLADMIN=FALSE the provisioning dialog is not auto populated with the current user. Add /AGTSVCACCOUNT and /AGTSVCPASSWORD to specify a service account and password for the SQL Server Agent. |
To upgrade a [!INCLUDEssDEnoversion] failover cluster to [!INCLUDEssCurrent], you must run the Setup on one failover cluster node at a time, starting with the passive nodes. Setup determines when to fail over to the upgraded node, depending on the total number of nodes in the failover cluster instance, and the number of nodes that have already been upgraded. When half of the nodes or more have already been upgraded, Setup by default will cause a failover to an upgraded node.
To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter to control the failover behavior before the upgrade operation takes the node offline. Use of this parameter is as follows:
-
/FAILOVERCLUSTERROLLOWNERSHIP=0 will not roll cluster ownership (move group) to upgraded nodes, and does not add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
-
/FAILOVERCLUSTERROLLOWNERSHIP=1 will roll cluster ownership (move group) to upgraded nodes, and will add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.
-
/FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. It will be used if this parameter is not specified. This setting indicates that SQL Server Setup will manage cluster ownership (move group) as needed.
The Instance ID or /InstanceID parameter is used for specifying where you can install the instance components and the registry path of the instance. The value of INSTANCEID is a string and should be unique.
-
SQL Instance ID:
MSSQLxx.<INSTANCEID> -
AS Instance ID:
MSASxx.<INSTANCEID> -
RS Instance ID:
MSRSxx.<INSTANCEID>
The instance-aware components are installed to the following locations:
%Program Files%\Microsoft SQL Server\<SQLInstanceID>
%Program Files%\Microsoft SQL Server\<ASInstanceID>
%Program Files%\Microsoft SQL Server\<RSInstanceID>
Note
If INSTANCEID is not specified on the command line, then by default Setup substitute <INSTANCEID> with the <INSTANCENAME>.
Install SQL Server 2016 from the Installation Wizard
SQL Server Failover Cluster Installation
Install SQL Server 2016 Business Intelligence Features