install-sql-server-from-the-command-prompt.md

title	Install SQL Server on Windows from the command prompt
description	This article describes command prompt parameters for SQL Server installation on Windows. You can specify features to install and configure.
author	rwestMSFT
ms.author	randolphwest
ms.date	11/01/2022
ms.prod	sql
ms.technology	install
ms.topic	conceptual
ms.custom	intro-installation event-tier1-build-2022
helpviewer_keywords	installing SQL Server, command prompt installing SQL Server, command line installation scripts [SQL Server] maintenance scripts [SQL Server] REMOVENODE property components [SQL Server], removing command prompt [SQL Server], SQL Server installations ASACCOUNT parameter failover clustering [SQL Server], installing master database [SQL Server], rebuilding SQLCOLLATION parameter clusters [SQL Server], installing unattended installations [SQL Server] modifying collations AGTPASSWORD parameter USESYSDB parameter RSPASSWORD parameter AUTOSTART parameter ASPASSWORD parameter stand-alone installations [SQL Server] SAMPLEDATABASESERVER parameter adding components SAPWD parameter scripts [SQL Server], uninstallations remote installations [SQL Server] components [SQL Server], installing TARGETCOMPUTER parameter REMOVENODE parameter REINSTALLMODE parameter scripts [SQL Server], maintenance rebuilding registry SQLPASSWORD parameter rebuilding databases IP property PIDKEY parameter RSCONFIGURATION parameter ADDLOCAL parameter Setup [SQL Server], command prompt REBUILDDATABASE parameter SECURITYMODE parameter REMOVE property DISABLENETWORKPROTOCOLS parameter INSTALLDATADIR parameter REMOVE parameter removing components SQLACCOUNT parameter parameters [SQL Server], SQL Server installations UPGRADE parameter shortcuts [SQL Server] updating components removing SQL Server clustered instance of SQL Server INSTALLSQLDATADIR parameter RSACCOUNT parameter ADMINPASSWORD parameter GROUP property ERRORREPORTING property uninstallation scripts [SQL Server] AGTACCOUNT parameter SAVESYSDB parameter INSTALLVS parameter INSTANCENAME parameter scripts [SQL Server], installations rebuilding database, master uninstalling SQL Server ASCOLLATION parameter .ini files ADDNODE parameter command line installations [SQL Server] command prompt installations [SQL Server] VS parameter INSTALLASDATADIR parameter INSTALLSQLDIR parameter nodes [Faillover Clustering], command prompt INSTALLSQLSHAREDDIR parameter
monikerRange	>=sql-server-2016

Install SQL Server on Windows from the command prompt

[!INCLUDESQL Server -Windows Only]

Before you run [!INCLUDEssNoVersion] Setup, review Planning a SQL Server Installation.

Installing a new instance of [!INCLUDEssNoVersion] from 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.

To install from the command prompt, open an administrative command prompt and navigate to where setup.exe is located within the [[!INCLUDEssNoVersion] Setup media](https://www.microsoft.com/sql-server/sql-server-downloads). Run the setup.exe command, along with the required and optional parameters that accomplish what you're trying to do:

C:\SQLMedia\SQLServer2022> setup.exe /[Option] /[Option] = {value}

The following example installs the [!INCLUDEssDEnoversion], [!INCLUDEssNoVersion] Analysis Services, [!INCLUDEssNoVersion] and Integration Services in quiet mode:

C:\SQLMedia\SQLServer2022> setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION="/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/install"
/PID="AAAAA-BBBBB-CCCCC-DDDDD-EEEEE" /FEATURES=SQL,AS,IS
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"
/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "
/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"
/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"
/ISSVCACCOUNT="MyDomain\MyAccount" /ISSVCPASSWORD="************"
/ASSYSADMINACCOUNTS="MyDomain\MyAccount"

To view a list of all possible commands within the console, run the executable with the /help flag:

C:\SQLMedia\SQLServer2022> setup.exe /help

Important

A new installation parameter, /PRODUCTCOVEREDBYSA, was introduced in [!INCLUDE sssql22-md]. This parameter indicates whether the provided product key (/PID=) license is covered under a Software Assurance or SQL Server Subscription contract, or just a SQL Server license.

The rest of the article provides a detailed description of the available parameters.

Note

When installing through the command line, [!INCLUDEssNoVersion] supports full quiet mode with the /Q parameter, or quiet simple mode with 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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/INSTALL%3C/code> 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.

[!INCLUDEsql-eula-link]

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 line installation is supported in the following scenarios:

• Installing, upgrading, or removing an instance and shared components of [!INCLUDEssNoVersion] 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.

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.

Proper use of setup parameters

Use the following guidelines to develop installation commands that have correct syntax:

Parameter	Example
/PARAMETER	/INDICATEPROGRESS
/PARAMETER=true/false	/SQLSVCINSTANTFILEINIT=True
/PARAMETER=1/0 for Boolean types	/TCPENABLED=1
/PARAMETER="value" for all single-value parameters. For a parameter that requires a path: /INSTANCEDIR=C:\Path or /INSTANCEDIR="C:\Path" is supported.	/PID="PID" /SQLSVCSTARTUPTYPE="Automatic"
/PARAMETER="value1" "value2" "value3" for all multiple-value parameters. Exception: /FEATURES, which is a multivalued parameter, but its format is /FEATURES=AS,RS,IS without a space, comma-delimited.	/SQLSYSADMINACCOUNTS="Contoso\John" "Contoso\Mary"

Important

When installing [!INCLUDEssNoVersion], if you specify the same directory path for INSTANCEDIR and SQLUSERDBDIR, [!INCLUDEssNoVersion] 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.

The following sections provide parameters to develop command-line installation scripts for install, update, and repair scenarios.

Parameters that are listed for a [!INCLUDEssDEnoversion] component are specific to that component. [!INCLUDEssNoVersion] Agent and [!INCLUDEssNoVersion] Browser parameters are applicable when you install the [!INCLUDEssDEnoversion].

Installation parameters

Use the parameters in the following table to develop command-line scripts for installation.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: Install.
[!INCLUDEssde-md] Setup Control	/SUPPRESSPRIVACYSTATEMENTNOTICE Required, when the /Q or /QS parameter is specified for unattended installations	Suppresses the privacy notice statement. By using this flag, you are agreeing with the privacy notice.
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssNoVersion] Python Setup Control	/IACCEPTPYTHONLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations that include the Anaconda Python package.	Required to acknowledge acceptance of the license terms.
[!INCLUDEssNoVersion] R Setup Control	/IACCEPTROPENLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations that include the Microsoft R Open package.	Required to acknowledge acceptance of the license terms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/FEATURES or /ROLE Required	Specifies the components to install. Choose /FEATURES to specify individual [!INCLUDEssNoVersion] components to install. For more information, see Feature Parameters below. Choose /ROLE to specify a setup role. Setup roles install [!INCLUDEssNoVersion] in a predetermined configuration.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL Server Cannot be set to %Program Files(x86)%\Microsoft SQL Server
[!INCLUDEssde-md] 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 Server Cannot be set to %Program Files%\Microsoft SQL Server
[!INCLUDEssde-md] Setup Control	/INSTANCEDIR Optional	Specifies a nondefault installation directory for instance-specific components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PRODUCTCOVERDBYSA Applies to: [!INCLUDE sssql22-md] and later versions Required, when installing the Azure Extension feature from the command line with AZUREEXTENSION.	Specifies the license coverage for [!INCLUDE ssnoversion-md]. /PRODUCTCOVERDBYSA=True, or just /PRODUCTCOVERDBYSA, indicates it is covered under Software Assurance or [!INCLUDE ssnoversion-md] subscription. /PRODUCTCOVERDBYSA=False, or omitting the parameter, indicates it is covered under a SQL Server license.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/UIMODE Optional	Specifies whether to present only the minimum number of dialog boxes during setup. /UIMODE can only be used with the /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/INSTALL%3C/code> and UPGRADE parameters. Supported values: - /UIMODE=Normal is the default for non-Express editions and presents all setup dialog boxes for the selected features. - /UIMODE=AutoAdvance is the default for Express editions and skips nonessential dialog boxes. When combined with other parameters, UIMODE is overridden. For example, when /UIMODE=AutoAdvance and /ADDCURRENTUSERASSQLADMIN=FALSE are both provided, the provisioning dialog box isn't auto populated with the current user. The UIMODE setting can't be used with the /Q or /QS parameters.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT Required	Specifies the account for the [!INCLUDEssNoVersion] Agent service.
[!INCLUDEssNoVersion] Agent	/AGTSVCPASSWORD Required	Specifies the password for [!INCLUDEssNoVersion] Agent service account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssNoVersion] Agent	/AGTSVCSTARTUPTYPE Optional	Specifies the startup mode for the [!INCLUDEssNoVersion] Agent service. Supported values: - Automatic - Disabled - Manual
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Engine	/PBENGSVCPASSWORD Optional	Specifies the password for the engine service account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - Manual
PolyBase Data Movement	/PBDMSSVCACCOUNT Optional	Specifies the account for the data movement service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Data Movement	/PBDMSSVCSTARTUPTYPE Optional	Specifies the startup mode for the data movement service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!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\Backup For 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 Note: Only Windows collation is supported. Using SQL collation may result in unexpected behavior.
[!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\Config For 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\Data For 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\Log For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log
[!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 uppercase. For more information about valid values, see Install Analysis Services in Tabular Mode.
[!INCLUDEssASnoversion]	/ASSVCACCOUNT Required	Specifies the account for the [!INCLUDEssASnoversion] service.
[!INCLUDEssASnoversion]	/ASSVCPASSWORD Required	Specifies the password for the [!INCLUDEssASnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssASnoversion]	/ASSVCSTARTUPTYPE Optional	Specifies the startup mode for the [!INCLUDEssASnoversion] service. Supported values: - Automatic - Disabled - Manual
[!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\Temp For 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]	/FARMACCOUNT Required, for SPI_AS_NewFarm	Specifies a domain user account for running SharePoint Central Administration services and other essential services in a farm. This parameter is used only for [!INCLUDEssASnoversion] instances that are installed through /ROLE = SPI_AS_NEWFARM.
[!INCLUDEssASnoversion]	/FARMPASSWORD Required, for SPI_AS_NewFarm	Specifies a password for the farm account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssASnoversion]	/PASSPHRASE Required, for SPI_AS_NewFarm	Specifies a passphrase that is used to add additional application servers or Web front-end servers to a SharePoint farm. This parameter is used only for [!INCLUDEssASnoversion] instances that are installed through /ROLE = SPI_AS_NEWFARM.
[!INCLUDEssASnoversion]	/FARMADMINIPORT Required, for SPI_AS_NewFarm	Specifies a port used to connect to the SharePoint Central Administration web application. This parameter is used only for [!INCLUDEssASnoversion] instances that are installed through /ROLE = SPI_AS_NEWFARM.
[!INCLUDEssNoVersion] Browser	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for [!INCLUDEssNoVersion] Browser service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssDEnoversion]	/ENABLERANU Optional	Enables run-as credentials for [!INCLUDEssExpress] installations.
[!INCLUDEssDEnoversion]	/INSTALLSQLDATADIR Optional	Specifies the data directory for [!INCLUDEssNoVersion] data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ For all other installations: %Program Files%\Microsoft SQL Server\
[!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 isn't 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 installation setting is determined by the operating system (OS) locale. The server-level collation can either be changed during setup, or by changing the OS locale before installation. The default collation is set to the oldest available version that is associated with each specific locale. This is due to backwards compatibility reasons. Therefore, this isn't always the recommended collation. To take full advantage of [!INCLUDEssNoVersion] features, change the default installation settings to use Windows collations. For example, for the OS locale English (United States) (code page 1252), the default collation during setup is SQL_Latin1_General_CP1_CI_AS and can be changed to its closest Windows collation counterpart Latin1_General_100_CI_AS_SC. For more information, see Collations and Unicode support.
[!INCLUDEssDEnoversion]	/ADDCURRENTUSERASSQLADMIN Optional	Adds the current user to the [!INCLUDEssNoVersion] sysadmin fixed server role. The /ADDCURRENTUSERASSQLADMIN parameter can be used when installing Express editions or when /ROLE=AllFeatures_WithDefaults is used. For more information, see /ROLE below. Use of /ADDCURRENTUSERASSQLADMIN is optional, but either /ADDCURRENTUSERASSQLADMIN or /SQLSYSADMINACCOUNTS is required. Default values: True for editions of [!INCLUDEssExpress] False for all other editions
[!INCLUDEssDEnoversion]	/SQLSVCACCOUNT Required	Specifies the startup account for the [!INCLUDEssNoVersion] service.
[!INCLUDEssDEnoversion]	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssDEnoversion]	/SQLSVCSTARTUPTYPE Optional	Specifies the startup mode for the [!INCLUDEssNoVersion] service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssDEnoversion]	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role. For [!INCLUDEssNoVersion] editions other than [!INCLUDEssExpress], /SQLSYSADMINACCOUNTS is required. For editions of [!INCLUDEssExpress], use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
[!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 [!INCLUDEssNoVersion] deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_\*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] isn't supported for configuring this parameter. Setup installs only 1 tempdb data file.
[!INCLUDEssDEnoversion]	/SQLTEMPDBFILESIZE Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the initial size of each tempdb data file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions Min = 4 MB or 8 MB Max = 1024 MB
[!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 Applies to: [!INCLUDEsssql16-md] and later versions 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 Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the file growth increment of the tempdb log 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]	/SQLUSERDBDIR Optional	Specifies the directory for the data files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
[!INCLUDEssDEnoversion]	/SQLSVCINSTANTFILEINIT Optional	Enables instant file initialization for [!INCLUDEssNoVersion] service account. For security and performance considerations, see Database Instant File Initialization. Supported values: - False (default) - True
[!INCLUDEssDEnoversion]	/SQLUSERDBLOGDIR Optional	Specifies the directory for the log files for user databases. Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
[!INCLUDEssDEnoversion]	/SQLMAXDOP=parameter Applies to: [!INCLUDEsql-server-2019] and later versions Optional. If omitted on unattended (silent) installs, MAXDOP will align with the max degree of parallelism guidelines.	Specifies the max degree of parallelism, which determines how many processors a single statement can utilize during the execution of a single statement. Default value will align with the max degree of parallelism guidelines
[!INCLUDEssDEnoversion]	/USESQLRECOMMENDEDMEMORYLIMITS Applies to: [!INCLUDEsql-server-2019] and later versions Optional. If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the [!INCLUDEssDEnoversion] will use the default [!INCLUDEssNoVersion] memory configuration.	Specifies that the [!INCLUDEssDEnoversion] will use calculated recommended values that align with the server memory configuration guidelines for a standalone [!INCLUDEssNoVersion] instance. Note: This parameter can't be used with /SQLMINMEMORY and /SQLMAXMEMORY.
[!INCLUDEssDEnoversion]	/SQLMINMEMORY Applies to: [!INCLUDEsql-server-2019] and later versions Optional. If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the [!INCLUDEssDEnoversion] will use the default [!INCLUDEssNoVersion] memory configuration.	Specifies the Min Server Memory configuration in MB. Default value: 0. Note: This parameter can't be used with /USESQLRECOMMENDEDMEMORYLIMITS.
[!INCLUDEssDEnoversion]	/SQLMAXMEMORY Applies to: [!INCLUDEsql-server-2019] and later versions Optional. If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the [!INCLUDEssDEnoversion] will use the default [!INCLUDEssNoVersion] memory configuration.	Specifies the Max Server Memory configuration in MB. Default value: calculated recommended value that aligns with the server memory configuration guidelines for a standalone [!INCLUDEssNoVersion] instance. Note: This parameter can't be used with /USESQLRECOMMENDEDMEMORYLIMITS.
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.
[!INCLUDEssNoVersion] Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. ServiceSID is used to help secure the communication between [!INCLUDEssNoVersion] and Full-text Filter Daemon. If the values aren't provided, the Full-text Filter Launcher Service is disabled. You have to use [!INCLUDEssNoVersion] Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
[!INCLUDEssNoVersion] Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCACCOUNT Required	Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE
[!INCLUDEssISnoversion]	/ISSVCPASSWORD Required	Specifies the [!INCLUDEssISnoversion] password. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCStartupType Optional	Specifies the startup mode for the [!INCLUDEssISnoversion] service.
[!INCLUDEssNoVersion] Network Configuration	/NPENABLED Optional	Specifies the state of the Named Pipes protocol for the [!INCLUDEssNoVersion] service. Supported values: - 0 = disable the Named Pipes protocol - 1 = enable the Named Pipes protocol
[!INCLUDEssNoVersion] Network Configuration	/TCPENABLED Optional	Specifies the state of the TCP protocol for the [!INCLUDEssNoVersion] service. Supported values: - 0 = disable the TCP protocol - 1 = enable the TCP protocol
[!INCLUDEssRSnoversion]	/RSINSTALLMODE Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!INCLUDEssRSnoversion]	/RSSVCACCOUNT Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the startup account for the [!INCLUDEssRSnoversion].
[!INCLUDEssRSnoversion]	/RSSVCPASSWORD Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the password for the startup account for the [!INCLUDEssRSnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/RSSVCStartupType Applies to: [!INCLUDEsssql16-md] and earlier versions Optional	Specifies the startup mode for [!INCLUDEssRSnoversion]. Supported values: - Automatic - Disabled - Manual
Python/Machine Learning Services (In-Database)	/MPYCACHEDIRECTORY Optional	Reserved for future use. Use %TEMP% to store Python .CAB files for installation on a computer that doesn't have an internet connection.
R/Machine Learning Services (In-Database)	/MRCACHEDIRECTORY Optional	Use this parameter to specify the Cache directory for Microsoft R Open, [!INCLUDEsssql16-md] R Services, [!INCLUDEsssql16-md] R Server (Standalone), or R feature support in [!INCLUDEssNoVersion] Machine Learning Services or Machine Learning Server (Standalone). This setting is typically used when installing R components from the command line on a computer without Internet access.
Java/Language Extensions	/SQL_INST_JAVA, /SQLJAVADIR = "path" Applies to: [!INCLUDEsssql19-md] only Optional	Specifies installing Java with Language Extensions. If /SQL_INST_JAVA is provided without the /SQLJAVADIR parameter, it's assumed you want to install the Zulu Open JRE that is provided by the installation media. Providing a path for /SQLJAVADIR indicates you would like to use an already-installed JRE or JDK.
Azure Arc agent extension	/FEATURES=AZUREEXTENSION Applies to: [!INCLUDEsssql22-md] and later versions Optional	Connect the instance to Azure Arc.
Azure Arc agent extension	/AZURESUBSCRIPTIONID Applies to: [!INCLUDEsssql22-md] and later versions Optional	Azure subscription the [!INCLUDEssNoVersion] instance resource will be created.
Azure Arc agent extension	/AZURERESOURCEGROUP Applies to: [!INCLUDEsssql22-md] and later versions Optional	Azure resource group where the [!INCLUDEssNoVersion] instance resource will be created.
Azure Arc agent extension	/AZUREREGION Applies to: [!INCLUDEsssql22-md] and later versions Optional	Azure region where the [!INCLUDEssNoVersion] instance resource will be created.
Azure Arc agent extension	/AZURETENANTID Applies to: [!INCLUDEsssql22-md] and later versions Optional	Azure tenant ID in which the service principal exists.
Azure Arc agent extension	/AZURESERVICEPRINCIPAL Applies to: [!INCLUDEsssql22-md] and later versions Optional	Service principal to authenticate against given tenant ID, subscription and resource group.
Azure Arc agent extension	/AZURESERVICEPRINCIPALSECRET Applies to: [!INCLUDEsssql22-md] and later versions Optional	Service principal secret.
Azure Arc agent extension	/AZUREARCPROXY Applies to: [!INCLUDEsssql22-md] and later versions Optional	Name of the proxy server used to connect to Azure Arc.

Sample syntax

To install a new, stand-alone instance with the [!INCLUDEssDEnoversion], Replication, and Full-Text Search components and enable instant file initialization for [!INCLUDEssDEnoversion].

setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCINSTANTFILEINIT="True" /IACCEPTSQLSERVERLICENSETERMS

Deploy - connected to Azure Arc

Beginning with [!INCLUDEsssql22-md] you can install the Azure Arc agent with the [!INCLUDEssNoVersion] extension when you are install [!INCLUDEssNoVersion]. When you install the Azure Arc agent with [!INCLUDEssNoVersion] extension, you can automatically enable the instance for Azure Arc, which will register the [!INCLUDEssNoVersion] instance as a resource in Azure and make it eligible to attach additional Azure management services to it.

The following example deploys a [!INCLUDEssNoVersion] instance that is connected to Azure Arc. Before you run the example, replace the information in angle brackets ( < ... > ) with your information.

setup.exe /qs /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Install /FEATURES=SQLEngine,AZUREEXTENSION /INSTANCENAME=<instance name> /SQLSYSADMINACCOUNTS="<sysadmin account>" /IACCEPTSQLSERVERLICENSETERMS /AZURESUBSCRIPTIONID="<Azure subscription>" /AZURETENANTID="<Azure tenant ID>" /AZURERESOURCEGROUP="<resource group name>" /AZURESERVICEPRINCIPAL="<service principal>" /AZURESERVICEPRINCIPALSECRET="<secret>" /AZUREREGION=<Azure region>

The following example installs the Azure Arc agent and [!INCLUDEssNoVersion] extension to manage an existing [!INCLUDEssNoVersion] instance and any other [!INCLUDEssNoVersion] instances that are installed.

setup.exe /qs /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Install /FEATURES=AZUREEXTENSION /IACCEPTSQLSERVERLICENSETERMS /AZURESUBSCRIPTIONID="<Azure subscription>" /AZURETENANTID="<Azure tenant ID>" /AZURERESOURCEGROUP="<resource group name>" /AZURESERVICEPRINCIPAL="<service principal>" /AZURESERVICEPRINCIPALSECRET="<secret>" /AZUREREGION=<Azure region>

The following example shows how to remove the [!INCLUDEssNoVersion] extension for Azure Arc agent from setup.

Note

This command will not physically uninstall the [!INCLUDEssNoVersion] extension. Instead, the command will mark this feature as not selected in the setup. To remove the Azure resource for this instance, go to Azure portal and delete.

setup.exe /qs /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Uninstall /FEATURES=AZUREEXTENSION  /IACCEPTSQLSERVERLICENSETERMS

For more information about connecting to Azure Arc, see:

• Azure Arc-enabled SQL Server
• Connect your SQL Server to Azure Arc

SysPrep parameters

For more information about [!INCLUDEssNoVersion] SysPrep, see

[Install [!INCLUDEsssql16-md] Using SysPrep](../../database-engine/install-windows/install-sql-server-using-sysprep.md).

Prepare image parameters

Use the parameters in the following table to develop command-line scripts for preparing an instance of [!INCLUDEssNoVersion] without configuring it.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: PrepareImage
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/FEATURES Required	Specifies components to install. Supported values are SQLEngine, Replication, FullText, DQ, AS, AS_SPI, RS, RS_SHP, RS_SHPWFE, DQC, Conn, IS, BC, SDK, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, SQLODBC, SQLODBC_SDK, LocalDB, MDS, POLYBASE 1
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL Server Cannot be set to %Program Files(x86)%\Microsoft SQL Server
[!INCLUDEssde-md] Setup Control	/INSTANCEDIR Optional	Specifies a nondefault installation directory for instance-specific components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Prior to [!INCLUDEssSQL11] SP1 CU2 (January 2013) Required Beginning with [!INCLUDEssSQL11] SP1 CU2 Required for instance features.	Specifies an InstanceID for the instance that is being prepared.
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.

¹ Distributed Replay, SDK, and SNAC aren't available in [!INCLUDEsssql22-md].

Sample syntax

To prepare a new, stand-alone instance with the [!INCLUDEssDEnoversion], Replication, and Full-Text Search components, and [!INCLUDEssRSnoversion].

setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/PrepareImage /FEATURES=SQL,RS /InstanceID =<MYINST> /IACCEPTSQLSERVERLICENSETERMS

Complete image parameters

Use the parameters in the following table to develop command-line scripts for completing and configuring a prepared instance of [!INCLUDEssNoVersion].

[!INCLUDEssNoVersion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: CompleteImage
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Prior to [!INCLUDEssSQL11] SP1 CU2 (January 2013) Required Beginning with [!INCLUDEssSQL11] SP1 CU2 Optional	Use the Instance ID specified during the prepare image step. Supported values: InstanceID of a prepared instance.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Prior to [!INCLUDEssSQL11] SP1 CU2 (January 2013) Required Beginning with [!INCLUDEssSQL11] SP1 CU2 Optional	Specifies a [!INCLUDEssNoVersion] instance name for the instance that is being completed. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PRODUCTCOVERDBYSA Applies to: [!INCLUDE sssql22-md] and later versions Required, when installing the Azure Extension feature from the command line with AZUREEXTENSION.	Specifies the license coverage for [!INCLUDE ssnoversion-md]. /PRODUCTCOVERDBYSA=True, or just /PRODUCTCOVERDBYSA, indicates it is covered under Software Assurance or [!INCLUDE ssnoversion-md] subscription. /PRODUCTCOVERDBYSA=False, or omitting the parameter, indicates it is covered under a SQL Server license.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT Required	Specifies the account for the [!INCLUDEssNoVersion] Agent service.
[!INCLUDEssNoVersion] Agent	/AGTSVCPASSWORD Required	Specifies the password for [!INCLUDEssNoVersion] Agent service account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssNoVersion] Agent	/AGTSVCSTARTUPTYPE Optional	Specifies the startup mode for the [!INCLUDEssNoVersion] Agent service. Supported values: - Automatic - Disabled - Manual
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssNoVersion] Browser	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for [!INCLUDEssNoVersion] Browser service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssDEnoversion]	/ENABLERANU Optional	Enables run-as credentials for [!INCLUDEssExpress] installations.
[!INCLUDEssDEnoversion]	/INSTALLSQLDATADIR Optional	Specifies the data directory for [!INCLUDEssNoVersion] data files. Default values: For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\ For all other installations: %Program Files%\Microsoft SQL Server\
[!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 isn't 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssDEnoversion]	/SQLSVCSTARTUPTYPE Optional	Specifies the startup mode for the [!INCLUDEssNoVersion] service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssDEnoversion]	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role. For [!INCLUDEssNoVersion] editions other than [!INCLUDEssExpress], /SQLSYSADMINACCOUNTS is required. For editions of [!INCLUDEssExpress], use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
[!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]	/SQLTEMPDBFILESIZE Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the initial size of each tempdb data file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions Min = 4 MB or 8 MB Max = 1024 MB
[!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 Applies to: [!INCLUDEsssql16-md] and later versions 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 Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the file growth increment of the tempdb log 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]	/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 [!INCLUDEssNoVersion] deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_\*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] isn't supported for configuring this parameter. Setup installs only 1 tempdb data file.
[!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
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.
[!INCLUDEssNoVersion] Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. ServiceSID is used to help secure the communication between [!INCLUDEssNoVersion] and Full-text Filter Daemon. If the values aren't provided, the Full-text Filter Launcher Service is disabled. You have to use [!INCLUDEssNoVersion] Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
[!INCLUDEssNoVersion] Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssNoVersion] Network Configuration	/NPENABLED Optional	Specifies the state of the Named Pipes protocol for the [!INCLUDEssNoVersion] service. Supported values: - 0 = disable the Named Pipes protocol - 1 = enable the Named Pipes protocol
[!INCLUDEssNoVersion] Network Configuration	/TCPENABLED Optional	Specifies the state of the TCP protocol for the [!INCLUDEssNoVersion] service. Supported values: - 0 = disable the TCP protocol - 1 = enable the TCP protocol
[!INCLUDEssRSnoversion]	/RSINSTALLMODE Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!INCLUDEssRSnoversion]	/RSSVCACCOUNT Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the startup account for the [!INCLUDEssRSnoversion].
[!INCLUDEssRSnoversion]	/RSSVCPASSWORD Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the password for the startup account for the [!INCLUDEssRSnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/RSSVCStartupType Applies to: [!INCLUDEsssql16-md] and earlier versions Optional	Specifies the startup mode for [!INCLUDEssRSnoversion]. Supported values: - Automatic - Disabled - Manual

Sample syntax

To complete a prepared, stand-alone instance that includes [!INCLUDEssDEnoversion], Replication, and Full-Text Search components.

setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/CompleteImage /INSTANCENAME=MYNEWINST /INSTANCEID=<MYINST> /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /IACCEPTSQLSERVERLICENSETERMS

Upgrade parameters

Use the parameters in the following table to develop command-line scripts for upgrade.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported values: - Upgrade - EditionUpgrade The value EditionUpgrade is used to upgrade an existing edition of [!INCLUDEssnoversion] to a different edition. For more information about the supported version and edition upgrades, see Supported Version and Edition Upgrades.
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/ INSTANCEDIR Optional	Specifies a nondefault installation directory for shared components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Required, when you upgrade from [!INCLUDEsql2008-md] or later versions. Optional, when you upgrade from [!INCLUDEssVersion2005].	Specifies a nondefault value for an InstanceID.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/UIMODE Optional	Specifies whether to present only the minimum number of dialog boxes during setup. /UIMODE can only be used with the /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/INSTALL%3C/code> and UPGRADE parameters. Supported values: - /UIMODE=Normal is the default for non-Express editions and presents all setup dialog boxes for the selected features. - /UIMODE=AutoAdvance is the default for Express editions and skips nonessential dialog boxes. When combined with other parameters, UIMODE is overridden. For example, when /UIMODE=AutoAdvance and /ADDCURRENTUSERASSQLADMIN=FALSE are both provided, the provisioning dialog box isn't auto populated with the current user. The UIMODE setting can't be used with the /Q or /QS parameters.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssNoVersion] Browser	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for [!INCLUDEssNoVersion] Browser service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssNoVersion] 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!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 isn't 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/ALLOWUPGRADEFORSSRSSHAREPOINTMODE	The switch is required when upgrading a SharePoint Mode installation that is based on the SharePoint shared service architecture. The switch isn't needed for upgrading non-shared service versions of [!INCLUDEssRSnoversion].

Sample syntax

To upgrade an existing instance or failover cluster node from a previous [!INCLUDEssDEnoversion] version,

setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/upgrade /INSTANCEID = <INSTANCEID>/INSTANCENAME=MSSQLSERVER /RSUPGRADEDATABASEACCOUNT="<Provide a SQL Server logon account that can connect to the report server during upgrade>" /RSUPGRADEPASSWORD="<Provide a password for the report server upgrade account>" /ISSVCAccount="NT AUTHORITY\NETWORK SERVICE" /IACCEPTSQLSERVERLICENSETERMS

Repair parameters

Use the parameters in the following table to develop command-line scripts for repair.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the repair workflow. Supported values: Repair
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/FEATURES Required	Specifies components to repair.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.

Sample syntax

Repair an instance and shared components.

setup.exe /q /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Repair /INSTANCENAME=<instancename>

Rebuild system database parameters

Use the parameters in the following table to develop command-line scripts for rebuilding the master, model, msdb, and tempdb system databases. For more information, see Rebuild System Databases.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the rebuild database workflow. Supported values: RebuildDatabase
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] 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]	/SQLCOLLATION Optional	Specifies a new server-level collation. The default value is based on the locale of your Windows operating system. For more information, see Collation Settings in Setup.
[!INCLUDEssDEnoversion]	/SAPWD Required, when /SECURITYMODE=SQL was specified during installation of the instance.	Specifies the password for [!INCLUDEssNoVersion] SA account.
[!INCLUDEssDEnoversion]	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role. For [!INCLUDEssNoVersion] editions other than [!INCLUDEssExpress], /SQLSYSADMINACCOUNTS is required. For editions of [!INCLUDEssExpress], use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
[!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 [!INCLUDEssNoVersion] deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_\*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] isn't supported for configuring this parameter. Setup installs only 1 tempdb data file.
[!INCLUDEssDEnoversion]	/SQLTEMPDBFILESIZE Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the initial size of each tempdb data file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions Min = 4 MB or 8 MB Max = 1024 MB
[!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 Applies to: [!INCLUDEsssql16-md] and later versions 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 Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the file growth increment of the tempdb log 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

Uninstall parameters

Use the parameters in the following table to develop command-line scripts for uninstallation.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the uninstall work flow. Supported values: Uninstall
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/FEATURES Required	Specifies components to uninstall.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.

Sample syntax

To uninstall an existing instance of [!INCLUDEssNoVersion].

setup.exe /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME=MSSQLSERVER

To remove a named instance, specify the name of the instance instead of "MSSQLSERVER" in the example that was mentioned earlier in this article.

Failover cluster parameters

Before you install a [!INCLUDEssDEnoversion] failover cluster instance, review the following articles:

• [Hardware and Software Requirements for Installing [!INCLUDEsssql16-md]](../../sql-server/install/hardware-and-software-requirements-for-installing-sql-server.md)

• Security Considerations for a SQL Server Installation

• Before Installing Failover Clustering

• 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.

Integrated install failover cluster parameters

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
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the failover cluster installation work flow. Supported value: InstallFailoverCluster
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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 Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/FEATURES Required	Specifies components to install.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL Server Cannot be set to %Program Files(x86)%\Microsoft SQL Server
[!INCLUDEssde-md] 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 Server Cannot be set to %Program Files%\Microsoft SQL Server
[!INCLUDEssde-md] Setup Control	/INSTANCEDIR Optional	Specifies a nondefault installation directory for instance-specific components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PRODUCTCOVERDBYSA Applies to: [!INCLUDE sssql22-md] and later versions Required, when installing the Azure Extension feature from the command line with AZUREEXTENSION.	Specifies the license coverage for [!INCLUDE ssnoversion-md]. /PRODUCTCOVERDBYSA=True, or just /PRODUCTCOVERDBYSA, indicates it is covered under Software Assurance or [!INCLUDE ssnoversion-md] subscription. /PRODUCTCOVERDBYSA=False, or omitting the parameter, indicates it is covered under a SQL Server license.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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=DEFAULT FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;2041:0:1a0f::8a5b:131c
[!INCLUDEssde-md] 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.
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT Required	Specifies the account for the [!INCLUDEssNoVersion] Agent service.
[!INCLUDEssNoVersion] Agent	/AGTSVCPASSWORD Required	Specifies the password for [!INCLUDEssNoVersion] Agent service account. This parameter can be omitted when using a managed service account, virtual account, or built-in 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\Backup For 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 Note: Only Windows collation is supported. Using SQL collation may result in unexpected behavior.
[!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\Config For 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\Data For 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\Log For 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\Temp For 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 uppercase. For more information about valid values, see Install Analysis Services in Tabular Mode.
[!INCLUDEssDEnoversion]	/INSTALLSQLDATADIR Required	Specifies the data directory for [!INCLUDEssNoVersion] data files. The data directory must be 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 isn't 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssDEnoversion]	/SQLSYSADMINACCOUNTS Required	Use this parameter to provision logins to be members of the sysadmin role. For [!INCLUDEssNoVersion] editions other than [!INCLUDEssExpress], /SQLSYSADMINACCOUNTS is required. For editions of [!INCLUDEssExpress], use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
[!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 [!INCLUDEssNoVersion] deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_\*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] isn't supported for configuring this parameter. Setup installs only 1 tempdb data file.
[!INCLUDEssDEnoversion]	/SQLTEMPDBFILESIZE Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the initial size of each tempdb data file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions Min = 4 MB or 8 MB Max = 1024 MB
[!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 Applies to: [!INCLUDEsssql16-md] and later versions 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 Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the file growth increment of the tempdb log 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]	/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.
[!INCLUDEssNoVersion] Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. ServiceSID is used to help secure the communication between [!INCLUDEssNoVersion] and Full-text Filter Daemon. If the values aren't provided, the Full-text Filter Launcher Service is disabled. You have to use [!INCLUDEssNoVersion] Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
[!INCLUDEssNoVersion] Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCACCOUNT Required	Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE
[!INCLUDEssISnoversion]	/ISSVCPASSWORD Required	Specifies the [!INCLUDEssISnoversion] password. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCStartupType Optional	Specifies the startup mode for the [!INCLUDEssISnoversion] service.
[!INCLUDEssRSnoversion]	/RSINSTALLMODE Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!INCLUDEssRSnoversion]	/RSSVCACCOUNT Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the startup account for the [!INCLUDEssRSnoversion].
[!INCLUDEssRSnoversion]	/RSSVCPASSWORD Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the password for the startup account for the [!INCLUDEssRSnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/RSSVCStartupType Applies to: [!INCLUDEsssql16-md] and earlier versions Optional	Specifies the startup mode for [!INCLUDEssRSnoversion]. Supported values: - Automatic - Disabled - Manual

We recommend that you use Service SID instead of domain groups.

Additional notes

The [!INCLUDEssDE] and [!INCLUDEssASnoversion] are the only components that are cluster-aware. Other features aren't cluster-aware and do not have high availability through failover.

Sample syntax

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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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

Prepare failover cluster parameters

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
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the failover cluster prepare work flow. Supported value: PrepareFailoverCluster
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/FEATURES Required	Specifies components to install.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTALLSHAREDDIR Optional	Specifies a nondefault installation directory for 64-bit shared components. Default is %Program Files%\Microsoft SQL Server Cannot be set to %Program Files(x86)%\Microsoft SQL Server
[!INCLUDEssde-md] 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 Server Cannot be set to %Program Files%\Microsoft SQL Server
[!INCLUDEssde-md] Setup Control	/INSTANCEDIR Optional	Specifies a nondefault installation directory for instance-specific components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Optional	Specifies a nondefault value for an InstanceID.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT Required	Specifies the account for the [!INCLUDEssNoVersion] Agent service.
[!INCLUDEssNoVersion] Agent	/AGTSVCPASSWORD Required	Specifies the password for [!INCLUDEssNoVersion] Agent service account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssASnoversion]	/ASSVCACCOUNT Required	Specifies the account for the [!INCLUDEssASnoversion] service.
[!INCLUDEssASnoversion]	/ASSVCPASSWORD Required	Specifies the password for the [!INCLUDEssASnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssDEnoversion]	/SQLSVCACCOUNT Required	Specifies the startup account for the [!INCLUDEssNoVersion] service.
[!INCLUDEssDEnoversion]	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
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.
[!INCLUDEssNoVersion] Full Text	/FTSVCACCOUNT Optional	Specifies the account for Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. ServiceSID is used to help secure the communication between [!INCLUDEssNoVersion] and Full-text Filter Daemon. If the values aren't provided, the Full-text Filter Launcher Service is disabled. You have to use [!INCLUDEssNoVersion] Control Manager to change the service account and enable full-text functionality. Default value: Local Service Account
[!INCLUDEssNoVersion] Full Text	/FTSVCPASSWORD Optional	Specifies the password for the Full-Text filter launcher service. This parameter is ignored in [!INCLUDEwinserver2008] or higher. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCACCOUNT Required	Specifies the account for [!INCLUDEssISnoversion]. Default value: NT AUTHORITY\NETWORK SERVICE
[!INCLUDEssISnoversion]	/ISSVCPASSWORD Required	Specifies the [!INCLUDEssISnoversion] password. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCStartupType Optional	Specifies the startup mode for the [!INCLUDEssISnoversion] service.
[!INCLUDEssRSnoversion]	/RSINSTALLMODE Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!INCLUDEssRSnoversion]	/RSSVCACCOUNT Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the startup account for the [!INCLUDEssRSnoversion].
[!INCLUDEssRSnoversion]	/RSSVCPASSWORD Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the password for the startup account for the [!INCLUDEssRSnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/RSSVCStartupType Applies to: [!INCLUDEsssql16-md] and earlier versions Optional	Specifies the startup mode for [!INCLUDEssRSnoversion]. Supported values: - Automatic - Disabled - Manual

We recommend that you use Service SID instead of domain groups.

Sample syntax

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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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

[!INCLUDEsql-eula-link]

Complete failover cluster parameters

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
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the failover cluster complete work flow. Supported value: CompleteFailoverCluster
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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>)
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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=DEFAULT FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;2041:0:1a0f::8a5b:131c
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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
[!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\Backup For 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 Note: Only Windows collation is supported. Using SQL collation may result in unexpected behavior.
[!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\Config For 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\Data For 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\Log For all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log
[!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 uppercase. For more information about 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\Temp For 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 be 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 isn't 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. For [!INCLUDEssNoVersion] editions other than [!INCLUDEssExpress], /SQLSYSADMINACCOUNTS is required. For editions of [!INCLUDEssExpress], use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
[!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 Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!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 [!INCLUDEssNoVersion] deletes the files with naming convention tempdb_mssql_#.ndf. Do not use tempdb_mssql_\*.ndf naming convention for user database files. Warning: [!INCLUDEssExpress] isn't supported for configuring this parameter. Setup installs only 1 tempdb data file.
[!INCLUDEssDEnoversion]	/SQLTEMPDBFILESIZE Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the initial size of each tempdb data file. Default = 4 MB for [!INCLUDEssExpress], 8 MB for all other editions Min = 4 MB or 8 MB Max = 1024 MB
[!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 Applies to: [!INCLUDEsssql16-md] and later versions 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 Applies to: [!INCLUDEsssql16-md] and later versions Optional	Specifies the file growth increment of the tempdb log 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

Sample syntax

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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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>"

Upgrade failover cluster parameters

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
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate the installation workflow. Supported value: Upgrade
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/ERRORREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/ INSTANCEDIR Optional	Specifies a nondefault installation directory for shared components.
[!INCLUDEssde-md] Setup Control	/INSTANCEID Required, when you upgrade from [!INCLUDEsql2008-md] or later versions. Optional, when you upgrade from [!INCLUDEssVersion2005].	Specifies a nondefault value for an InstanceID.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/SQMREPORTING Applies to: [!INCLUDEsssql14-md] and earlier versions Optional	To manage how error feedback is sent to Microsoft, see [How to configure [!INCLUDEsssql16-md] 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
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] Setup Control	/FAILOVERCLUSTERROLLOWNERSHIP Required	Specifies the failover behavior during upgrade.
[!INCLUDEssNoVersion] Browser	/BROWSERSVCSTARTUPTYPE Optional	Specifies the startup mode for [!INCLUDEssNoVersion] Browser service. Supported values: - Automatic - Disabled - Manual
[!INCLUDEssNoVersion] 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!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 isn't 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. This parameter can be omitted when using a managed service account, virtual account, or built-in account.

Add node parameters

Use the parameters in the following table to develop command-line scripts for AddNode.

[!INCLUDEssDEnoversion] component	Parameter	Description
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate AddNode work flow. Supported value: AddNode
[!INCLUDEssde-md] Setup Control	/IACCEPTSQLSERVERLICENSETERMS Required, when the /Q or /QS parameter is specified for unattended installations	Required to acknowledge acceptance of the license terms. Beginning with [!INCLUDEsssql22-md], read the Microsoft [!INCLUDEssNoVersion] Software License Terms at aka.ms/useterms.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] 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, [!INCLUDEssNoVersion] Setup will include updates that are found.
[!INCLUDEssde-md] Setup Control	/UpdateSource Optional	Specify the location where [!INCLUDEssNoVersion] 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.
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] Setup Control	/PID Optional	Specifies the product key for the edition of [!INCLUDEssNoVersion]. If this parameter isn't specified, Evaluation is used. Note: If you are installing [!INCLUDEssExpress], [!INCLUDEssExpress] with Advanced Services, [!INCLUDEssExpress] with tools, [!INCLUDEssdeveloper], or [!INCLUDEssevaluation], the PID is predefined.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] 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=DEFAULT FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1 FAILOVERCLUSTERIPADDRESSES=IPv6;2041:0:1a0f::8a5b:131c 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).
[!INCLUDEssde-md] 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
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT Required	Specifies the account for the [!INCLUDEssNoVersion] Agent service.
[!INCLUDEssNoVersion] Agent	/AGTSVCPASSWORD Required	Specifies the password for [!INCLUDEssNoVersion] Agent service account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCACCOUNT Optional	Specifies the account for the engine service. Default value: NT AUTHORITY\NETWORK SERVICE.
PolyBase Data Movement	/PBDMSSVCPASSWORD Optional	Specifies the password for the data movement account. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBase Engine	/PBENGSVCSTARTUPTYPE Optional	Specifies the startup mode for the PolyBase Engine service. Supported values: - Automatic (default) - Disabled - 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. Use this option if you are configuring a PolyBase Scale-out computational group including the head node. Supported values: True, False
[!INCLUDEssASnoversion]	/ASSVCACCOUNT Required	Specifies the account for the [!INCLUDEssASnoversion] service.
[!INCLUDEssASnoversion]	/ASSVCPASSWORD Required	Specifies the password for the [!INCLUDEssASnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssDEnoversion]	/SQLSVCACCOUNT Required	Specifies the startup account for the [!INCLUDEssNoVersion] service.
[!INCLUDEssDEnoversion]	/SQLSVCPASSWORD Required	Specifies the password for SQLSVCACCOUNT. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssISnoversion]	/ISSVCPASSWORD Required	Specifies the [!INCLUDEssISnoversion] password. This parameter can be omitted when using a managed service account, virtual account, or built-in account.
[!INCLUDEssRSnoversion]	/RSINSTALLMODE Applies to: [!INCLUDEsssql16-md] and earlier versions Optional Available only on FilesOnlyMode	Specifies the Install mode for [!INCLUDEssRSnoversion]. Supported values: - SharePointFilesOnlyMode - DefaultNativeMode - FilesOnlyMode Note: If the installation includes the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is DefaultNativeMode. If the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the default RSINSTALLMODE is FilesOnlyMode. If you choose DefaultNativeMode but the installation doesn't include the [!INCLUDEssNoVersion] [!INCLUDEssDE], the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
[!INCLUDEssRSnoversion]	/RSSVCPASSWORD Applies to: [!INCLUDEsssql16-md] and earlier versions Required	Specifies the password for the startup account for the [!INCLUDEssRSnoversion] service. This parameter can be omitted when using a managed service account, virtual account, or built-in account.

Additional notes

The [!INCLUDEssDE] and [!INCLUDEssASnoversion] are the only components that are cluster-aware. Other features aren't cluster-aware and do not have high availability through failover.

Sample syntax

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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/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

Remove node parameters

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
[!INCLUDEssde-md] Setup Control	/ACTION Required	Required to indicate RemoveNode work flow. Supported value: RemoveNode
[!INCLUDEssde-md] Setup Control	/CONFIGURATIONFILE Optional	Specifies the ConfigurationFile to use.
[!INCLUDEssde-md] Setup Control	/HELP or ? Optional	Displays usage options for the parameters.
[!INCLUDEssde-md] Setup Control	/INDICATEPROGRESS Optional	Specifies that the verbose Setup log file is piped to the console.
[!INCLUDEssde-md] Setup Control	/INSTANCENAME Required	Specifies a [!INCLUDEssDEnoversion] instance name. For more information, see Instance Configuration.
[!INCLUDEssde-md] 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.
[!INCLUDEssde-md] Setup Control	/QS or /QUIETSIMPLE Optional	Specifies that Setup runs and shows progress through the UI, but doesn't accept any input or show any error messages.
[!INCLUDEssde-md] Setup Control	/HIDECONSOLE Optional	Specifies that the console window is hidden or closed.
[!INCLUDEssde-md] 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

Sample syntax

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/b116d4fc0cc812b10ee6c5d6d7f581c93db7c38d/docs/database-engine/install-windows/RemoveNode /INSTANCENAME="<Insert Instance Name>" [/INDICATEPROGRESS] /CONFIRMIPDEPENDENCYCHANGE=0

Service account parameters

You can configure the [!INCLUDEssNoVersion] 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
[!INCLUDEssNoVersion] Agent	/AGTSVCACCOUNT	/AGTSVCPASSWORD	/AGTSVCSTARTUPTYPE
[!INCLUDEssASnoversion]	/ASSVCACCOUNT	/ASSVCPASSWORD	/ASSVCSTARTUPTYPE
[!INCLUDEssDEnoversion]	/SQLSVCACCOUNT	/SQLSVCPASSWORD	/SQLSVCSTARTUPTYPE
[!INCLUDEssISnoversion]	/ISSVCACCOUNT	/ISSVCPASSWORD	/ISSVCSTARTUPTYPE
[!INCLUDEssRSnoversion]	/RSSVCACCOUNT	/RSSVCPASSWORD	/RSSVCSTARTUPTYPE

Note

[!INCLUDEssRSnoversion] features were removed from [!INCLUDEsssql17-md]. The account parameters for [!INCLUDEssNoVersion] [!INCLUDEssRSnoversion] are only applicable to versions prior to [!INCLUDEsssql17-md].

Feature parameters

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 [!INCLUDEssNoVersion], see:

• Editions and supported features of SQL Server 2022
• Editions and supported features of SQL Server 2019
• Editions and Supported Features of SQL Server 2017
• Editions and Supported Features of SQL Server 2016

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 [!INCLUDEssNoVersion] 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.
	PolyBaseCore	Pair with PolyBase to install PolyBase technology that enables truly integrated querying across Oracle, Teradata, [!INCLUDEssNoVersion] and other relational and non-relational data using standard T-SQL statements. Applies to: [!INCLUDEsql-server-2019] and later versions
	PolyBaseJava	In [!INCLUDEsssql19-md] only, pair with PolyBase to install PolyBase Java Connector that enables truly integrated querying across HDFS data using standard T-SQL statements.
	AdvancedAnalytics	Installs SQL Server Machine Learning Services or SQL Server 2016 R Services (In-Database).
	SQL_INST_MR	Pair with AdvancedAnalytics to install R Open and proprietary R packages. Applies to: SQL Server Machine Learning Services (2017 and 2019) and SQL Server 2016 R Services (In-Database)
	SQL_INST_MPY	Pair with AdvancedAnalytics to install Anaconda and proprietary Python packages. Applies to: SQL Server Machine Learning Services (2017 and 2019)
	SQL_INST_JAVA	Pair with AdvancedAnalytics to install extensions that enable integration with Java using standard T-SQL statements. Applies to: SQL Server Java Language Extension (2019 only)
AS		Installs all [!INCLUDEssASnoversion] components.
RS		Installs all [!INCLUDEssRSnoversion] components. Applies to: [!INCLUDEsssql16-md] and earlier versions
RS_SHP		Installs [!INCLUDEssRSnoversion] components for SharePoint. Applies to: [!INCLUDEsssql16-md] and earlier versions
RS_SHPWFE		Installs [!INCLUDEssRSnoversion] Add-In for SharePoint products. Applies to: [!INCLUDEsssql16-md] and earlier versions
DQC		Installs [!INCLUDEssDQSClient].
IS		Installs all [!INCLUDEssISnoversion] components.
	IS_Master	Includes Scale Out Master for Integration Services Scale Out.
	IS_Worker	Includes Scale Out Worker for Integration Services Scale Out.
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 Machine Learning Server (Standalone)
Tools 1		Installs client tools and [!INCLUDEssNoVersion] Books Online components. Applies to: [!INCLUDEsssql19-md] and earlier versions
	BC	Installs backward compatibility components. Applies to: [!INCLUDEsssql19-md] and earlier versions
	Conn	Installs connectivity components. Applies to: [!INCLUDEsssql19-md] and earlier versions
	DREPLAY_CTLR	Installs Distributed Replay controller. Applies to: [!INCLUDEsssql19-md] and earlier versions
	DREPLAY_CLT	Installs Distributed Replay client. Applies to: [!INCLUDEsssql19-md] and earlier versions
	SNAC_SDK	Installs SDK for [!INCLUDEssNoVersion] Native Client. Applies to: [!INCLUDEsssql19-md] and earlier versions
	SDK	Installs the software development kit. Applies to: [!INCLUDEsssql19-md] and earlier versions
	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 [!INCLUDEssnoversion] installer. For details, see Install SQL Server Management Studio.

Feature parameter examples

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	Installs the [!INCLUDEssDE], replication, and full-text.
/FEATURES=SQLEngine,PolyBase	Installs the [!INCLUDEssDE] and the PolyBase engine.

Role parameters

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 unconfigured 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 can't 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 [!INCLUDEssNoVersion] edition that isn't [!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] [!INCLUDEssNoVersion] Books Online
SPI_AS_NewFarm	Installs [!INCLUDEssASnoversion] and [!INCLUDEssDE] as a [!INCLUDEssGemini] named instance on a new, unconfigured Office [!INCLUDESPS2010] farm or standalone server. [!INCLUDEssNoVersion] Setup will configure the farm during feature role installation.	[!INCLUDEssASnoversion] calculation engine, preconfigured for in-memory data storage and processing. [!INCLUDEssGemini] solution packages [!INCLUDEssNoVersion] Books Online [!INCLUDEssDE] Configuration Tools [!INCLUDEssManStudioFull]
AllFeatures_WithDefaults	Installs all features that are available with the current edition. Adds the current user to the [!INCLUDEssNoVersion] sysadmin fixed server role. On [!INCLUDEwinserver2008] or higher and when the operating system isn't a domain controller, the [!INCLUDEssDE], and [!INCLUDEssRSnoversion] are defaulted to use the NT AUTHORITY\NETWORK SERVICE account, and [!INCLUDEssISnoversion] is defaulted to use the NT AUTHORITY\NETWORK SERVICE account. This role is enabled by default in editions of [!INCLUDEssExpress]. For all other editions, this role isn't 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 that 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 isn't auto populated with the current user. Add /AGTSVCACCOUNT and /AGTSVCPASSWORD to specify a service account and password for the [!INCLUDEssNoVersion] Agent.

Control failover behavior using the /FAILOVERCLUSTERROLLOWNERSHIP parameter

To upgrade a [!INCLUDEssDEnoversion] failover cluster, 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 line 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 doesn't add this node to the list of possible owners of the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] cluster at the end of upgrade.

• /FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. It will be used if this parameter isn't specified. This setting indicates that [!INCLUDEssNoVersion] Setup will manage cluster ownership (move group) as needed.

Instance ID or InstanceID configuration

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 substitutes <INSTANCEID> with the <INSTANCENAME>.

See also

• Install SQL Server 2016 from the Installation Wizard
• SQL Server Failover Cluster Installation
• Install SQL Server 2016 Business Intelligence Features