从命令提示符安装 SQL ServerInstall SQL Server from the Command Prompt

适用于:Applies to:是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) -仅限 Windows适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only

在运行 SQL 安装程序之前,请查阅 计划 SQL Server 安装Before you run SQL Server Setup, review Planning a SQL Server Installation.

通过从命令提示符安装 SQL Server 的新实例,可以指定要安装的功能以及如何配置这些功能。Installing a new instance of SQL Server at the command prompt enables you to specify the features to install and how they should be configured. 还可以指定与安装用户界面是进行静默交互、基本交互还是完全交互。You can also specify silent, basic, or full interaction with the Setup user interface.

若要通过命令提示符进行安装,请打开管理命令提示符,然后导航到 setup.exe 在 SQL Server 安装介质中所处的位置。To install from the command prompt, open an administrative command prompt and navigate to where setup.exe is located within the SQL Server setup media. 运行 setup.exe 命令,以及完成尝试执行的操作所必需的和可选的参数:Run the setup.exe command, along with the required and optional parameters that accomplish what you're trying to do:

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

以下示例以安静模式安装 SQL Server 数据库引擎、SQL Server Analysis Services、SQL Server Integration Services 和 SQL Server工具:The following example installs the SQL Server database engine, SQL Server Analysis Services, SQL Server Integration Services, and SQL Server tools in quiet mode:

C:\SQLMedia\SQLServer2019> setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION="install" /PID="AAAAA-BBBBB-CCCCC-DDDDD-EEEEE" /FEATURES=SQL,AS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"
/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "
/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"
/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"
/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"
/ASSYSADMINACCOUNTS="MyDomain\MyAccount"

若要查看控制台内所有可能命令的列表,请使用 /help 标志运行可执行文件:To view a list of all possible commands within the console, run the executable with the /help flag:

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

本文其余部分提供可用参数的详细说明。The rest of the article provides a detailed description of the available parameters.

备注

通过命令提示符安装时,SQL ServerSQL Server 支持完全静默模式(通过使用 /Q 参数)或简单静默模式(通过使用 /QS 参数)。When installing through the command prompt, SQL ServerSQL Server supports full quiet mode by using the /Q parameter, or Quiet Simple mode by using the /QS parameter. /QS 开关仅显示进度,不接受任何输入,也不显示错误消息(如果遇到)。The /QS switch only shows progress, does not accept any input, and displays no error messages if encountered. 仅当指定 /Action=install 时才支持 /QS 参数。The /QS parameter is only supported when /Action=install is specified.

无论使用哪种安装方法,你都需要作为个人或代表实体确认接受软件许可条款,除非你对于软件的使用受单独的协议(如 Microsoft 批量许可协议或与 ISV 或 OEM 之间的第三方协议)管辖。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. 使用 /Q 或 /QS 参数进行无人参与安装时,必须包含 /IACCEPTSQLSERVERLICENSETERMS 参数。Unattended installations (using the /Q or /QS parameters) must include the /IACCEPTSQLSERVERLICENSETERMS parameter. 可以通过 Microsoft Software License Terms(Microsoft 软件许可条款)单独查看许可条款。You can review the license terms separately at Microsoft Software License Terms.

备注

根据你接收软件的方式(例如,通过 Microsoft 批量许可),你对软件的使用可能受其他条款和条件约束。Depending on how you received the software (for example, through Microsoft volume licensing), your use of the software may be subject to additional terms and conditions.

在以下情况下支持命令提示符安装:Command prompt installation is supported in the following scenarios:

  • 在命令提示符下使用指定的语法和参数,在本地计算机上安装、升级或删除 SQL Server 的实例和共享组件。Installing, upgrading, or removing an instance and shared components of SQL Server on a local computer by using syntax and parameters specified at the command prompt.
  • 安装、升级或删除故障转移群集实例。Installing, upgrading, or removing a failover cluster instance.
  • SQL ServerSQL Server 的一个版本升级到 SQL ServerSQL Server的另一个版本。Upgrading from one SQL ServerSQL Server edition to another edition of SQL ServerSQL Server.
  • 在配置文件中使用指定的语法和参数,在本地计算机上安装 SQL ServerSQL Server 的实例。Installing an instance of SQL ServerSQL Server 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.

备注

对于本地安装,必须以管理员身份运行安装程序。For local installations, you must run Setup as an administrator. 如果从远程共享安装 SQL ServerSQL Server ,则必须使用对远程共享具有读取和执行权限的域帐户。If you install SQL ServerSQL Server 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(示例:/INDICATEPROGRESS/PARAMETER (Example: /INDICATEPROGRESS)
  • /PARAMETER=true/false(示例:/SQLSVCINSTANTFILEINIT=True/PARAMETER=true/false (Example: /SQLSVCINSTANTFILEINIT=True )
  • /PARAMETER=1/0(适用于布尔类型,例如:/TCPENABLED=1/PARAMETER=1/0 for Boolean types (Example: /TCPENABLED=1)
  • 对于所有单值参数,/PARAMETER="value"。/PARAMETER="value" for all single-value parameters. (示例:/PID="PID" /SQLSVCSTARTUPTYPE="Automatic"(Example: /PID="PID" /SQLSVCSTARTUPTYPE="Automatic")
    • 对于需要路径的参数:支持 /INSTANCEDIR=c:\Path/INSTANCEDIR="c:\Path"For a parameter that requires a path: /INSTANCEDIR=c:\Path or /INSTANCEDIR="c:\Path" is supported.
  • 对于所有多值参数,/PARAMETER="value1" "value2" "value3"。/PARAMETER="value1" "value2" "value3" for all multiple-value parameters. (示例:/SQLSYSADMINACCOUNTS="Contoso\John" "Contoso\Mary"(Example: /SQLSYSADMINACCOUNTS="Contoso\John" "Contoso\Mary")
    • 例外/FEATURES,这是一个多值参数,但其格式为 /FEATURES=AS,RS,IS(无空格,使用逗号分隔)Exception : /FEATURES, which is a multivalued parameter, but its format is /FEATURES=AS,RS,IS without a space, comma-delimited.

重要

在安装 SQL ServerSQL Server 时,如果为 INSTANCEDIR 和 SQLUSERDBDIR 指定相同的目录路径,SQL Server 代理和全文搜索则会由于缺少权限而无法启动。When installing SQL ServerSQL Server, if you specify the same directory path for INSTANCEDIR and SQLUSERDBDIR, SQL Server Agent and Full Text Search do not start due to missing permissions.

备注

关系服务器值支持路径的其他终止反斜杠格式(反斜杠或两个反斜杠字符)。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.

列出的 SQL Server 数据库引擎SQL Server Database Engine 组件的参数特定于该组件。Parameters that are listed for a SQL Server 数据库引擎SQL Server Database Engine component are specific to that component. 安装 SQL Server 数据库引擎SQL Server Database Engine时,SQL Server 代理和 SQL Server Browser 参数适用。SQL Server Agent and SQL Server Browser parameters are applicable when you install the SQL Server 数据库引擎SQL Server Database Engine.

安装参数Installation Parameters

使用下表中的参数开发用于安装的命令行脚本。Use the parameters in the following table to develop command-line scripts for installation.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL ServerSQL Server 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示安装工作流。Required to indicate the installation workflow.

支持的值:Install。Supported values: Install .
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SUPPRESSPRIVACYSTATEMENTNOTICE/SUPPRESSPRIVACYSTATEMENTNOTICE

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only 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.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL ServerSQL Server Python 安装程序控件Python Setup Control /IACCEPTPYTHONLICENSETERMS/IACCEPTPYTHONLICENSETERMS

仅在为包含 Anaconda Python 包的无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only 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.
SQL ServerSQL Server R 安装程序控件R Setup Control /IACCEPTROPENLICENSETERMS/IACCEPTROPENLICENSETERMS

仅在为包含 Microsoft R Open 包的无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only 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.
SQL ServerSQL Server 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL ServerSQL ServerUse this parameter to install the English version of SQL ServerSQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL ServerSQL Server 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL ServerSQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL ServerSQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下, SQL ServerSQL Server 安装程序将包含找到的更新。By default, SQL ServerSQL Server setup will include updates that are found.
SQL ServerSQL Server 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL ServerSQL Server 安装程序将获取产品更新的位置。Specify the location where SQL ServerSQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates 或一个 UNC 共享)。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL ServerSQL Server 安装程序将通过 Windows Server Update Services 搜索 MicrosoftMicrosoft Update 或 Windows Update 服务。By default, SQL ServerSQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL ServerSQL Server 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL ServerSQL Server 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 和更高版本中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x) and newer.

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 和更高版本以将反馈发送到 MicrosoftTo manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 and newer to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service.

支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL ServerSQL Server 安装程序控件Setup Control /FEATURES/FEATURES

- 或 -- Or -

/ROLE/ROLE

必需Required
指定要安装的组件。Specifies the components to install.

选择 /FEATURES 可指定要安装的各个 SQL ServerSQL Server 组件。Choose /FEATURES to specify individual SQL ServerSQL Server components to install. 有关详细信息,请参阅 功能参数For more information, see Feature Parameters below.

选择 /ROLE 可指定安装程序角色。Choose /ROLE to specify a setup role. 安装角色在预先确定的配置中安装 SQL ServerSQL ServerSetup roles install SQL ServerSQL Server in a predetermined configuration.
SQL ServerSQL Server 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示安装参数的用法选项。Displays the usage options for installation parameters.
SQL ServerSQL Server 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file is piped to the console.
SQL ServerSQL Server 安装程序控件Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

可选Optional
为 64 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 64-bit shared components.

默认为 %Program Files%\Microsoft SQL ServerDefault is %Program Files%\Microsoft SQL Server

不能设置为 %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server
SQL ServerSQL Server 安装程序控件Setup Control /INSTALLSHAREDWOWDIR/INSTALLSHAREDWOWDIR

可选Optional
为 32 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 32-bit shared components. 仅在 64 位系统上受支持。Supported only on a 64-bit system.

默认为 %Program Files(x86)%\Microsoft SQL ServerDefault is %Program Files(x86)%\Microsoft SQL Server

不能设置为 %Program Files%\Microsoft SQL ServerCannot be set to %Program Files%\Microsoft SQL Server
SQL ServerSQL Server 安装程序控件Setup Control / INSTANCEDIR/INSTANCEDIR

可选Optional
为特定于实例的组件指定一个非默认安装目录。Specifies a nondefault installation directory for instance-specific components.
SQL ServerSQL Server 安装程序控件Setup Control /INSTANCEID/INSTANCEID

可选Optional
InstanceID指定一个非默认值。Specifies a nondefault value for an InstanceID.
SQL ServerSQL Server 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL ServerSQL Server 实例名称。Specifies a SQL ServerSQL Server instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default), Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 如果要配置包含头节点的 PolyBase 扩展计算组,请使用此选项。Use this option if you are configuring a PolyBase Scale-out computational group including the head node. 支持的值:True、False Supported values: True , False
SQL ServerSQL Server 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL ServerSQL Server 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL ServerSQL Server 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL ServerSQL Server 安装程序控件Setup Control /UIMODE/UIMODE

可选Optional
指定在安装过程中是否只提供最少数量的对话框。Specifies whether to present only the minimum number of dialog boxes during setup.

/UIMode 只能与 /ACTION=INSTALLUPGRADE 参数一起使用。/UIMode can only be used with the /ACTION=INSTALL and UPGRADE parameters. 支持的值:Supported values:

/UIMODE=Normal 对于非 Express 版本是默认值,它为所选功能提供所有安装程序对话框。/UIMODE=Normal is the default for non-Express editions and presents all setup dialog boxes for the selected features.

/UIMODE=AutoAdvance 对于 Express 版本是默认值,它跳过不重要的对话框。/UIMODE=AutoAdvance is the default for Express editions and skips nonessential dialog boxes.



请注意,当与其他参数组合时,将覆盖 UIMODENote that when combined with other parameters, UIMODE is overridden. 例如,当同时提供了 /UIMODE=AutoAdvance/ADDCURRENTUSERASSQLADMIN=FALSE 时,当前用户将不会自动填充设置对话框。For example, when /UIMODE=AutoAdvance and /ADDCURRENTUSERASSQLADMIN=FALSE are both provided, the provisioning dialog box is not auto populated with the current user.

UIMode 设置不能与 /Q/QS 参数结合使用。The UIMode setting cannot be used with the /Q or /QS parameters.
SQL ServerSQL Server 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL ServerSQL Server 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL ServerSQL Server 代理Agent /AGTSVCACCOUNT/AGTSVCACCOUNT

必需Required
为 SQL Server 代理服务指定帐户。Specifies the account for the SQL Server Agent service.
SQL ServerSQL Server 代理Agent /AGTSVCPASSWORD/AGTSVCPASSWORD

必需Required
指定 SQL Server 代理服务帐户的密码。Specifies the password for SQL Server Agent service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL ServerSQL Server 代理Agent /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE

可选Optional
为 SQL Server 代理服务指定 启动 模式。Specifies the startup mode for the SQL Server Agent service.

支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
Analysis ServicesAnalysis Services /ASBACKUPDIR/ASBACKUPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 备份文件的目录。Specifies the directory for Analysis ServicesAnalysis Services backup files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

可选Optional
指定 Analysis ServicesAnalysis Services的排序规则设置。Specifies the collation setting for Analysis ServicesAnalysis Services.

默认值:Latin1_General_CI_ASDefault value: Latin1_General_CI_AS
Analysis ServicesAnalysis Services /ASCONFIGDIR/ASCONFIGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 配置文件的目录。Specifies the directory for Analysis ServicesAnalysis Services configuration files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config
Analysis ServicesAnalysis Services /ASDATADIR/ASDATADIR

可选Optional
指定 Analysis ServicesAnalysis Services 数据文件的目录。Specifies the directory for Analysis ServicesAnalysis Services data files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data
Analysis ServicesAnalysis Services /ASLOGDIR/ASLOGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 日志文件的目录。Specifies the directory for Analysis ServicesAnalysis Services log files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log
Analysis ServicesAnalysis Services /ASSERVERMODE/ASSERVERMODE

可选Optional
指定 Analysis ServicesAnalysis Services 实例的服务器模式。Specifies the server mode of the Analysis ServicesAnalysis Services instance. 有效值为 MULTIDIMENSIONAL、POWERPIVOT 或 TABULAR。Valid values are MULTIDIMENSIONAL, POWERPIVOT, or TABULAR. ASSERVERMODE 区分大小写。ASSERVERMODE is case-sensitive. 所有值必须以大写形式表示。All values must be expressed in upper case. 有关有效值的详细信息,请参阅 安装 Analysis ServicesFor more information about valid values, see Install Analysis Services.
Analysis ServicesAnalysis Services /ASSVCACCOUNT/ASSVCACCOUNT

必需Required
指定 Analysis ServicesAnalysis Services 服务的帐户。Specifies the account for the Analysis ServicesAnalysis Services service.
Analysis ServicesAnalysis Services /ASSVCPASSWORD/ASSVCPASSWORD

必需Required
指定 Analysis ServicesAnalysis Services 服务的密码。Specifies the password for the Analysis ServicesAnalysis Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Analysis ServicesAnalysis Services /ASSVCSTARTUPTYPE/ASSVCSTARTUPTYPE

可选Optional
指定 服务的 启动 Analysis ServicesAnalysis Services 模式。Specifies the startup mode for the Analysis ServicesAnalysis Services service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
Analysis ServicesAnalysis Services /ASSYSADMINACCOUNTS/ASSYSADMINACCOUNTS

必需Required
指定 Analysis ServicesAnalysis Services的管理员凭据。Specifies the administrator credentials for Analysis ServicesAnalysis Services.
Analysis ServicesAnalysis Services /ASTEMPDIR/ASTEMPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 临时文件的目录。Specifies the directory for Analysis ServicesAnalysis Services temporary files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server \<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server \<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

可选Optional
指定 MSOLAP 提供程序是否可以在进程中运行。Specifies whether the MSOLAP provider can run in-process.

默认值:1=启用Default value: 1=enabled
Analysis ServicesAnalysis Services /FARMACCOUNT/FARMACCOUNT

对于 SPI_AS_NewFarm 是必需的Required for SPI_AS_NewFarm
指定用于在场中运行 SharePoint 管理中心服务和其他重要服务的域用户帐户。Specifies a domain user account for running SharePoint Central Administration services and other essential services in a farm.

此参数仅用于通过 /ROLE = SPI_AS_NEWFARM 安装的 Analysis ServicesAnalysis Services 实例。This parameter is used only for Analysis ServicesAnalysis Services instances that are installed through /ROLE = SPI_AS_NEWFARM.
Analysis ServicesAnalysis Services /FARMPASSWORD/FARMPASSWORD

对于 SPI_AS_NewFarm 是必需的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.
Analysis ServicesAnalysis Services /PASSPHRASE/PASSPHRASE

对于 SPI_AS_NewFarm 是必需的Required for SPI_AS_NewFarm
指定用于向 SharePoint 场添加其他应用程序服务器或 Web 前端服务器的通行短语。Specifies a passphrase that is used to add additional application servers or Web front-end servers to a SharePoint farm.

此参数仅用于通过 /ROLE = SPI_AS_NEWFARM 安装的 Analysis ServicesAnalysis Services 实例。This parameter is used only for Analysis ServicesAnalysis Services instances that are installed through /ROLE = SPI_AS_NEWFARM.
Analysis ServicesAnalysis Services /FARMADMINIPORT/FARMADMINIPORT

对于 SPI_AS_NewFarm 是必需的Required for SPI_AS_NewFarm
指定用于连接 SharePoint 管理中心 Web 应用程序的端口。Specifies a port used to connect to the SharePoint Central Administration web application.

此参数仅用于通过 /ROLE = SPI_AS_NEWFARM 安装的 Analysis ServicesAnalysis Services 实例。This parameter is used only for Analysis ServicesAnalysis Services instances that are installed through /ROLE = SPI_AS_NEWFARM.
SQL Server BrowserSQL Server Browser /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

可选Optional
指定 SQL Server Browser 服务的 启动 模式。Specifies the startup mode for SQL Server Browser service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 数据库引擎SQL Server Database Engine /ENABLERANU/ENABLERANU

可选Optional
SQL Server ExpressSQL Server Express 安装启用运行身份凭据。Enables run-as credentials for SQL Server ExpressSQL Server Express installations.
SQL Server 数据库引擎SQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

可选Optional
指定 SQL ServerSQL Server 数据文件的数据目录。Specifies the data directory for SQL ServerSQL Server data files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\

对于所有其他安装:%Program Files%\Microsoft SQL Server\For all other installations: %Program Files%\Microsoft SQL Server\
SQL Server 数据库引擎SQL Server Database Engine /SAPWD/SAPWD

/SECURITYMODE=SQL 时是必需的Required when /SECURITYMODE=SQL
指定 SQL ServerSQL Server SA 帐户的密码。Specifies the password for the SQL ServerSQL Server SA account.
SQL Server 数据库引擎SQL Server Database Engine /SECURITYMODE/SECURITYMODE

可选Optional
指定 SQL ServerSQL Server 的安全模式。Specifies the security mode for SQL ServerSQL Server.

如果未提供此参数,则支持仅 Windows 身份验证模式。If this parameter is not supplied, then Windows-only authentication mode is supported.

支持的值: SQLSupported value: SQL
SQL Server 数据库引擎SQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

可选Optional
指定备份文件的目录。Specifies the directory for backup files.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\BackupDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup
SQL Server 数据库引擎SQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

可选Optional
指定 SQL ServerSQL Server的排序规则设置。Specifies the collation settings for SQL ServerSQL Server.

默认安装设置由操作系统 (OS) 区域设置确定。The default installation setting is determined by the operating system (OS) locale. 服务器级排序规则可以在安装期间更改,也可以在安装前通过更改 OS 区域设置进行更改。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 is not always the recommended collation. 更改 Windows 排序规则的默认安装设置可充分利用 SQL ServerSQL Server 功能。To take full advantage of SQL ServerSQL Server features, change the default installation settings to use Windows collations. 例如,对于 OS 区域设置“英语(美国)”(代码页 1252),安装过程中的默认排序规则是 SQL_Latin1_General_CP1_CI_AS,可将其更改为最接近的 Windows 对等排序规则 Latin1_General_100_CI_AS_SC 。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 .

有关详细信息,请参阅排序规则和 Unicode 支持For more information, see Collations and Unicode support.
SQL Server 数据库引擎SQL Server Database Engine /ADDCURRENTUSERASSQLADMIN/ADDCURRENTUSERASSQLADMIN

可选Optional
将当前用户添加到 SQL ServerSQL Server sysadmin 固定服务器角色。Adds the current user to the SQL ServerSQL Server sysadmin fixed server role. 当安装 Express 版本或使用 /Role=ALLFeatures_WithDefaults 时,可以使用 /ADDCURRENTUSERASSQLADMIN 参数。The /ADDCURRENTUSERASSQLADMIN parameter can be used when installing Express editions or when /Role=ALLFeatures_WithDefaults is used. 有关详细信息,请参阅下面的 /ROLE。For more information, see /ROLE below.

使用 /ADDCURRENTUSERASSQLADMIN 是可选的,但 /ADDCURRENTUSERASSQLADMIN 或 /SQLSYSADMINACCOUNTS 是必需的。Use of /ADDCURRENTUSERASSQLADMIN is optional, but either /ADDCURRENTUSERASSQLADMIN or /SQLSYSADMINACCOUNTS is required. 默认值:Default values:

True True SQL Server ExpressSQL Server ExpressTrue for editions of SQL Server ExpressSQL Server Express

对于所有其他版本则为 FalseFalse for all other editions
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必需Required
指定 SQL ServerSQL Server 服务的启动帐户。Specifies the startup account for the SQL ServerSQL Server service.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必需Required
指定 SQLSVCACCOUNT 的密码。Specifies the password for SQLSVCACCOUNT. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCSTARTUPTYPE/SQLSVCSTARTUPTYPE

可选Optional
指定 服务的 启动 SQL ServerSQL Server 模式。Specifies the startup mode for the SQL ServerSQL Server service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 数据库引擎SQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必需Required
使用此参数可将登录帐户设置为 sysadmin 角色的成员。Use this parameter to provision logins to be members of the sysadmin role.

对于 SQL ServerSQL Server 之外的 SQL Server ExpressSQL Server Express 版本,/SQLSYSADMINACCOUNTS 是必需的。For SQL ServerSQL Server editions other than SQL Server ExpressSQL Server Express, /SQLSYSADMINACCOUNTS is required. 对于 SQL Server ExpressSQL Server Express的各版本,使用 /SQLSYSADMINACCOUNTS 是可选的,但 /SQLSYSADMINACCOUNTS 或 /ADDCURRENTUSERASSQLADMIN 是必需的。For editions of SQL Server ExpressSQL Server Express, use of /SQLSYSADMINACCOUNTS is optional, but either /SQLSYSADMINACCOUNTS or /ADDCURRENTUSERASSQLADMIN is required.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

可选Optional
指定 tempdb 数据文件的目录。Specifies the directories for tempdb data files. 指定多个目录时,请用空格将目录隔开。When specifying more than one directory, separate the directories with a blank space. 如果指定了多个目录,则 tempdb 数据文件将以轮循机制的方式分布在目录中。If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意: 此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

可选Optional
指定 tempdb 日志文件的目录。Specifies the directory for tempdb log file.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILECOUNT/SQLTEMPDBFILECOUNT

可选Optional
指定要由安装程序添加的 tempdb 数据文件的数量。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:

对于 SQL Server ExpressSQL Server Express为 11 for SQL Server ExpressSQL Server Express

8 或内核的数量,对所有其他版本来说都较低8 or the number of cores, whichever is lower for all other editions

重要提示:tempdb 的主数据库文件依然为 tempdb.mdf。Important The primary database file for tempdb will still be tempdb.mdf. 将其他 tempdb 文件命名为 tempdb_mssql_#.ndf,其中 # 代表在安装期间创建的每个其他 tempdb 数据文件的唯一编号。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. 卸载 SQL Server 的实例将删除具有命名约定 tempdb_mssql_ #.ndf 的文件。Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. 不要对用户数据库文件使用 tempdb_mssql_*.ndf 命名约定。Do not use tempdb_mssql_*.ndf naming convention for user database files.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILESIZE/SQLTEMPDBFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 数据文件的初始大小。Specifies the initial size of each tempdb data file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILEGROWTH/SQLTEMPDBFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64。Default value: 64. 允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILESIZE/SQLTEMPDBLOGFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 日志文件的初始大小。Specifies the initial size of each tempdb log file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILEGROWTH/SQLTEMPDBLOGFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64。Default value: 64. 允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

可选Optional
指定用户数据库的数据文件的目录。Specifies the directory for the data files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCINSTANTFILEINIT/SQLSVCINSTANTFILEINIT

可选Optional
启用 SQL ServerSQL Server 服务帐户的即时文件初始化。Enables instant file initialization for SQL ServerSQL Server service account. 有关安全性和性能注意事项,请参阅 数据库实例文件初始化For security and performance considerations, see Database Instant File Initialization.

默认值:“False”Default value: "False"

可选值:“True”Optional value: "True"
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

可选Optional
指定用户数据库的日志文件的目录。Specifies the directory for the log files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
SQL Server 数据库引擎SQL Server Database Engine /SQLMAXDOP=parameter/SQLMAXDOP=parameter

可选Optional
如果在无人参与(无提示)安装中被省略,MAXDOP 遵循“最大并行度”准则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. 仅从 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 开始可用。Only available starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x).

默认值遵循最大并行度准则Default value will align with the max degree of parallelism guidelines
SQL Server 数据库引擎SQL Server Database Engine /USESQLRECOMMENDEDMEMORYLIMITS/USESQLRECOMMENDEDMEMORYLIMITS

可选Optional
如果 /USESQLRECOMMENDEDMEMORYLIMITS、/SQLMINMEMORY 和 /SQLMAXMEMORY 在无人参与(无提示)安装中被省略,SQL Server 数据库引擎SQL Server Database Engine 使用默认 SQL ServerSQL Server 内存配置。If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the SQL Server 数据库引擎SQL Server Database Engine will use the default SQL ServerSQL Server memory configuration.
指定 SQL Server 数据库引擎SQL Server Database Engine 将使用计算出的建议值,建议值遵循独立 SQL ServerSQL Server 实例的服务器内存配置准则Specifies that the SQL Server 数据库引擎SQL Server Database Engine will use calculated recommended values that align with the server memory configuration guidelines for a standalone SQL ServerSQL Server instance. 仅从 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 开始可用。Only available starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x).

注意: 此参数无法与 /SQLMINMEMORY 和 /SQLMAXMEMORY 结合使用。Note: This parameter cannot be used with /SQLMINMEMORY and /SQLMAXMEMORY.
SQL Server 数据库引擎SQL Server Database Engine /SQLMINMEMORY/SQLMINMEMORY

可选Optional
如果 /USESQLRECOMMENDEDMEMORYLIMITS、/SQLMINMEMORY 和 /SQLMAXMEMORY 在无人参与(无提示)安装中被省略,SQL Server 数据库引擎SQL Server Database Engine 使用默认 SQL ServerSQL Server 内存配置。If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the SQL Server 数据库引擎SQL Server Database Engine will use the default SQL ServerSQL Server memory configuration.
以 MB 为单位指定最小服务器内存配置。Specifies the Min Server Memory configuration in MB. 仅从 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 开始可用。Only available starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x).

默认值:0。Default value: 0.

注意: 此参数无法与 /USESQLRECOMMENDEDMEMORYLIMITS 结合使用。Note: This parameter cannot be used with /USESQLRECOMMENDEDMEMORYLIMITS.
SQL Server 数据库引擎SQL Server Database Engine /SQLMAXMEMORY/SQLMAXMEMORY

可选Optional
如果 /USESQLRECOMMENDEDMEMORYLIMITS、/SQLMINMEMORY 和 /SQLMAXMEMORY 在无人参与(无提示)安装中被省略,SQL Server 数据库引擎SQL Server Database Engine 使用默认 SQL ServerSQL Server 内存配置。If /USESQLRECOMMENDEDMEMORYLIMITS, /SQLMINMEMORY, and /SQLMAXMEMORY are omitted on unattended (silent) installs, the SQL Server 数据库引擎SQL Server Database Engine will use the default SQL ServerSQL Server memory configuration.
以 MB 为单位指定最大服务器内存配置。Specifies the Max Server Memory configuration in MB. 仅从 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 开始可用。Only available starting with SQL Server 2019 (15.x)SQL Server 2019 (15.x).

默认值:计算出的建议值,遵循独立 SQL ServerSQL Server 实例的服务器内存配置准则Default value: calculated recommended value that aligns with the server memory configuration guidelines for a standalone SQL ServerSQL Server instance.

注意: 此参数无法与 /USESQLRECOMMENDEDMEMORYLIMITS 结合使用。Note: This parameter cannot be used with /USESQLRECOMMENDEDMEMORYLIMITS.
FILESTREAMFILESTREAM /FILESTREAMLEVEL/FILESTREAMLEVEL

可选Optional
指定 FILESTREAM 功能的访问级别。Specifies the access level for the FILESTREAM feature. 支持的值:Supported values:

0=禁用此实例的 FILESTREAM 支持。0 =Disable FILESTREAM support for this instance. (默认值)(Default value)

1=针对 Transact-SQLTransact-SQL 访问启用 FILESTREAM。1=Enable FILESTREAM for Transact-SQLTransact-SQL access.

2=针对 Transact-SQLTransact-SQL 和文件 I/O 流访问启用 FILESTREAM。2=Enable FILESTREAM for Transact-SQLTransact-SQL and file I/O streaming access. (对于群集方案无效)(Not valid for cluster scenarios)

3=允许远程客户端针对 FILESTREAM 数据启用流访问。3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAMFILESTREAM /FILESTREAMSHARENAME/FILESTREAMSHARENAME

可选Optional

当 FILESTREAMLEVEL 大于 1 时是必需的。Required when FILESTREAMLEVEL is greater than 1.
指定用来存储 FILESTREAM 数据的 Windows 共享的名称。Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server 全文SQL Server Full Text /FTSVCACCOUNT/FTSVCACCOUNT

可选Optional
指定全文筛选器启动器服务的帐户。Specifies the account for Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. ServiceSID 用于保护 SQL Server 与全文筛选器后台程序之间的通信。ServiceSID is used to help secure the communication between SQL Server and Full-text Filter Daemon. 如果未提供这些值,则将禁用全文筛选器启动器服务。If the values are not provided, the Full-text Filter Launcher Service is disabled. 您必须使用 SQL Server 控制管理器来更改服务帐户和启用全文功能。You have to use SQL Server Control Manager to change the service account and enable full-text functionality.

默认值:Local Service 帐户Default value: Local Service Account
SQL Server 全文SQL Server Full Text /FTSVCPASSWORD/FTSVCPASSWORD

可选Optional
指定全文筛选器启动器服务的密码。Specifies the password for the Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必需Required
指定 Integration ServicesIntegration Services的帐户。Specifies the account for Integration ServicesIntegration Services.

默认值:NT AUTHORITY\NETWORK SERVICEDefault value: NT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCStartupType/ISSVCStartupType

可选Optional
指定 服务的 启动 Integration ServicesIntegration Services 模式。Specifies the startup mode for the Integration ServicesIntegration Services service.
SQL Server 网络配置SQL Server Network Configuration /NPENABLED/NPENABLED

可选Optional
指定 SQL Server 服务的 Named Pipes 协议的状态。Specifies the state of the Named Pipes protocol for the SQL Server service. 支持的值:Supported values:

0=禁用 Named Pipes 协议0=disable the Named Pipes protocol

1=启用 Named Pipes 协议1=enable the Named Pipes protocol
SQL Server 网络配置SQL Server Network Configuration /TCPENABLED/TCPENABLED

可选Optional
指定 SQL Server 服务的 TCP 协议的状态。Specifies the state of the TCP protocol for the SQL Server service. 支持的值:Supported values:

0=禁用 TCP 协议0=disable the TCP protocol

1=启用 TCP 协议1=enable the TCP protocol
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services. 支持的值:Supported Values:

SharePointFilesOnlyModeSharePointFilesOnlyMode

DefaultNativeModeDefaultNativeMode

FilesOnlyModeFilesOnlyMode



注意:如果安装包括 SQL Server数据库引擎Database Engine,则默认的 RSINSTALLMODE 为 DefaultNativeMode。Note: If the installation includes the SQL Server数据库引擎Database Engine, the default RSINSTALLMODE is DefaultNativeMode.

如果安装不包括 SQL Server数据库引擎Database Engine,则默认的 RSINSTALLMODE 为 FilesOnlyMode。If the installation does not include the SQL Server数据库引擎Database Engine, the default RSINSTALLMODE is FilesOnlyMode.

如果选择 DefaultNativeMode,但安装不包括 SQL Server数据库引擎Database Engine,则安装会自动将 RSINSTALLMODE 更改为 FilesOnlyMode。If you choose DefaultNativeMode but the installation does not include the SQL Server数据库引擎Database Engine, the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的启动帐户。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services 服务的启动帐户的密码。Specifies the password for the startup account for the Reporting ServicesReporting Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 启动 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
Python/机器学习服务(数据库内)Python/Machine Learning Services (In-Database) /MPYCACHEDIRECTORY/MPYCACHEDIRECTORY 保留供将来使用。Reserved for future use. 使用 %TEMP% 存储 Python .CAB 文件,以便在没有 Internet 连接的计算机上安装。Use %TEMP% to store Python .CAB files for installation on a computer that does not have an internet connection.
R/机器学习服务(数据库内)R/Machine Learning Services (In-Database) /MRCACHEDIRECTORY/MRCACHEDIRECTORY 使用此参数为 Microsoft R Open、SQL Server 2016 R Services、SQL Server 2016 R Server(独立版)或者 SQL Server 机器学习服务或机器学习服务器(独立版)中的 R 功能支持指定缓存目录。Use this parameter to specify the Cache directory for Microsoft R Open, SQL Server 2016 R Services, SQL Server 2016 R Server (Standalone), or R feature support in SQL Server Machine Learning Services or Machine Learning Server (Standalone). 没有 Internet 访问的计算机上的命令行安装 R 组件时,通常使用此设置。This setting is typically used when installing R components from the command line on a computer without Internet access.
Java/语言扩展Java/Language Extensions /SQL_INST_JAVA,/SQL_INST_JAVA,
/SQLJAVADIR = "path"/SQLJAVADIR = "path"

可选Optional
从 SQL Server 2019 开始,指定通过语言扩展安装 Java。Starting with SQL Server 2019, specifies installing Java with Language Extensions. 如果提供的 /SQL_INST_JAVA 不带 /SQLJAVADIR 参数,则表示假设你要安装由安装介质提供的 Zulu Open JRE。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.

为 /SQLJAVADIR 提供路径表示你要使用已安装的 JRE 或 JDK。Providing a path for /SQLJAVADIR indicates you would like to use an already-installed JRE or JDK.
示例语法:Sample Syntax:

安装新的具有 SQL Server 数据库引擎SQL Server Database Engine、复制和全文搜索组件的独立实例并启用 SQL Server 数据库引擎SQL Server Database Engine的即时文件初始化。To install a new, stand-alone instance with the SQL Server 数据库引擎SQL Server Database Engine, Replication, and Full-Text Search components and enable instant file initialization for SQL Server 数据库引擎SQL Server Database Engine.

setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCINSTANTFILEINIT="True" /IACCEPTSQLSERVERLICENSETERMS  

参数SysPrep Parameters

有关 SQL ServerSQL Server SysPrep 的详细信息,请参阅For more information about SQL ServerSQL Server SysPrep, see

使用 SysPrep 安装 SQL Server 2016 (13.x)SQL Server 2016 (13.x)Install SQL Server 2016 (13.x)SQL Server 2016 (13.x) Using SysPrep.

准备映像参数Prepare Image Parameters

使用下表中的参数可开发用于准备但不配置 SQL Server 实例的命令行脚本。Use the parameters in the following table to develop command-line scripts for preparing an instance of SQL Server without configuring it.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL ServerSQL Server 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示安装工作流。Required to indicate the installation workflow.

支持的值:PrepareImageSupported values: PrepareImage
SQL ServerSQL Server 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL ServerSQL Server 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL ServerSQL Server 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL ServerSQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL ServerSQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL ServerSQL Server 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL ServerSQL Server 安装程序将获取产品更新的位置。Specify the location where SQL ServerSQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates 或一个 UNC 共享)。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL ServerSQL Server 安装程序将通过 Windows Server Update Services 搜索 MicrosoftMicrosoft Update 或 Windows Update 服务。By default, SQL ServerSQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL ServerSQL Server 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL ServerSQL Server 安装程序控件Setup Control /FEATURES/FEATURES

必需Required
指定要安装的 组件Specifies components to install.

支持的值有: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、POLYBASESupported 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
SQL ServerSQL Server 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示安装参数的用法选项。Displays the usage options for installation parameters.
SQL ServerSQL Server 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL ServerSQL Server 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file is piped to the console.
SQL ServerSQL Server 安装程序控件Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

可选Optional
为 64 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 64-bit shared components.

默认为 %Program Files%\Microsoft SQL ServerDefault is %Program Files%\Microsoft SQL Server

不能设置为 %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server
SQL ServerSQL Server 安装程序控件Setup Control / INSTANCEDIR/INSTANCEDIR

可选Optional
为特定于实例的组件指定一个非默认安装目录。Specifies a nondefault installation directory for instance-specific components.
SQL ServerSQL Server 安装程序控件Setup Control /INSTANCEID/INSTANCEID

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2(2013 年 1 月)之前, 必需Prior to SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 (January 2013) Required

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 开始, 必需 此参数才可获得实例功能。Beginning with SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 Required for instance features.
指定正在准备的实例的 InstanceID。Specifies an InstanceID for the instance that is being prepared.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default), Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL ServerSQL Server 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL ServerSQL Server 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
示例语法:Sample Syntax:

准备新的具有 SQL Server 数据库引擎SQL Server Database Engine、复制和全文搜索组件以及 Reporting ServicesReporting Services的独立实例。To prepare a new, stand-alone instance with the SQL Server 数据库引擎SQL Server Database Engine, Replication, and Full-Text Search components, and Reporting ServicesReporting Services.

setup.exe /q /ACTION=PrepareImage /FEATURES=SQL,RS /InstanceID =<MYINST> /IACCEPTSQLSERVERLICENSETERMS  

完成映像参数Complete Image Parameters

使用下表中的参数可开发用于完成和配置已准备好的 SQL Server 实例的命令行脚本。Use the parameters in the following table to develop command-line scripts for completing and configuring a prepared instance of SQL Server.

SQL ServerSQL Server 组件component 参数Parameter 说明Description
SQL ServerSQL Server 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示安装工作流。Required to indicate the installation workflow.

支持的值:CompleteImageSupported values: CompleteImage
SQL ServerSQL Server 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL ServerSQL Server 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL ServerSQL Server 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL ServerSQL Server 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL ServerSQL Server 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示安装参数的用法选项。Displays the usage options for installation parameters.
SQL ServerSQL Server 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file is piped to the console.
SQL ServerSQL Server 安装程序控件Setup Control /INSTANCEID/INSTANCEID

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2(2013 年 1 月)之前, 必需Prior to SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 (January 2013) Required

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 起, 可选Beginning with SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 Optional
使用在准备映像步骤中指定的实例 ID。Use the Instance ID specified during the prepare image step.

支持的值:已准备实例的 InstanceID。Supported Values: InstanceID of a Prepared Instance.
SQL ServerSQL Server 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2(2013 年 1 月)之前, 必需Prior to SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 (January 2013) Required

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 起, 可选Beginning with SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 CU2 Optional
为正在完成的实例指定 SQL ServerSQL Server 实例名称。Specifies a SQL ServerSQL Server instance name for the instance that is being completed.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL ServerSQL Server 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL ServerSQL Server版本的产品密钥。Specifies the product key for the edition of SQL ServerSQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.

注意: 如果安装的是 SQL Server ExpressSQL Server ExpressSQL Server ExpressSQL Server Express with tools 或 SQL Server ExpressSQL Server Express with Advanced Services,则会预定义 PID。Note: If you are installing SQL Server ExpressSQL Server Express, SQL Server ExpressSQL Server Express with tools, or SQL Server ExpressSQL Server Express with Advanced Services, the PID is predefined.
SQL ServerSQL Server 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL ServerSQL Server 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL ServerSQL Server 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 代理SQL Server Agent /AGTSVCACCOUNT/AGTSVCACCOUNT

必需Required
为 SQL Server 代理服务指定帐户。Specifies the account for the SQL Server Agent service.
SQL Server 代理SQL Server Agent /AGTSVCPASSWORD/AGTSVCPASSWORD

必需Required
指定 SQL Server 代理服务帐户的密码。Specifies the password for SQL Server Agent service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 代理SQL Server Agent /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE

可选Optional
为 SQL Server 代理服务指定 启动 模式。Specifies the startup mode for the SQL Server Agent service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server BrowserSQL Server Browser /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

可选Optional
指定 SQL Server Browser 服务的 启动 模式。Specifies the startup mode for SQL Server Browser service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 数据库引擎SQL Server Database Engine /ENABLERANU/ENABLERANU

可选Optional
SQL Server ExpressSQL Server Express 安装启用运行身份凭据。Enables run-as credentials for SQL Server ExpressSQL Server Express installations.
SQL Server 数据库引擎SQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

可选Optional
指定 SQL ServerSQL Server 数据文件的数据目录。Specifies the data directory for SQL ServerSQL Server data files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\For WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\

对于所有其他安装:%Program Files%\Microsoft SQL Server\For all other installations: %Program Files%\Microsoft SQL Server\
SQL Server 数据库引擎SQL Server Database Engine /SAPWD/SAPWD

/SECURITYMODE=SQL 时是必需的Required when /SECURITYMODE=SQL
指定 SQL ServerSQL Server SA 帐户的密码。Specifies the password for the SQL ServerSQL Server SA account.
SQL Server 数据库引擎SQL Server Database Engine /SECURITYMODE/SECURITYMODE

可选Optional
指定 SQL ServerSQL Server 的安全模式。Specifies the security mode for SQL ServerSQL Server.

如果未提供此参数,则支持仅 Windows 身份验证模式。If this parameter is not supplied, then Windows-only authentication mode is supported.

支持的值: SQLSupported value: SQL
SQL Server 数据库引擎SQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

可选Optional
指定备份文件的目录。Specifies the directory for backup files.

默认值:Default value:

<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup
SQL Server 数据库引擎SQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

可选Optional
指定 SQL ServerSQL Server的排序规则设置。Specifies the collation settings for SQL ServerSQL Server.

默认值基于您的 Windows 操作系统的区域设置。The default value is based on the locale of your Windows operating system. 有关详细信息,请参阅 Collation Settings in Setup(安装程序中的排序规则设置)。For more information, see Collation Settings in Setup.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必需Required
指定 SQL ServerSQL Server 服务的启动帐户。Specifies the startup account for the SQL ServerSQL Server service.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必需Required
指定 SQLSVCACCOUNT 的密码。Specifies the password for SQLSVCACCOUNT. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCSTARTUPTYPE/SQLSVCSTARTUPTYPE

可选Optional
指定 服务的 启动 SQL ServerSQL Server 模式。Specifies the startup mode for the SQL ServerSQL Server service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 数据库引擎SQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必需Required
使用此参数可将登录帐户设置为 sysadmin 角色的成员。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

可选Optional
指定 tempdb 数据文件的目录。Specifies the directories for tempdb data files. 指定多个目录时,请用空格将目录隔开。When specifying more than one directory, separate the directories with a blank space. 如果指定了多个目录,则 tempdb 数据文件将以轮循机制的方式分布在目录中。If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。NOTE: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

可选Optional
指定 tempdb 日志文件的目录。Specifies the directory for tempdb log file.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILESIZE/SQLTEMPDBFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 数据文件的初始大小。Specifies the initial size of each tempdb data file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)。Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x).
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILEGROWTH/SQLTEMPDBFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64Default value: 64

允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILESIZE/SQLTEMPDBLOGFILESIZE

可选Optional
指定 tempdb 日志文件的初始大小 (MB)。Specifies the initial size of the tempdb log file in MB. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:Default value:

对于 SQL Server ExpressSQL Server Express为 44 for SQL Server ExpressSQL Server Express

所有其他版本为 88 for all other editions

允许的范围:最小 = 默认值(4 或 8),最大 = 1024Allowed range: Min = default value (4 or 8), Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILEGROWTH/SQLTEMPDBLOGFILEGROWTH

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 日志文件的初始大小。Specifies the initial size of each tempdb log file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILECOUNT/SQLTEMPDBFILECOUNT

可选Optional
指定要由安装程序添加的 tempdb 数据文件的数量。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:

对于 SQL Server ExpressSQL Server Express为 11 for SQL Server ExpressSQL Server Express

8 或内核的数量,对所有其他版本来说都较低8 or the number of cores, whichever is lower for all other editions

重要提示: tempdb 的主数据库文件依然为 tempdb.mdf。Important: The primary database file for tempdb will still be tempdb.mdf. 将其他 tempdb 文件命名为 tempdb_mssql_#.ndf,其中 # 代表在安装期间创建的每个其他 tempdb 数据文件的唯一编号。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. 卸载 SQL Server 的实例将删除具有命名约定 tempdb_mssql_ #.ndf 的文件。Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. 不要对用户数据库文件使用 tempdb_mssql_*.ndf 命名约定。Do not use tempdb_mssql_*.ndf naming convention for user database files.

警告:SQL Server ExpressSQL Server Express 不支持配置此参数。Warning: SQL Server ExpressSQL Server Express is not supported for configuring this parameter. 安装程序仅安装 1 个 tempdb 数据文件。Setup installs only 1 tempdb data file.
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

可选Optional
指定用户数据库的数据文件的目录。Specifies the directory for the data files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

可选Optional
指定用户数据库的日志文件的目录。Specifies the directory for the log files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
FILESTREAMFILESTREAM /FILESTREAMLEVEL/FILESTREAMLEVEL

可选Optional
指定 FILESTREAM 功能的访问级别。Specifies the access level for the FILESTREAM feature. 支持的值:Supported values:

0=禁用此实例的 FILESTREAM 支持。0 =Disable FILESTREAM support for this instance. (默认值)(Default value)

1=针对 Transact-SQLTransact-SQL 访问启用 FILESTREAM。1=Enable FILESTREAM for Transact-SQLTransact-SQL access.

2=针对 Transact-SQLTransact-SQL 和文件 I/O 流访问启用 FILESTREAM。2=Enable FILESTREAM for Transact-SQLTransact-SQL and file I/O streaming access. (对于群集方案无效)(Not valid for cluster scenarios)

3=允许远程客户端针对 FILESTREAM 数据启用流访问。3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAMFILESTREAM /FILESTREAMSHARENAME/FILESTREAMSHARENAME

可选Optional

当 FILESTREAMLEVEL 大于 1 时是必需的。Required when FILESTREAMLEVEL is greater than 1.
指定用来存储 FILESTREAM 数据的 Windows 共享的名称。Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server 全文SQL Server Full Text /FTSVCACCOUNT/FTSVCACCOUNT

可选Optional
指定全文筛选器启动器服务的帐户。Specifies the account for Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. ServiceSID 用于保护 SQL Server 与全文筛选器后台程序之间的通信。ServiceSID is used to help secure the communication between SQL Server and Full-text Filter Daemon. 如果未提供这些值,则将禁用全文筛选器启动器服务。If the values are not provided, the Full-text Filter Launcher Service is disabled. 您必须使用 SQL Server 控制管理器来更改服务帐户和启用全文功能。You have to use SQL Server Control Manager to change the service account and enable full-text functionality.

默认值:Local Service 帐户Default value: Local Service Account
SQL Server 全文SQL Server Full Text /FTSVCPASSWORD/FTSVCPASSWORD

可选Optional
指定全文筛选器启动器服务的密码。Specifies the password for the Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 网络配置SQL Server Network Configuration /NPENABLED/NPENABLED

可选Optional
指定 SQL Server 服务的 Named Pipes 协议的状态。Specifies the state of the Named Pipes protocol for the SQL Server service. 支持的值:Supported values:

0=禁用 Named Pipes 协议0=disable the Named Pipes protocol

1=启用 Named Pipes 协议1=enable the Named Pipes protocol
SQL Server 网络配置SQL Server Network Configuration /TCPENABLED/TCPENABLED

可选Optional
指定 SQL Server 服务的 TCP 协议的状态。Specifies the state of the TCP protocol for the SQL Server service. 支持的值:Supported values:

0=禁用 TCP 协议0=disable the TCP protocol

1=启用 TCP 协议1=enable the TCP protocol
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的启动帐户。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services 服务的启动帐户的密码。Specifies the password for the startup account for the Reporting ServicesReporting Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 启动 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
示例语法:Sample Syntax:

完成已准备的、包含 SQL Server 数据库引擎SQL Server Database Engine、复制和全文搜索组件的独立实例。To complete a prepared, stand-alone instance that includes SQL Server 数据库引擎SQL Server Database Engine, Replication, and Full-Text Search components.

setup.exe /q /ACTION=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.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示安装工作流。Required to indicate the installation workflow. 支持的值:Supported values:

升级Upgrade

EditionUpgradeEditionUpgrade



EditionUpgrade 值用于将现有版本的 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 升级到另一版本。The value EditionUpgrade is used to upgrade an existing edition of SQL Server 2019 (15.x)SQL Server 2019 (15.x) to a different edition. 有关支持的版本升级的详细信息,请参阅 Supported Version and Edition UpgradesFor more information about the supported version and edition upgrades, see Supported Version and Edition Upgrades.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL Server 安装程序将获取产品更新的位置。Specify the location where SQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates)或一个 UNC 共享。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL Server 安装程序将通过 Windows Server 更新服务搜索 MicrosoftMicrosoft 更新或 Windows 更新服务。By default, SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control / INSTANCEDIR/ INSTANCEDIR

可选Optional
为共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for shared components.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCEID/INSTANCEID

在从 SQL Server 2008SQL Server 2008 或更高版本进行升级时为必需项Required when you upgrade from SQL Server 2008SQL Server 2008 or later.

SQL Server 2005 (9.x)SQL Server 2005 (9.x) 升级时为可选项Optional when you upgrade from SQL Server 2005 (9.x)SQL Server 2005 (9.x)
InstanceID指定一个非默认值。Specifies a nondefault value for an InstanceID.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q/Q

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UIMODE/UIMODE

可选Optional
指定在安装过程中是否只提供最少数量的对话框。Specifies whether to present only the minimum number of dialog boxes during setup.
/UIMode 只能与 /ACTION=INSTALLUPGRADE 参数一起使用。/UIMode can only be used with the /ACTION=INSTALL and UPGRADE parameters. 支持的值:Supported values:

/UIMODE=Normal 对于非 Express 版本是默认值,它为所选功能提供所有安装程序对话框。/UIMODE=Normal is the default for non-Express editions and presents all setup dialog boxes for the selected features.

/UIMODE=AutoAdvance 对于 Express 版本是默认值,它跳过不重要的对话框。/UIMODE=AutoAdvance is the default for Express editions and skips nonessential dialog boxes.

请注意, UIMode 设置不能与 /Q/QS 参数结合使用。Note that the UIMode setting cannot be used with the /Q or /QS parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口将隐藏或关闭。Specifies the console window would be hidden or closed.
SQL Server Browser 服务SQL Server Browser Service /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

可选Optional
指定 SQL Server Browser 服务的 启动 模式。Specifies the startup mode for SQL Server Browser service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 全文SQL Server Full-Text /FTUPGRADEOPTION/FTUPGRADEOPTION

可选Optional
指定全文目录升级选项。Specifies the Full-Text catalog upgrade option. 支持的值:Supported values:

REBUILDREBUILD

RESETRESET

IMPORTIMPORT
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必需Required
指定 Integration ServicesIntegration Services的帐户。Specifies the account for Integration ServicesIntegration Services.

默认值:NT AUTHORITY\NETWORK SERVICEDefault value: NT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCStartupType/ISSVCStartupType

可选Optional
指定 服务的 启动 Integration ServicesIntegration Services 模式。Specifies the startup mode for the Integration ServicesIntegration Services service.
Reporting ServicesReporting Services /RSUPGRADEDATABASEACCOUNT/RSUPGRADEDATABASEACCOUNT

可选Optional
仅当升级版本为 2008 R2 或更低版本的 SharePoint 模式报表服务器时才使用此属性。The property is only used when upgrading a SharePoint mode Report Server that is version 2008 R2 or earlier. 对于使用较旧 SharePoint 模式体系结构(在 SQL Server 2012 (11.x)SQL Server 2012 (11.x) Reporting ServicesReporting Services 中已更改)的报表服务器,将执行额外的升级操作。Additional upgrade operations are performed for report servers that use the older SharePoint mode architecture, which was changed in SQL Server 2012 (11.x)SQL Server 2012 (11.x) Reporting ServicesReporting Services. 如果命令行安装中未附随此选项,则使用针对旧报表服务器实例的默认服务帐户。If this option is not included with the command-line installation, the default service account for the old report server instance is used. 如果使用此属性,则使用 /RSUPGRADEPASSWORD 属性提供帐户密码。If this property is used, supply the password for the account using the /RSUPGRADEPASSWORD property.
Reporting ServicesReporting Services /RSUPGRADEPASSWORD/RSUPGRADEPASSWORD

可选Optional
现有 Report Server 服务帐户的密码。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.
Reporting ServicesReporting Services /ALLOWUPGRADEFORSSRSSHAREPOINTMODE/ALLOWUPGRADEFORSSRSSHAREPOINTMODE 升级基于 SharePoint 共享服务体系结构的 SharePoint 模式安装时需要该开关。The switch is required when upgrading a SharePoint Mode installation that is based on the SharePoint shared service architecture. 升级 Reporting ServicesReporting Services的非共享服务版本不需要该开关。The switch is not needed for upgrading non-shared service versions of Reporting ServicesReporting Services.
示例语法:Sample Syntax:

从以前的 SQL Server 数据库引擎SQL Server Database Engine 版本升级现有实例或故障转移群集节点,To upgrade an existing instance or failover cluster node from a previous SQL Server 数据库引擎SQL Server Database Engine version,

setup.exe /q /ACTION=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.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示修复工作流。Required to indicate the repair workflow.

支持的值:RepairSupported values: Repair
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server 数据库引擎SQL Server Database EngineUse this parameter to install the English version of SQL Server 数据库引擎SQL Server Database Engine on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FEATURES/FEATURES

必需Required
指定要修复的 组件Specifies components to repair.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
示例语法:Sample Syntax:

修复实例和共享组件。Repair an instance and shared components.

setup.exe /q /ACTION=Repair /INSTANCENAME=<instancename>  

重新生成系统数据库参数Rebuild System Database Parameters

使用下表中的参数可开发命令行脚本来重新生成 master、model、msdb 和 tempdb 系统数据库。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.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示重新生成数据库工作流。Required to indicate the rebuild database workflow.

支持的值:RebuilddatabaseSupported values: Rebuilddatabase
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations.
SQL Server 数据库引擎SQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

可选Optional
指定新的服务器级排序规则。Specifies a new server-level collation.

默认值基于您的 Windows 操作系统的区域设置。The default value is based on the locale of your Windows operating system. 有关详细信息,请参阅 Collation Settings in Setup(安装程序中的排序规则设置)。For more information, see Collation Settings in Setup.
SQL Server 数据库引擎SQL Server Database Engine /SAPWD/SAPWD

在安装实例的过程中指定了 /SECURITYMODE=SQL 时是必需的。Required when /SECURITYMODE=SQL was specified during Installation of the Instance.
指定 SQL ServerSQL Server SA 帐户的密码。Specifies the password for SQL ServerSQL Server SA account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必需Required
使用此参数可将登录帐户设置为 sysadmin 角色的成员。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

可选Optional
指定 tempdb 数据文件的目录。Specifies the directories for tempdb data files. 指定多个目录时,请用空格将目录隔开。When specifying more than one directory, separate the directories with a blank space. 如果指定了多个目录,则 tempdb 数据文件将以轮循机制的方式分布在目录中。If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。NOTE: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

可选Optional
指定 tempdb 日志文件的目录。Specifies the directory for tempdb log file.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意: 此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILECOUNT/SQLTEMPDBFILECOUNT

可选Optional
指定要由安装程序添加的 tempdb 数据文件的数量。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:

对于 SQL Server ExpressSQL Server Express为 11 for SQL Server ExpressSQL Server Express

8 或内核的数量,对所有其他版本来说都较低8 or the number of cores, whichever is lower for all other editions

重要提示: tempdb 的主数据库文件依然为 tempdb.mdf。Important: The primary database file for tempdb will still be tempdb.mdf. 将其他 tempdb 文件命名为 tempdb_mssql_#.ndf,其中 # 代表在安装期间创建的每个其他 tempdb 数据文件的唯一编号。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. 卸载 SQL ServerSQL Server 的实例会删除具有命名约定 tempdb_mssql_ #.ndf 的文件。Uninstalling an instance of SQL ServerSQL Server deletes the files with naming convention tempdb_mssql_#.ndf. 不要对用户数据库文件使用 tempdb_mssql_*.ndf 命名约定。Do not use tempdb_mssql_*.ndf naming convention for user database files.

警告:SQL Server ExpressSQL Server Express 不支持配置此参数。Warning: SQL Server ExpressSQL Server Express is not supported for configuring this parameter. 安装程序仅安装 1 个 tempdb 数据文件。Setup installs only 1 tempdb data file.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILESIZE/SQLTEMPDBFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 数据文件的初始大小。Specifies the initial size of each tempdb data file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)。Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x).
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILEGROWTH/SQLTEMPDBFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64Default value: 64

允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILESIZE/SQLTEMPDBLOGFILESIZE

可选Optional
指定 tempdb 日志文件的初始大小 (MB)。Specifies the initial size of the tempdb log file in MB. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024. 默认值:Default value:

对于 SQL Server ExpressSQL Server Express为 44 for SQL Server ExpressSQL Server Express

所有其他版本为 88 for all other editions

允许的范围:最小 = 默认值(4 或 8),最大 = 1024Allowed range: Min = default value (4 or 8), Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILEGROWTH/SQLTEMPDBLOGFILEGROWTH

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 日志文件的初始大小。Specifies the initial size of each tempdb log file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)

卸载参数Uninstall Parameters

使用下表中的参数可开发用于卸载的命令行脚本。Use the parameters in the following table to develop command-line scripts for uninstallation.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示卸载工作流。Required to indicate the uninstall work flow.

支持的值: 卸载Supported values: Uninstall
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FEATURES/FEATURES

必需Required
指定要卸载的 组件Specifies components to uninstall.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, H,?/HELP, H,?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
示例语法:Sample Syntax:

卸载现有 SQL Server 实例。To uninstall an existing instance of SQL Server.

setup.exe /Action=Uninstall /FEATURES=SQL,AS,RS,IS,Tools /INSTANCENAME=MSSQLSERVER  

要删除命名实例,请指定实例名称,而不是本文前面提到的示例中的“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

安装 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集实例之前,请先查看以下文章:Before you install a SQL Server 数据库引擎SQL Server Database Engine failover cluster instance, review the following articles:

请根据您所在单位的需要对以下故障转移群集安装脚本进行测试和修改。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.

有关集成安装的详细信息,请参阅AlwaysOn 故障转移群集实例 (SQL Server)For more information about Integrated Installation, see Always On Failover Cluster Instances (SQL Server).

备注

若要在安装完成后添加更多节点,请使用添加节点操作。To add more nodes after the installation, use Add Node action.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 详细信息Details
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示故障转移群集安装工作流:Required to indicate the failover cluster installation work flow.

支持的值:InstallFailoverClusterSupported value: InstallFailoverCluster
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERGROUP/FAILOVERCLUSTERGROUP

可选Optional
指定要用于 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集的资源组的名称。Specifies the name of the resource group to be used for the SQL Server 数据库引擎SQL Server Database Engine 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>)SQL Server (<InstanceName>)
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default), Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL Server 安装程序将获取产品更新的位置。Specify the location where SQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates)或一个 UNC 共享。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL Server 安装程序将通过 Windows Server 更新服务搜索 MicrosoftMicrosoft 更新或 Windows 更新服务。By default, SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FEATURES/FEATURES

必需Required
指定要安装的 组件Specifies components to install.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

可选Optional
为 64 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 64-bit shared components.

默认为 %Program Files%\Microsoft SQL ServerDefault is %Program Files%\Microsoft SQL Server

不能设置为 %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTALLSHAREDWOWDIR/INSTALLSHAREDWOWDIR

可选Optional
为 32 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 32-bit shared components. 仅在 64 位系统上受支持。Supported only on a 64-bit system.

默认为 %Program Files(x86)%\Microsoft SQL ServerDefault is %Program Files(x86)%\Microsoft SQL Server

不能设置为 %Program Files%\Microsoft SQL ServerCannot be set to %Program Files%\Microsoft SQL Server
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control / INSTANCEDIR/INSTANCEDIR

可选Optional
为特定于实例的组件指定一个非默认安装目录。Specifies nondefault installation directory for instance-specific components.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCEID/INSTANCEID

可选Optional
InstanceID指定一个非默认值。Specifies a nondefault value for an InstanceID.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口将隐藏或关闭。Specifies the console window would be hidden or closed.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERDISKS/FAILOVERCLUSTERDISKS

可选Optional
指定要包含在 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集资源组中的共享磁盘的列表。Specifies the list of shared disks to be included in the SQL Server 数据库引擎SQL Server Database Engine failover cluster resource group.

默认值:第一个驱动器用作所有数据库的默认驱动器。Default value: The first drive is used as the default drive for all databases.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必需Required
指定编码的 IP 地址。Specifies an encoded IP address. 编码以分号 (;) 分隔并遵循格式 <IP Type>;<address>;<network name>;<subnet mask>。The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. 支持的 IP 类型包括 DHCP、IPv4 和 IPv6。Supported IP types include DHCP, IPv4, and IPv6.
可以指定多个故障转移群集 IP 地址,地址之间用空格分隔。You can specify multiple failover cluster IP addresses with a space in between. 请看以下示例:See the following examples:

FAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERNETWORKNAME/FAILOVERCLUSTERNETWORKNAME

必需Required
指定新的 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集的网络名称。Specifies the network name for the new SQL Server 数据库引擎SQL Server Database Engine failover cluster. 此名称用于在网络中标识新的 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集实例。This name is used to identify the new SQL Server 数据库引擎SQL Server Database Engine failover cluster instance on the network.
SQL Server 代理SQL Server Agent /AGTSVCACCOUNT/AGTSVCACCOUNT

必需Required
为 SQL Server 代理服务指定帐户。Specifies the account for the SQL Server Agent service.
SQL Server 代理SQL Server Agent /AGTSVCPASSWORD/AGTSVCPASSWORD

必需Required
指定 SQL Server 代理服务帐户的密码。Specifies the password for SQL Server Agent service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Analysis ServicesAnalysis Services /ASBACKUPDIR/ASBACKUPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 备份文件的目录。Specifies the directory for Analysis ServicesAnalysis Services backup files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

可选Optional
指定 Analysis ServicesAnalysis Services的排序规则设置。Specifies the collation setting for Analysis ServicesAnalysis Services.

默认值:Latin1_General_CI_ASDefault value: Latin1_General_CI_AS
Analysis ServicesAnalysis Services /ASCONFIGDIR/ASCONFIGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 配置文件的目录。Specifies the directory for Analysis ServicesAnalysis Services configuration files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config
Analysis ServicesAnalysis Services /ASDATADIR/ASDATADIR

可选Optional
指定 Analysis ServicesAnalysis Services 数据文件的目录。Specifies the directory for Analysis ServicesAnalysis Services data files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data
Analysis ServicesAnalysis Services /ASLOGDIR/ASLOGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 日志文件的目录。Specifies the directory for Analysis ServicesAnalysis Services log files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log
Analysis ServicesAnalysis Services /ASSYSADMINACCOUNTS/ASSYSADMINACCOUNTS

必需Required
指定 Analysis ServicesAnalysis Services的管理员凭据。Specifies the administrator credentials for Analysis ServicesAnalysis Services.
Analysis ServicesAnalysis Services /ASTEMPDIR/ASTEMPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 临时文件的目录。Specifies the directory for Analysis ServicesAnalysis Services temporary files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

可选Optional
指定 MSOLAP 提供程序是否可以在进程中运行。Specifies whether the MSOLAP provider can run in-process.

默认值:1=启用Default value: 1=enabled
Analysis ServicesAnalysis Services /ASSERVERMODE/ASSERVERMODE

可选Optional
指定 Analysis ServicesAnalysis Services 实例的服务器模式。Specifies the server mode of the Analysis ServicesAnalysis Services instance. 群集方案中的有效值为 MULTIDIMENSIONAL 或 TABULAR。Valid values in a cluster scenario are MULTIDIMENSIONAL or TABULAR. ASSERVERMODE 区分大小写。ASSERVERMODE is case-sensitive. 所有值必须以大写形式表示。All values must be expressed in upper case. 有关有效值的详细信息,请参阅“在表格模式下安装 Analysis Services”。For more information about the valid values, see Install Analysis Services in Tabular Mode.
SQL Server 数据库引擎SQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

必需Required
指定 SQL ServerSQL Server 数据文件的数据目录。Specifies the data directory for SQL ServerSQL Server data files.

必须指定数据目录且该目录必须位于共享群集磁盘上。The data directory must be specified and on a shared cluster disk.
SQL Server 数据库引擎SQL Server Database Engine /SAPWD/SAPWD

/SECURITYMODE=SQL 时是必需的Required when /SECURITYMODE=SQL
指定 SQL ServerSQL Server SA 帐户的密码。Specifies the password for the SQL ServerSQL Server SA account.
SQL Server 数据库引擎SQL Server Database Engine /SECURITYMODE/SECURITYMODE

可选Optional
指定 SQL ServerSQL Server 的安全模式。Specifies the security mode for SQL ServerSQL Server.

如果未提供此参数,则支持仅 Windows 身份验证模式。If this parameter is not supplied, then Windows-only authentication mode is supported.

支持的值: SQLSupported value: SQL
SQL Server 数据库引擎SQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

可选Optional
指定备份文件的目录。Specifies the directory for backup files.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\BackupDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup
SQL Server 数据库引擎SQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

可选Optional
指定 SQL ServerSQL Server的排序规则设置。Specifies the collation settings for SQL ServerSQL Server.

默认值基于您的 Windows 操作系统的区域设置。The default value is based on the locale of your Windows operating system. 有关详细信息,请参阅 Collation Settings in Setup(安装程序中的排序规则设置)。For more information, see Collation Settings in Setup.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必需Required
指定 SQL ServerSQL Server 服务的启动帐户。Specifies the startup account for the SQL ServerSQL Server service.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必需Required
指定 SQLSVCACCOUNT 的密码。Specifies the password for SQLSVCACCOUNT. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必需Required
使用此参数可将登录帐户设置为 sysadmin 角色的成员。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

可选Optional
指定用户数据库的数据文件的目录。Specifies the directory for the data files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

可选Optional
指定 tempdb 数据文件的目录。Specifies the directories for tempdb data files. 指定多个目录时,请用空格将目录隔开。When specifying more than one directory, separate the directories with a blank space. 如果指定了多个目录,则 tempdb 数据文件将以轮循机制的方式分布在目录中。If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。NOTE: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

可选Optional
指定 tempdb 日志文件的目录。Specifies the directory for tempdb log file.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILECOUNT/SQLTEMPDBFILECOUNT

可选Optional
指定要由安装程序添加的 tempdb 数据文件的数量。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:

对于 SQL Server ExpressSQL Server Express为 11 for SQL Server ExpressSQL Server Express

8 或内核的数量,对所有其他版本来说都较低8 or the number of cores, whichever is lower for all other editions

重要提示: tempdb 的主数据库文件依然为 tempdb.mdf。Important: The primary database file for tempdb will still be tempdb.mdf. 将其他 tempdb 文件命名为 tempdb_mssql_#.ndf,其中 # 代表在安装期间创建的每个其他 tempdb 数据文件的唯一编号。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. 卸载 SQL Server 的实例将删除具有命名约定 tempdb_mssql_ #.ndf 的文件。Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. 不要对用户数据库文件使用 tempdb_mssql_*.ndf 命名约定。Do not use tempdb_mssql_*.ndf naming convention for user database files.

警告:SQL Server ExpressSQL Server Express 不支持配置此参数。Warning: SQL Server ExpressSQL Server Express is not supported for configuring this parameter. 安装程序仅安装 1 个 tempdb 数据文件。Setup installs only 1 tempdb data file.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILESIZE/SQLTEMPDBFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 数据文件的初始大小。Specifies the initial size of each tempdb data file.

默认值 = 8 MB。Default = 8 MB.

最小值 = 8 MB。Min = 8 MB.

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)。Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x).
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILEGROWTH/SQLTEMPDBFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64Default value: 64

允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILESIZE/SQLTEMPDBLOGFILESIZE

可选Optional
指定 tempdb 日志文件的初始大小 (MB)。Specifies the initial size of the tempdb log file in MB. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.
默认值:Default value:

对于 SQL Server ExpressSQL Server Express为 44 for SQL Server ExpressSQL Server Express

所有其他版本为 88 for all other editions

允许的范围:最小 = 默认值(4 或 8),最大 = 1024Allowed range: Min = default value (4 or 8), Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILEGROWTH/SQLTEMPDBLOGFILEGROWTH

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 日志文件的初始大小。Specifies the initial size of each tempdb log file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

可选Optional
指定用户数据库的日志文件的目录。Specifies the directory for the log files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
FILESTREAMFILESTREAM /FILESTREAMLEVEL/FILESTREAMLEVEL

可选Optional
指定 FILESTREAM 功能的访问级别。Specifies the access level for the FILESTREAM feature. 支持的值:Supported values:

0=禁用此实例的 FILESTREAM 支持。0 =Disable FILESTREAM support for this instance. (默认值)(Default value)

1=针对 Transact-SQLTransact-SQL 访问启用 FILESTREAM。1=Enable FILESTREAM for Transact-SQLTransact-SQL access.

2=针对 Transact-SQLTransact-SQL 和文件 I/O 流访问启用 FILESTREAM。2=Enable FILESTREAM for Transact-SQLTransact-SQL and file I/O streaming access. (对于群集方案无效)(Not valid for cluster scenarios)

3=允许远程客户端针对 FILESTREAM 数据启用流访问。3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAMFILESTREAM /FILESTREAMSHARENAME/FILESTREAMSHARENAME

可选Optional

当 FILESTREAMLEVEL 大于 1 时是必需的。Required when FILESTREAMLEVEL is greater than 1.
指定用来存储 FILESTREAM 数据的 Windows 共享的名称。Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server 全文SQL Server Full Text /FTSVCACCOUNT/FTSVCACCOUNT

可选Optional
指定全文筛选器启动器服务的帐户。Specifies the account for Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. ServiceSID 是用来帮助保护 SQL Server 和全文筛选器后台程序之间的通信。ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon.

如果未提供这些值,则将禁用全文筛选器启动器服务。If the values are not provided the Full-text Filter Launcher Service will be disabled. 您必须使用 SQL Server 控制管理器来更改服务帐户和启用全文功能。You have to use SQL Server Control Manager to change the service account and enable full-text functionality.

默认值:Local Service 帐户Default value: Local Service Account
SQL Server 全文SQL Server Full Text /FTSVCPASSWORD/FTSVCPASSWORD

可选Optional
指定全文筛选器启动器服务的密码。Specifies the password for the Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必需Required
指定 Integration ServicesIntegration Services的帐户。Specifies the account for Integration ServicesIntegration Services.

默认值:NT AUTHORITY\NETWORK SERVICEDefault value: NT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCStartupType/ISSVCStartupType

可选Optional
指定 服务的 启动 Integration ServicesIntegration Services 模式。Specifies the startup mode for the Integration ServicesIntegration Services service.
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的启动帐户。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services 服务的启动帐户密码。Specifies the password for the startup account for Reporting ServicesReporting Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 启动 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual

我们建议你使用服务 SID 来代替域组。We recommend that you use Service SID instead of domain groups.

其他说明:Additional Notes:

数据库引擎Database EngineAnalysis ServicesAnalysis Services 是唯一识别群集的组件。The 数据库引擎Database Engine and Analysis ServicesAnalysis Services are the only components that are cluster-aware. 其他功能不能识别群集,且不具有故障转移的高可用性。Other features are not cluster-aware and do not have high availability through failover.

示例语法:Sample Syntax:

安装具有SQL Server 数据库引擎SQL Server Database Engine数据库引擎Database Engine 的单节点 Analysis ServicesAnalysis Services 故障转移群集实例(默认实例)。To install a single-node SQL Server 数据库引擎SQL Server Database Engine failover cluster instance with the 数据库引擎Database Engine and Analysis ServicesAnalysis Services, default instance.

setup.exe /q /ACTION=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. 有关详细信息,请参阅 AlwaysOn 故障转移群集实例 (SQL Server)For more information, see Always On Failover Cluster Instances (SQL Server).

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示故障转移群集准备工作流。Required to indicate the failover cluster prepare work flow.

支持的值:PrepareFailoverClusterSupported value: PrepareFailoverCluster
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL Server 安装程序将获取产品更新的位置。Specify the location where SQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates 或一个 UNC 共享)。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL ServerSQL Server 安装程序将通过 Windows Server Update Services 搜索 MicrosoftMicrosoft Update 或 Windows Update 服务。By default, SQL ServerSQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FEATURES/FEATURES

必需Required
指定要安装的 组件Specifies components to install.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

可选Optional
为 64 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 64-bit shared components.

默认为 %Program Files%\Microsoft SQL ServerDefault is %Program Files%\Microsoft SQL Server

不能设置为 %Program Files(x86)%\Microsoft SQL ServerCannot be set to %Program Files(x86)%\Microsoft SQL Server
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTALLSHAREDWOWDIR/INSTALLSHAREDWOWDIR

可选Optional
为 32 位共享组件指定一个非默认安装目录。Specifies a nondefault installation directory for 32-bit shared components. 仅在 64 位系统上受支持。Supported only on a 64-bit system.

默认为 %Program Files(x86)%\Microsoft SQL ServerDefault is %Program Files(x86)%\Microsoft SQL Server

不能设置为 %Program Files%\Microsoft SQL ServerCannot be set to %Program Files%\Microsoft SQL Server
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control / INSTANCEDIR/INSTANCEDIR

可选Optional
为特定于实例的组件指定一个非默认安装目录。Specifies nondefault installation directory for instance-specific components.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCEID/INSTANCEID

可选Optional
InstanceID指定一个非默认值。Specifies a nondefault value for an InstanceID.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,If this parameter is not specified,

则使用 Evaluation。Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 代理SQL Server Agent /AGTSVCACCOUNT/AGTSVCACCOUNT

必需Required
为 SQL Server 代理服务指定帐户。Specifies the account for the SQL Server Agent service.
SQL Server 代理SQL Server Agent /AGTSVCPASSWORD/AGTSVCPASSWORD

必需Required
指定 SQL Server 代理服务帐户的密码。Specifies the password for SQL Server Agent service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Analysis ServicesAnalysis Services /ASSVCACCOUNT/ASSVCACCOUNT

必需Required
指定 Analysis ServicesAnalysis Services 服务的帐户。Specifies the account for the Analysis ServicesAnalysis Services service.
Analysis ServicesAnalysis Services /ASSVCPASSWORD/ASSVCPASSWORD

必需Required
指定 Analysis ServicesAnalysis Services 服务的密码。Specifies the password for the Analysis ServicesAnalysis Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必需Required
指定 SQL Server 服务的启动帐户。Specifies the startup account for the SQL Server service.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必需Required
指定 SQLSVCACCOUNT 的密码。Specifies the password for SQLSVCACCOUNT. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
FILESTREAMFILESTREAM /FILESTREAMLEVEL/FILESTREAMLEVEL

可选Optional
指定 FILESTREAM 功能的访问级别。Specifies the access level for the FILESTREAM feature. 支持的值:Supported values:

0=禁用此实例的 FILESTREAM 支持。0 =Disable FILESTREAM support for this instance. (默认值)(Default value)

1=针对 Transact-SQLTransact-SQL 访问启用 FILESTREAM。1=Enable FILESTREAM for Transact-SQLTransact-SQL access.

2=针对 Transact-SQLTransact-SQL 和文件 I/O 流访问启用 FILESTREAM。2=Enable FILESTREAM for Transact-SQLTransact-SQL and file I/O streaming access. (对于群集方案无效)(Not valid for Cluster scenarios)

3=允许远程客户端针对 FILESTREAM 数据启用流访问。3=Allow remote clients to have streaming access to FILESTREAM data.
FILESTREAMFILESTREAM /FILESTREAMSHARENAME/FILESTREAMSHARENAME

可选Optional

当 FILESTREAMLEVEL 大于 1 时是 必需 的。Required when FILESTREAMLEVEL is greater than 1.
指定用来存储 FILESTREAM 数据的 Windows 共享的名称。Specifies the name of the windows share in which the FILESTREAM data will be stored.
SQL Server 全文SQL Server Full Text /FTSVCACCOUNT/FTSVCACCOUNT

可选Optional
指定全文筛选器启动器服务的帐户。Specifies the account for Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. ServiceSID 是用来帮助保护 SQL Server 和全文筛选器后台程序之间的通信。ServiceSID will be used to help secure the communication between SQL Server and Full-text Filter Daemon.

如果未提供这些值,则将禁用全文筛选器启动器服务。If the values are not provided the Full-text Filter Launcher Service will be disabled. 您必须使用 SQL Server 控制管理器来更改服务帐户和启用全文功能。You have to use SQL Server Control Manager to change the service account and enable full-text functionality.

默认值:Local Service 帐户Default value: Local Service Account
SQL Server 全文SQL Server Full Text /FTSVCPASSWORD/FTSVCPASSWORD

可选Optional
指定全文筛选器启动器服务的密码。Specifies the password for the Full-Text filter launcher service.

Windows Server 2008Windows Server 2008 或更高版本中忽略了此参数。This parameter is ignored in Windows Server 2008Windows Server 2008 or higher. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必需Required
指定 Integration ServicesIntegration Services的帐户。Specifies the account for Integration ServicesIntegration Services.

默认值:NT AUTHORITY\NETWORK SERVICEDefault value: NT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCStartupType/ISSVCStartupType

可选Optional
指定 服务的 启动 Integration ServicesIntegration Services 模式。Specifies the startup mode for the Integration ServicesIntegration Services service.
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

仅在“仅文件”模式下可用。Available only on Files only mode.
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的启动帐户。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services 服务的启动帐户密码。Specifies the password for the startup account for Reporting ServicesReporting Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

可选Optional
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 启动 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual

我们建议你使用服务 SID 来代替域组。We recommend that you use Service SID instead of domain groups.

示例语法:Sample Syntax:

针对 数据库引擎Database EngineAnalysis ServicesAnalysis Services执行故障转移群集高级安装方案的“准备”步骤。To perform the "Preparation" step of a failover cluster advanced installation scenario for the 数据库引擎Database Engine and Analysis ServicesAnalysis Services.

在命令提示符下运行以下命令以准备默认实例:Run the following command at the command prompt to prepare a default instance:

setup.exe /q /ACTION=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=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  

完成故障转移群集参数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. 在所有的故障转移群集节点上运行了 prepare 后,在拥有共享磁盘的节点上运行此命令。After you have run prepare on all the failover cluster nodes, you run this command on the node that owns the shared disks. 有关详细信息,请参阅 AlwaysOn 故障转移群集实例 (SQL Server)For more information, see Always On Failover Cluster Instances (SQL Server).

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示故障转移群集完成工作流。Required to indicate the failover cluster complete work flow.

支持的值:CompleteFailoverClusterSupported value: CompleteFailoverCluster
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERGROUP/FAILOVERCLUSTERGROUP

可选Optional
指定要用于 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集的资源组的名称。Specifies the name of the resource group to be used for the SQL Server 数据库引擎SQL Server Database Engine failover cluster. 可以是现有群集组的名称,也可以是新资源组的名称。It can be the name of an existing cluster group or the name of a new resource group.

默认值:Default value:

SQL ServerSQL Server (<InstanceName>)(<InstanceName>)
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL ServerSQL Server 的错误报告。In older versions this specifies the error reporting for SQL ServerSQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅实例配置For more information, see Instance Configuration
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL ServerSQL Server版本的产品密钥。Specifies the product key for the edition of SQL ServerSQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL ServerSQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL ServerSQL Server.

支持的值:Supported values:

1=启用1=enabled

0=禁用0=disabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERDISKS/FAILOVERCLUSTERDISKS

可选Optional
指定要包含在 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集资源组中的共享磁盘的列表。Specifies the list of shared disks to be included in the SQL Server 数据库引擎SQL Server Database Engine failover cluster resource group.

默认值:Default value:

第一个驱动器用作所有数据库的默认驱动器。The first drive is used as the default drive for all databases.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必需Required
指定编码的 IP 地址。Specifies an encoded IP address. 编码以分号 (;) 分隔并遵循格式 <IP Type>;<address>;<network name>;<subnet mask>。The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. 支持的 IP 类型包括 DHCP、IPv4 和 IPv6。Supported IP types include DHCP, IPv4, and IPv6.
可以指定多个故障转移群集 IP 地址,地址之间用空格分隔。You can specify multiple failover cluster IP addresses with a space in between. 请看以下示例:See the following examples:

FAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERNETWORKNAME/FAILOVERCLUSTERNETWORKNAME

必需Required
指定新的 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集的网络名称。Specifies the network name for the new SQL Server 数据库引擎SQL Server Database Engine failover cluster. 此名称用于在网络中标识新的 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集实例。This name is used to identify the new SQL Server 数据库引擎SQL Server Database Engine failover cluster instance on the network.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIRMIPDEPENDENCYCHANGE/CONFIRMIPDEPENDENCYCHANGE 指示对于多子网故障转移群集,同意将 IP 地址资源依赖关系设置为 OR。Indicates the consent to set the IP address resource dependency to OR for multi-subnet failover clusters. 有关详细信息,请参阅创建新的 SQL Server 故障转移群集(安装程序)For more information, see Create a new SQL Server Failover Cluster (Setup). 支持的值:Supported Values:

0 = False(默认值)0 = False (Default)

1 = True1 = True
Analysis ServicesAnalysis Services /ASBACKUPDIR/ASBACKUPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 备份文件的目录。Specifies the directory for Analysis ServicesAnalysis Services backup files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\BackupFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

可选Optional
指定 Analysis ServicesAnalysis Services的排序规则设置。Specifies the collation setting for Analysis ServicesAnalysis Services.

默认值:Latin1_General_CI_ASDefault value: Latin1_General_CI_AS
Analysis ServicesAnalysis Services /ASCONFIGDIR/ASCONFIGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 配置文件的目录。Specifies the directory for Analysis ServicesAnalysis Services configuration files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\ConfigFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config
Analysis ServicesAnalysis Services /ASDATADIR/ASDATADIR

可选Optional
指定 Analysis ServicesAnalysis Services 数据文件的目录。Specifies the directory for Analysis ServicesAnalysis Services data files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\DataFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data
Analysis ServicesAnalysis Services /ASLOGDIR/ASLOGDIR

可选Optional
指定 Analysis ServicesAnalysis Services 日志文件的目录。Specifies the directory for Analysis ServicesAnalysis Services log files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\LogFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log
Analysis ServicesAnalysis Services /ASSERVERMODE/ASSERVERMODE

可选Optional
指定 Analysis Services 实例的服务器模式。Specifies the server mode of the Analysis Services instance. 群集方案中的有效值为 MULTIDIMENSIONAL 或 TABULAR。Valid values in a cluster scenario are MULTIDIMENSIONAL or TABULAR. ASSERVERMODE 区分大小写。ASSERVERMODE is case-sensitive. 所有值必须以大写形式表示。All values must be expressed in upper case. 有关有效值的详细信息,请参阅“在表格模式下安装 Analysis Services”。For more information about the valid values, see Install Analysis Services in Tabular Mode.
Analysis ServicesAnalysis Services /ASSYSADMINACCOUNTS/ASSYSADMINACCOUNTS

必需Required
指定 Analysis ServicesAnalysis Services的管理员凭据。Specifies the administrator credentials for Analysis ServicesAnalysis Services.
Analysis ServicesAnalysis Services /ASTEMPDIR/ASTEMPDIR

可选Optional
指定 Analysis ServicesAnalysis Services 临时文件的目录。Specifies the directory for Analysis ServicesAnalysis Services temporary files. 默认值:Default values:

对于 64 位上的 WOW 模式:%Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor WOW mode on 64-bit: %Program Files(x86)%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp

对于所有其他安装:%Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\TempFor all other installations: %Program Files%\Microsoft SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

可选Optional
指定 MSOLAP 提供程序是否可以在进程中运行。Specifies whether the MSOLAP provider can run in-process.

默认值:1=启用Default value: 1=enabled
SQL Server 数据库引擎SQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

必需Required
指定 SQL ServerSQL Server 数据文件的数据目录。Specifies the data directory for SQL ServerSQL Server data files.

数据目录必须指定且必须位于共享群集磁盘上。The data directory must to specified and on a shared cluster disk.
SQL Server 数据库引擎SQL Server Database Engine /SAPWD/SAPWD

/SECURITYMODE=SQL 时是必需的Required when /SECURITYMODE=SQL
指定 SQL ServerSQL Server SA 帐户的密码。Specifies the password for the SQL ServerSQL Server SA account.
SQL Server 数据库引擎SQL Server Database Engine /SECURITYMODE/SECURITYMODE

可选Optional
指定 SQL ServerSQL Server 的安全模式。Specifies the security mode for SQL ServerSQL Server.

如果未提供此参数,则支持仅 Windows 身份验证模式If this parameter is not supplied, then Windows-only authentication mode is supported

支持的值: SQLSupported value: SQL
SQL Server 数据库引擎SQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

可选Optional
指定备份文件的目录。Specifies the directory for backup files.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\BackupDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Backup
SQL Server 数据库引擎SQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

可选Optional
指定 SQL ServerSQL Server的排序规则设置。Specifies the collation settings for SQL ServerSQL Server.

默认值基于您的 Windows 操作系统的区域设置。The default value is based on the locale of your Windows operating system. 有关详细信息,请参阅 Collation Settings in Setup(安装程序中的排序规则设置)。For more information, see Collation Settings in Setup.
SQL Server 数据库引擎SQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必需Required
使用此参数可将登录帐户设置为 sysadmin 角色的成员。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

可选Optional
指定用户数据库的数据文件的目录。Specifies the directory for the data files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
SQL Server 数据库引擎SQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

可选Optional
指定用户数据库的日志文件的目录。Specifies the directory for the log files for user databases.

默认值:30<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\DataDefault value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

在“仅文件”模式下可用。Available on files only mode.
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

可选Optional
指定 tempdb 数据文件的目录。Specifies the directories for tempdb data files. 指定多个目录时,请用空格将目录隔开。When specifying more than one directory, separate the directories with a blank space. 如果指定了多个目录,则 tempdb 数据文件将以轮循机制的方式分布在目录中。If multiple directories are specified the tempdb data files will be spread across the directories in a round-robin fashion.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。NOTE: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

可选Optional
指定 tempdb 日志文件的目录。Specifies the directory for tempdb log file.

默认值:<InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data(系统数据目录)Default value: <InstallSQLDataDir>\<SQLInstanceID>\MSSQL\Data (System Data Directory)

注意:此参数也被添加到了 RebuildDatabase 方案。Note: This parameter is added to RebuildDatabase scenario as well.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILECOUNT/SQLTEMPDBFILECOUNT

可选Optional
指定要由安装程序添加的 tempdb 数据文件的数量。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:

对于 SQL Server ExpressSQL Server Express为 11 for SQL Server ExpressSQL Server Express

8 或内核的数量,无论哪个对所有其他版本来说较低。8 or the number of cores, whichever is lower for all other editions.

重要提示: tempdb 的主数据库文件依然为 tempdb.mdf。Important: The primary database file for tempdb will still be tempdb.mdf. 将其他 tempdb 文件命名为 tempdb_mssql_#.ndf,其中 # 代表在安装期间创建的每个其他 tempdb 数据文件的唯一编号。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. 卸载 SQL Server 的实例将删除具有命名约定 tempdb_mssql_ #.ndf 的文件。Uninstalling an instance of SQL Server deletes the files with naming convention tempdb_mssql_#.ndf. 不要对用户数据库文件使用 tempdb_mssql_*.ndf 命名约定。Do not use tempdb_mssql_*.ndf naming convention for user database files.

警告:SQL Server ExpressSQL Server Express 不支持配置此参数。Warning: SQL Server ExpressSQL Server Express is not supported for configuring this parameter. 安装程序仅安装 1 个 tempdb 数据文件。Setup installs only 1 tempdb data file.
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILESIZE/SQLTEMPDBFILESIZE

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 数据文件的初始大小。Specifies the initial size of each tempdb data file.

默认值 = 8 MB。Default = 8 MB.

最小值 = 8 MB。Min = 8 MB.

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262144 MB)。Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)).
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBFILEGROWTH/SQLTEMPDBFILEGROWTH

可选Optional
指定每个 tempdb 数据文件的文件增长增量 (MB)。Specifies the file growth increment of each tempdb data file in MB. 值为 0 时表明自动增长被设置为关闭,不允许增加空间。A value of 0 indicates that automatic growth is off and no additional space is allowed. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.

默认值:64Default value: 64

允许的范围:最小值 = 0,最大值 = 1024Allowed range: Min = 0, Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILESIZE/SQLTEMPDBLOGFILESIZE

可选Optional
指定 tempdb 日志文件的初始大小 (MB)。Specifies the initial size of the tempdb log file in MB. 安装程序允许的大小最大为 1024。Setup allows the size up to 1024.
默认值:Default value:

对于 SQL Server ExpressSQL Server Express为 44 for SQL Server ExpressSQL Server Express

所有其他版本为 88 for all other editions

允许的范围:最小 = 默认值(4 或 8),最大 = 1024Allowed range: Min = default value (4 or 8), Max = 1024
SQL Server 数据库引擎SQL Server Database Engine /SQLTEMPDBLOGFILEGROWTH/SQLTEMPDBLOGFILEGROWTH

可选Optional
已在 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中引入。Introduced in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 指定每个 tempdb 日志文件的初始大小。Specifies the initial size of each tempdb log file.

SQL Server ExpressSQL Server Express 的默认值为 4 MB,所有其他版本的默认值为 8 MB。Default = 4 MB for SQL Server ExpressSQL Server Express, 8 MB for all other editions.

最小值 =(4 MB 或 8 MB)。Min = (4 MB or 8 MB).

最大值 = 1024 MB(SQL Server 2014 (12.x)SQL Server 2014 (12.x) 的最大值为 262,144 MB)Max = 1024 MB (262,144 MB for SQL Server 2014 (12.x)SQL Server 2014 (12.x)
示例语法:Sample Syntax:

针对 数据库引擎Database EngineAnalysis ServicesAnalysis Services执行故障转移群集高级安装方案的“完成”步骤。To perform the "Completion" step of a failover cluster advanced installation scenario for the 数据库引擎Database Engine and Analysis ServicesAnalysis Services. 在将成为故障转移群集活动节点的计算机上运行以下命令,以使其可用。Run the following command on the computer that will be the active node in the failover cluster to make it usable. 必须在 Analysis ServicesAnalysis Services 故障转移群集中拥有共享磁盘的节点上运行“CompleteFailoverCluster”操作。You must run the "CompleteFailoverCluster" action on the node that owns the shared disk in the Analysis ServicesAnalysis Services failover cluster.

在命令提示符下运行以下命令以完成默认实例的故障转移群集安装:Run the following command at the command prompt to complete failover cluster installation for a default instance:

setup.exe /q /ACTION=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=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. 有关详细信息,请参阅升级 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集实例(安装程序)Always On 故障转移群集实例 (SQL Server)For more information, see Upgrade a SQL Server 数据库引擎SQL Server Database Engine failover Cluster Instance (Setup) and Always On Failover Cluster Instances (SQL Server).

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示安装工作流。Required to indicate the installation workflow.

支持的值: 升级Supported value: Upgrade
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL Server。Use this parameter to install the English version of SQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL Server 安装程序将获取产品更新的位置。Specify the location where SQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates 或一个 UNC 共享)。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL ServerSQL Server 安装程序将通过 Windows Server Update Services 搜索 MicrosoftMicrosoft Update 或 Windows Update 服务。By default, SQL ServerSQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ERRORREPORTING/ERRORREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

要管理如何将错误反馈发送到 Microsoft,请参阅如何配置 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 以向 Microsoft 发送反馈To manage how error feedback is sent to Microsoft, see How to configure SQL Server 2016 (13.x)SQL Server 2016 (13.x) to send feedback to Microsoft.

在旧版本中,它指定 SQL Server 的错误报告。In older versions this specifies the error reporting for SQL Server.

有关详细信息,请参阅 Privacy Statement for the Microsoft Error Reporting Service(Microsoft 错误报告服务的隐私声明)。For more information, see Privacy Statement for the Microsoft Error Reporting Service. 支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control / INSTANCEDIR/ INSTANCEDIR

可选Optional
为共享组件指定一个非默认安装目录。Specifies a non-default installation directory for shared components.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCEID/INSTANCEID

SQL Server 2008SQL Server 2008 或更高版本升级时是必需的。Required when you upgrade from SQL Server 2008SQL Server 2008 or higher.

SQL Server 2005 (9.x)SQL Server 2005 (9.x) 升级时为可选项Optional when you upgrade from SQL Server 2005 (9.x)SQL Server 2005 (9.x)
InstanceID指定一个非默认值。Specifies a nondefault value for an InstanceID.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /SQMREPORTING/SQMREPORTING

可选Optional
SQL Server 2016 (13.x)SQL Server 2016 (13.x) 中无效。Has no effect in SQL Server 2016 (13.x)SQL Server 2016 (13.x). 在旧版本中,它指定 SQL Server 的功能使用情况报告。In older versions this specifies feature usage reporting for SQL Server.

支持的值:Supported values:

0=禁用0=disabled

1=启用1=enabled
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERROLLOWNERSHIP/FAILOVERCLUSTERROLLOWNERSHIP 指定升级过程中的 故障转移行为Specifies the failover behavior during upgrade.
SQL Server Browser 服务SQL Server Browser Service /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

可选Optional
指定 SQL Server Browser 服务的 启动 模式。Specifies the startup mode for SQL Server Browser service. 支持的值:Supported values:

自动Automatic

已禁用Disabled

手动Manual
SQL Server 全文SQL Server Full-Text /FTUPGRADEOPTION/FTUPGRADEOPTION

可选Optional
指定全文目录升级选项。Specifies the Full-Text catalog upgrade option. 支持的值:Supported values:

REBUILDREBUILD

RESETRESET

IMPORTIMPORT
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必需Required
指定 Integration ServicesIntegration Services的帐户。Specifies the account for Integration ServicesIntegration Services.

默认值:NT AUTHORITY\NETWORK SERVICEDefault value: NT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCStartupType/ISSVCStartupType

可选Optional
指定 服务的 启动 Integration ServicesIntegration Services 模式。Specifies the startup mode for the Integration ServicesIntegration Services service.
Reporting ServicesReporting Services /RSUPGRADEDATABASEACCOUNT/RSUPGRADEDATABASEACCOUNT

可选Optional
仅当升级版本为 2008 R2 或更低版本的 SharePoint 模式报表服务器时才使用此属性。The property is only used when upgrading a SharePoint mode Report Server that is version 2008 R2 or earlier. 对于使用较旧 SharePoint 模式体系结构(在 SQL Server 2012 (11.x)SQL Server 2012 (11.x) Reporting ServicesReporting Services 中已更改)的报表服务器,将执行额外的升级操作。Additional upgrade operations are performed for report servers that use the older SharePoint mode architecture, which was changed in SQL Server 2012 (11.x)SQL Server 2012 (11.x) Reporting ServicesReporting Services. 如果命令行安装中未附随此选项,则使用针对旧报表服务器实例的默认服务帐户。If this option is not included with the command-line installation, the default service account for the old report server instance is used. 如果使用此属性,则使用 /RSUPGRADEPASSWORD 属性提供帐户密码。If this property is used, supply the password for the account using the /RSUPGRADEPASSWORD property.
Reporting ServicesReporting Services /RSUPGRADEPASSWORD/RSUPGRADEPASSWORD

可选Optional
现有 Report Server 服务帐户的密码。Password of the existing Report Server service account.

添加节点参数Add Node Parameters

使用下表中的参数可开发用于 AddNode 的命令行脚本。Use the parameters in the following table to develop command-line scripts for AddNode.

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示 AddNode 工作流。Required to indicate AddNode work flow.

支持的值:AddNodeSupported value: AddNode
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /IACCEPTSQLSERVERLICENSETERMS/IACCEPTSQLSERVERLICENSETERMS

仅在为无人参与安装指定了 /Q 或 /QS 参数时才是必需的。Required only when the /Q or /QS parameter is specified for unattended installations.
必需,用于确认接受许可条款。Required to acknowledge acceptance of the license terms.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ENU/ENU

可选Optional
当安装介质包括针对英文以及与操作系统相对应的语言的语言包时,使用此参数可以在已本地化的操作系统上安装英文版的 SQL ServerSQL ServerUse this parameter to install the English version of SQL ServerSQL Server on a localized operating system when the installation media includes language packs for both English and the language corresponding to the operating system.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateEnabled/UpdateEnabled

可选Optional
指定 SQL ServerSQL Server 安装程序是否应发现和包含产品更新。Specify whether SQL ServerSQL Server setup should discover and include product updates. 有效值为 True 和 False 或 1 和 0。The valid values are True and False or 1 and 0. 默认情况下,SQL Server 安装程序将包含找到的更新。By default, SQL Server setup will include updates that are found.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /UpdateSource/UpdateSource

可选Optional
指定 SQL Server 安装程序将获取产品更新的位置。Specify the location where SQL Server setup will obtain product updates. 有效值为可用于搜索 MicrosoftMicrosoft 更新的“MU”,这是一个有效的文件夹路径、一个相对路径(例如 .\MyUpdates 或一个 UNC 共享)。The valid values are "MU" to search MicrosoftMicrosoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. 默认情况下,SQL ServerSQL Server 安装程序将通过 Windows Server Update Services 搜索 MicrosoftMicrosoft Update 或 Windows Update 服务。By default, SQL ServerSQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
PolyBasePolyBase /PBENGSVCACCOUNT/PBENGSVCACCOUNT

可选Optional
指定引擎服务的帐户。Specifies the account for the engine service. 默认为 NT Authority\NETWORK SERVICEThe default is NT Authority\NETWORK SERVICE .
PolyBasePolyBase /PBDMSSVCPASSWORD/PBDMSSVCPASSWORD

可选Optional
指定引擎服务帐户的密码。Specifies the password for the engine service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
PolyBasePolyBase /PBENGSVCSTARTUPTYPE/PBENGSVCSTARTUPTYPE

可选Optional
指定 PolyBase 引擎服务的启动模式:自动(默认)、禁用和手动。Specifies the startup mode for the PolyBase engine service: Automatic (default) , Disabled, and Manual.
PolyBasePolyBase /PBPORTRANGE/PBPORTRANGE

可选Optional
使用最少 6 个端口为 PolyBase 服务指定端口范围。Specifies a port range with at least 6 ports for PolyBase services. 示例:Example:

/PBPORTRANGE=16450-16460
PolyBasePolyBase /PBSCALEOUT/PBSCALEOUT

可选Optional
指定是否将 SQL Server 数据库引擎SQL Server Database Engine 实例用作 PolyBase 扩展计算组的一部分。Specifies if the SQL Server 数据库引擎SQL Server Database Engine instance will be used as a part of PolyBase Scale-out computational group. 支持的值:True、False Supported values: True , False
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /PID/PID

可选Optional
指定 SQL Server 版本的产品密钥。Specifies the product key for the edition of SQL Server. 如果未指定此参数,则使用 Evaluation。If this parameter is not specified, Evaluation is used.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必需Required
指定编码的 IP 地址。Specifies an encoded IP address. 编码以分号 (;) 分隔并遵循格式 <IP Type>;<address>;<network name>;<subnet mask>。The encodings are semicolon-delimited (;) and follow the format <IP Type>;<address>;<network name>;<subnet mask>. 支持的 IP 类型包括 DHCP、IPv4 和 IPv6。Supported IP types include DHCP, IPv4, and IPv6.
可以指定多个故障转移群集 IP 地址,地址之间用空格分隔。You can specify multiple failover cluster IP addresses with a space in between. 请看以下示例:See the following examples:

FAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1



有关详细信息,请参阅SQL Server 数据库引擎SQL Server Database Engine 故障转移群集中添加或删除节点(安装程序)For more information, see Add or Remove Nodes in a SQL Server 数据库引擎SQL Server Database Engine failover Cluster (Setup).
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIRMIPDEPENDENCYCHANGE/CONFIRMIPDEPENDENCYCHANGE

必需Required
指示对于多子网故障转移群集,同意将 IP 地址资源依赖关系设置为 OR。Indicates the consent to set the IP address resource dependency to OR for multi-subnet failover clusters. 有关详细信息,请参阅SQL Server 数据库引擎SQL Server Database Engine 故障转移群集中添加或删除节点(安装程序)For more information, see Add or Remove Nodes in a SQL Server 数据库引擎SQL Server Database Engine failover Cluster (Setup). 支持的值:Supported values:

0 = False(默认值)0 = False (Default)

1 = True1 = True
SQL Server 代理SQL Server Agent /AGTSVCACCOUNT/AGTSVCACCOUNT

必需Required
为 SQL Server 代理服务指定帐户。Specifies the account for the SQL Server Agent service.
SQL Server 代理SQL Server Agent /AGTSVCPASSWORD/AGTSVCPASSWORD

必需Required
指定 SQL Server 代理服务帐户的密码。Specifies the password for SQL Server Agent service account. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Analysis ServicesAnalysis Services /ASSVCACCOUNT/ASSVCACCOUNT

必需Required
指定 Analysis ServicesAnalysis Services 服务的帐户。Specifies the account for the Analysis ServicesAnalysis Services service.
Analysis ServicesAnalysis Services /ASSVCPASSWORD/ASSVCPASSWORD

必需Required
指定 Analysis ServicesAnalysis Services 服务的密码。Specifies the password for the Analysis ServicesAnalysis Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必需Required
指定 SQL Server 服务的启动帐户。Specifies the startup account for the SQL Server service.
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必需Required
指定 SQLSVCACCOUNT 的密码。Specifies the password for SQLSVCACCOUNT. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必需Required
指定 Integration ServicesIntegration Services 密码。Specifies the Integration ServicesIntegration Services password. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

在“仅文件”模式下可用Available in Files only mode
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services的安装模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必需Required
从 SQL Server 2017 开始不再适用。No longer applicable starting with SQL Server 2017. 指定 Reporting ServicesReporting Services 服务的启动帐户密码。Specifies the startup account password for the Reporting ServicesReporting Services service. 使用托管服务帐户、虚拟帐户或内置帐户时,可以省略此参数。This parameter can be omitted when using a managed service account, virtual account, or built-in account.
其他说明:Additional Notes:

数据库引擎Database EngineAnalysis ServicesAnalysis Services 是唯一识别群集的组件。The 数据库引擎Database Engine and Analysis ServicesAnalysis Services are the only components that are cluster-aware. 其他功能不能识别群集,且不具有故障转移的高可用性。Other features are not cluster-aware and do not have high availability through failover.

示例语法:Sample Syntax:

将节点添加到具有 数据库引擎Database EngineAnalysis ServicesAnalysis Services的现有故障转移群集实例。To add a node to an existing failover cluster instance with the 数据库引擎Database Engine and Analysis ServicesAnalysis Services.

setup.exe /q /ACTION=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

使用下表中的参数可开发用于 RemoveNode 的命令行脚本。Use the parameters in the following table to develop command-line scripts for RemoveNode. 若要卸载故障转移群集,必须在每个故障转移群集节点上运行 RemoveNode。To uninstall a failover cluster, you must run RemoveNode on each failover cluster node. 有关详细信息,请参阅 AlwaysOn 故障转移群集实例 (SQL Server)For more information, see Always On Failover Cluster Instances (SQL Server).

SQL Server 数据库引擎SQL Server Database Engine 组件component 参数Parameter 说明Description
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /ACTION/ACTION

必需Required
需要它来指示 RemoveNode 工作流。Required to indicate RemoveNode work flow.

支持的值:RemoveNodeSupported value: RemoveNode
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

可选Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HELP, ?/HELP, ?

可选Optional
显示这些参数的用法选项。Displays the usage options for the parameters.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

可选Optional
指定应将详细的安装日志文件传送到控制台。Specifies that the verbose Setup log file will be piped to the console.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /INSTANCENAME/INSTANCENAME

必需Required
指定 SQL Server 数据库引擎SQL Server Database Engine 实例名称。Specifies a SQL Server 数据库引擎SQL Server Database Engine instance name.

有关详细信息,请参阅 Instance ConfigurationFor more information, see Instance Configuration.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /Q 或 /QUIET/Q or /QUIET

可选Optional
指定在没有任何用户界面的情况下以静默模式运行安装程序。Specifies that Setup runs in a quiet mode without any user interface. 这适用于无人参与的安装。This is used for unattended installations. /Q 参数会覆盖 /QS 参数的输入。The /Q parameter overrides the input of the /QS parameter.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /QS 或 /QUIETSIMPLE/QS or /QUIETSIMPLE

可选Optional
指定安装程序通过 UI 运行并显示进度,但是不接受任何输入或显示任何错误消息。Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /HIDECONSOLE/HIDECONSOLE

可选Optional
指定控制台窗口隐藏或关闭。Specifies that the console window is hidden or closed.
SQL Server 数据库引擎SQL Server Database Engine 安装程序控件Setup Control /CONFIRMIPDEPENDENCYCHANGE/CONFIRMIPDEPENDENCYCHANGE

必需Required
指示对于多子网故障转移群集,同意将 IP 地址资源依赖关系从 OR 设置为 AND。Indicates the consent to set the IP address resource dependency from OR to AND for multi-subnet failover clusters. 有关详细信息,请参阅SQL Server 数据库引擎SQL Server Database Engine 故障转移群集中添加或删除节点(安装程序)For more information, see Add or Remove Nodes in a SQL Server 数据库引擎SQL Server Database Engine failover Cluster (Setup). 支持的值:Supported values:

0 = False(默认值)0 = False (Default)

1 = True1 = True
示例语法:Sample Syntax:

从具有 数据库引擎Database EngineAnalysis ServicesAnalysis Services的现有故障转移群集实例中删除节点。To remove a node from an existing failover cluster instance with the 数据库引擎Database Engine and Analysis ServicesAnalysis Services.

setup.exe /q /ACTION=RemoveNode /INSTANCENAME="<Insert Instance Name>" [/INDICATEPROGRESS] /CONFIRMIPDEPENDENCYCHANGE=0  

服务帐户参数Service Account Parameters

可以使用内置帐户、本地帐户或域帐户配置 SQL Server 服务。You can configure the SQL Server services by using a built-in account, local account, or domain account.

备注

使用托管服务帐户、虚拟帐户或内置帐户时,不应指定相应的密码参数。When you use a managed service account, virtual account, or a built-in account, you should not specify the corresponding password parameters. 有关这些服务帐户的详细信息,请参阅 配置 Windows 服务帐户和权限中的 可用于 Windows 7Windows 7Windows Server 2008 R2Windows Server 2008 R2 的新帐户类型 部分。For more information about these service accounts, see New Account Types Available with Windows 7Windows 7 and Windows Server 2008 R2Windows Server 2008 R2 section in Configure Windows Service Accounts and Permissions.

有关服务帐户配置的详细信息,请参阅 配置 Windows 服务帐户和权限For more information about service account configuration, see Configure Windows Service Accounts and Permissions.

SQL Server 数据库引擎SQL Server Database Engine 组件component 帐户参数Account parameter 密码参数Password parameter 启动类型Startup type
SQL Server 代理SQL Server Agent /AGTSVCACCOUNT/AGTSVCACCOUNT /AGTSVCPASSWORD/AGTSVCPASSWORD /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE
Analysis ServicesAnalysis Services /ASSVCACCOUNT/ASSVCACCOUNT /ASSVCPASSWORD/ASSVCPASSWORD /ASSVCSTARTUPTYPE/ASSVCSTARTUPTYPE
SQL Server 数据库引擎SQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT /SQLSVCPASSWORD/SQLSVCPASSWORD /SQLSVCSTARTUPTYPE/SQLSVCSTARTUPTYPE
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT /ISSVCPASSWORD/ISSVCPASSWORD /ISSVCStartupType/ISSVCSTARTUPTYPE
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT /RSSVCPASSWORD/RSSVCPASSWORD /RSSVCStartupType/RSSVCSTARTUPTYPE

备注

Reporting Services 功能已从 SQL Server 2017 中删除。Reporting services features were removed from SQL Server 2017. SQL Server Reporting Services 的帐户参数仅适用于 SQL Server 2017 之前的版本。The account parameters for SQL Server Reporting Services are only applicable to versions prior to SQL Server 2017.

功能参数Feature Parameters

若要安装特定功能,请使用 /FEATURES 参数并指定下表中的父功能或功能值:To install specific features, use the /FEATURES parameter and specify the parent feature or feature values in the following table. 有关 SQL Server 各版本支持的功能列表,请参阅 SQL Server 2016 (13.x)SQL Server 2016 (13.x) 的版本和支持的功能。For a list of features that are supported by the editions of SQL Server, see Editions and Supported Features for SQL Server 2016 (13.x)SQL Server 2016 (13.x).

父功能参数Parent feature parameter 功能参数Feature parameter 说明Description
SQLSQL 安装 SQL Server 数据库引擎SQL Server Database Engine、复制、全文组件和 数据质量服务器Data Quality ServerInstalls the SQL Server 数据库引擎SQL Server Database Engine, Replication, Fulltext, and 数据质量服务器Data Quality Server.
SQLEngineSQLEngine 仅安装 SQL Server 数据库引擎SQL Server Database EngineInstalls just the SQL Server 数据库引擎SQL Server Database Engine.
复制Replication 将复制组件与 SQL Server 数据库引擎SQL Server Database Engine一起安装。Installs the Replication component along with SQL Server 数据库引擎SQL Server Database Engine.
FullTextFullText 将全文组件与 SQL Server 数据库引擎SQL Server Database Engine一起安装。Installs the FullText component along with SQL Server 数据库引擎SQL Server Database Engine.
DQDQ 复制完成 数据质量服务器Data Quality Server 安装所需的文件。Copies the files required for completing the 数据质量服务器Data Quality Server installation. 在完成 SQL Server 安装后,必须运行 DQSInstaller.exe 文件来完成 数据质量服务器Data Quality Server 安装。After completing SQL Server installation, you must run the DQSInstaller.exe file to complete the 数据质量服务器Data Quality Server installation. 有关详细信息,请参阅 运行 DQSInstaller.exe 以便完成数据质量服务器安装For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation. 这也将安装 SQL Server 数据库引擎SQL Server Database EngineThis also installs SQL Server 数据库引擎SQL Server Database Engine.
PolyBasePolyBase 安装 PolyBase 组件。Installs PolyBase components.
PolyBaseCorePolyBaseCore 从 SQL Server 2019 开始,与 PolyBase 配对以安装 Polybase 技术,该技术支持使用标准 T-SQL 语句实现跨 Oracle、Teradata、SQL Server 以及其他关系和非关系数据的真正集成查询。Starting with SQL Server 2019, pair with PolyBase to install Polybase technology that enables truly integrated querying across Oracle, Teradata, SQL Server and other relational and non-relational data using standard T-SQL statements.
PolyBaseJavaPolyBaseJava 从 SQL Server 2019 开始,与 PolyBase 配对以安装 PolyBase Java 连接器,该连接器支持使用标准 T-SQL 语句实现对 HDFS 数据的真正集成查询。Starting with SQL Server 2019, pair with PolyBase to install PolyBase Java Connector that enables truly integrated querying across HDFS data using standard T-SQL statements.
AdvancedAnalyticsAdvancedAnalytics 安装 SQL Server 机器学习服务SQL Server 2016 R Services(数据库内)Installs SQL Server Machine Learning Services or SQL Server 2016 R Services (In-Database).
SQL_INST_MRSQL_INST_MR 适用于 SQL Server 机器学习服务Applies to SQL Server Machine Learning Services. 与 AdvancedAnalytics 配对以安装 R Open 和专有 R 包。Pair with AdvancedAnalytics to install R Open and proprietary R packages.
SQL_INST_MPYSQL_INST_MPY 适用于 SQL Server 机器学习服务Applies to SQL Server Machine Learning Services. 与 AdvancedAnalytics 配对以安装 Anaconda 和专有 Python 包。Pair with AdvancedAnalytics to install Anaconda and proprietary Python packages.
SQL_INST_JAVASQL_INST_JAVA 适用于 SQL Server 机器学习服务Applies to SQL Server Machine Learning Services. AdvancedAnalytics 配对以安装扩展,这些扩展支持使用标准 T-SQL 语句实现与 Java 的集成。Pair with AdvancedAnalytics to install extensions that enable integration with Java using standard T-SQL statements.
ASAS 安装所有的 Analysis ServicesAnalysis Services 组件。Installs all Analysis ServicesAnalysis Services components.
RSRS 安装所有的 Reporting ServicesReporting Services 组件。Installs all Reporting ServicesReporting Services components. 从 SQL Server 2017 开始已删除。Removed starting with SQL Server 2017.
RS_SHPRS_SHP 安装用于 SharePoint 的 Reporting ServicesReporting Services 组件。Installs Reporting ServicesReporting Services components for SharePoint. 从 SQL Server 2017 开始已删除。Removed starting with SQL Server 2017.
RS_SHPWFERS_SHPWFE 安装用于 SharePoint 产品的 Reporting ServicesReporting Services 外接程序。Installs Reporting ServicesReporting Services Add-In for SharePoint products. 从 SQL Server 2017 开始已删除。Removed starting with SQL Server 2017.
DQCDQC 安装 数据质量客户端Data Quality ClientInstalls 数据质量客户端Data Quality Client.
ISIS 安装所有的 Integration ServicesIntegration Services 组件。Installs all Integration ServicesIntegration Services components.
IS_MasterIS_Master 包括适用于 Integration Services Scale Out 的 Scale Out 主要角色。Includes Scale Out Master for Integration Services Scale Out.
IS_WorkerIS_Worker 包括适用于 Integration Services Scale Out 的 Scale Out 辅助角色。Includes Scale Out Worker for Integration Services Scale Out.
MDSMDS 安装 Master Data ServicesMaster Data ServicesInstalls Master Data ServicesMaster Data Services.
SQL_SHARED_MPYSQL_SHARED_MPY SQL Server 2017 机器学习服务器(独立版)安装 Python 包Installs Python packages for SQL Server 2017 Machine Learning Server (Standalone)
SQL_SHARED_MRSQL_SHARED_MR SQL Server 2016 R Server(独立版)SQL Server 机器学习服务器(独立版)安装 R 包Installs R packages for SQL Server 2016 R Server (Standalone) or SQL Server Machine Learning Server (Standalone)
工具*Tools* 安装客户端工具和 SQL Server 联机丛书组件。Installs client tools and SQL Server Books Online components.
BCBC 安装向后兼容组件。Installs backward compatibility components.
ConnConn 安装连接组件。Installs connectivity components.
DREPLAY_CTLRDREPLAY_CTLR 安装 Distributed Replay 控制器Installs Distributed Replay controller
DREPLAY_CLTDREPLAY_CLT 安装 Distributed Replay 客户端Installs Distributed Replay client
SNAC_SDKSNAC_SDK 安装用于 MicrosoftMicrosoft SQL Server Native Client 的 SDKInstalls SDK for MicrosoftMicrosoft SQL Server Native Client
SDK 中 IsInRole 中的声明SDK 安装软件开发工具包。Installs the software development kit.
LocalDB**LocalDB** 安装 LocalDB,它是面向程序开发人员的 SQL Server ExpressSQL Server Express 执行模式。Installs LocalDB, an execution mode of SQL Server ExpressSQL Server Express targeted to program developers.

*SQL Server Management StudioSQL Server Management Studio (SSMS) 现在是独立于 SQL Server 2019 (15.x)SQL Server 2019 (15.x) 安装程序的独立安装程序。*SQL Server Management StudioSQL Server Management Studio (SSMS) is now in a stand-alone installer that is separate from the SQL Server 2019 (15.x)SQL Server 2019 (15.x) installer. 有关详细信息,请参阅安装 SQL Server Management StudioFor details, see Install SQL Server Management Studio.

**LocalDB 是安装 SQL Server ExpressSQL Server Express 的任何 SKU 时的一个选项。**LocalDB is an option when installing any SKU of SQL Server ExpressSQL Server Express. 有关详细信息,请参阅 SQL Server 2016 Express LocalDBFor more information, see SQL Server 2016 Express LocalDB.

功能参数示例:Feature parameter examples:

参数和值Parameter and values 说明Description
/FEATURES=SQLEngine/FEATURES=SQLEngine 安装 数据库引擎Database Engine ,不带复制和全文组件。Installs the 数据库引擎Database Engine without replication and full-text.
/FEATURES=SQLEngine,FullText/FEATURES=SQLEngine,FullText 安装 数据库引擎Database Engine 和全文组件。Installs the 数据库引擎Database Engine and full-text.
/FEATURES=SQL,Tools/FEATURES=SQL,Tools 安装完整的 数据库引擎Database Engine 和所有工具。Installs the complete 数据库引擎Database Engine and all tools.
/FEATURES=BOL/FEATURES=BOL 安装 SQL Server 联机丛书组件以便查看和管理帮助内容。Installs SQL Server Books Online components to view and manage help content.
/FEATURES=SQLEngine,PolyBase/FEATURES=SQLEngine,PolyBase 安装 PolyBase 引擎。Installs the PolyBase engine.

角色参数Role Parameters

安装角色或 /Role 参数用于安装预配置的所选功能。The setup role or /Role parameter is used to install a preconfigured selection of features. SSAS 角色在现有 SharePoint 场或未配置的新场中安装 SSAS 实例。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 cannot vary the features and components that are designated for that role. 有关如何使用功能角色参数的详细信息,请参阅 从命令提示符安装 Power PivotFor more information about how to use the feature role parameter, see Install Power Pivot from the Command Prompt.

AllFeatures_WithDefaults 角色是各版本 SQL Server ExpressSQL Server Express 的默认行为,可减少向用户提供的对话框数量。The AllFeatures_WithDefaults role is the default behavior for editions of SQL Server ExpressSQL Server Express and reduces the number of dialog boxes presented to the user. 当安装的 SQL Server 版本不是 SQL Server ExpressSQL Server Express时,可以从命令行指定此角色。It can be specified from the command line when installing a SQL Server edition that is not SQL Server ExpressSQL Server Express.

角色Role 说明Description 安装…Installs...
SPI_AS_ExistingFarmSPI_AS_ExistingFarm Analysis ServicesAnalysis Services 作为 Power PivotPower Pivot 命名实例安装在现有 SharePoint Server 2010SharePoint Server 2010 场或独立服务器上。Installs Analysis ServicesAnalysis Services as a Power PivotPower Pivot named instance on an existing SharePoint Server 2010SharePoint Server 2010 farm or standalone server. Analysis ServicesAnalysis Services 计算引擎,为内存中数据存储和处理而预先配置的。calculation engine, preconfigured for in-memory data storage and processing.

Power PivotPower Pivot 解决方案包solution packages

Power Pivot for ExcelPower Pivot for ExcelInstaller program for the Power Pivot for ExcelPower Pivot for Excel

SQL Server 联机丛书SQL Server Books Online
SPI_AS_NewFarmSPI_AS_NewFarm Analysis ServicesAnalysis Services数据库引擎Database Engine 作为 Power PivotPower Pivot 命名实例安装在新的、未配置的 Office SharePoint Server 2010SharePoint Server 2010 场或独立服务器上。Installs Analysis ServicesAnalysis Services and 数据库引擎Database Engine as a Power PivotPower Pivot named instance on a new, unconfigured Office SharePoint Server 2010SharePoint Server 2010 farm or standalone server. SQL Server 安装程序将在功能角色安装过程中配置场。SQL Server Setup will configure the farm during feature role installation. Analysis ServicesAnalysis Services 计算引擎,为内存中数据存储和处理而预先配置的。calculation engine, preconfigured for in-memory data storage and processing.

Power PivotPower Pivot 解决方案包solution packages

SQL Server 联机丛书SQL Server Books Online

数据库引擎Database Engine

配置工具Configuration Tools

SQL Server Management StudioSQL Server Management Studio
AllFeatures_WithDefaultsAllFeatures_WithDefaults 安装当前版本中提供的所有功能。Installs all features that are available with the current edition.

将当前用户添加到 SQL Server sysadmin 固定服务器角色。Adds the current user to the SQL Server sysadmin fixed server role.

Windows Server 2008Windows Server 2008 或更高版本中,当操作系统不是域控制器时, 数据库引擎Database EngineReporting ServicesReporting Services 默认为使用 NTAUTHORITY\NETWORK SERVICE 帐户,而 Integration ServicesIntegration Services 默认为使用 NTAUTHORITY\NETWORK SERVICE 帐户。On Windows Server 2008Windows Server 2008 or higher and when the operating system is not a domain controller, the 数据库引擎Database Engine, and Reporting ServicesReporting Services are defaulted to use the NTAUTHORITY\NETWORK SERVICE account, and Integration ServicesIntegration Services is defaulted to use the NTAUTHORITY\NETWORK SERVICE account.

默认情况下在 SQL Server ExpressSQL Server Express的版本中启用此角色。This role is enabled by default in editions of SQL Server ExpressSQL Server Express. 对于所有其他版本,不启用此角色,但可以通过 UI 或使用命令行参数指定此角色。For all other editions, this role is not enabled but can be specified through the UI or with command-line parameters.
对于 SQL Server ExpressSQL Server Express的各版本,只安装相应版本中提供的那些功能。For editions of SQL Server ExpressSQL Server Express, installs only those features available in the edition. 对于其他版本,安装所有 SQL ServerSQL Server 功能。For other editions, installs all SQL ServerSQL Server features.

AllFeatures_WithDefaults 参数可以与其他替代 AllFeatures_WithDefaults 参数设置的参数结合使用。The AllFeatures_WithDefaults parameter can be combined with other parameters that override the AllFeatures_WithDefaults parameter settings. 例如,使用 AllFeatures_WithDefaults 参数和 /Features=RS 参数会覆盖用于安装所有功能的命令,而只安装 Reporting ServicesReporting Services,但建议选择 AllFeatures_WithDefaults 参数以便将默认服务帐户用于 Reporting ServicesReporting ServicesFor example, using the AllFeatures_WithDefaults parameter and the /Features=RS parameter overrides the command to install all features and only installs Reporting ServicesReporting Services, but honors the AllFeatures_WithDefaults parameter to use the default service account for Reporting ServicesReporting Services.

当将 AllFeatures_WithDefaults 参数与 /ADDCURRENTUSERASSQLADMIN=FALSE 结合使用时,当前用户不会自动填充设置对话框。When using the AllFeatures_WithDefaults parameter along with the /ADDCURRENTUSERASSQLADMIN=FALSE the provisioning dialog is not auto populated with the current user. 添加 /AGTSVCACCOUNT/AGTSVCPASSWORD ,以便为 SQL Server 代理指定服务帐户和密码。Add /AGTSVCACCOUNT and /AGTSVCPASSWORD to specify a service account and password for the SQL Server Agent.

使用 /FAILOVERCLUSTERROLLOWNERSHIP 参数控制故障转移行为Controlling Failover Behavior using the /FAILOVERCLUSTERROLLOWNERSHIP Parameter

若要将 SQL Server 数据库引擎SQL Server Database Engine 故障转移群集升级到 SQL Server 2019 (15.x)SQL Server 2019 (15.x),则必须从被动节点开始逐个在每个故障转移群集节点上运行安装程序。To upgrade a SQL Server 数据库引擎SQL Server Database Engine failover cluster to SQL Server 2019 (15.x)SQL Server 2019 (15.x), 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.

若要控制升级过程中群集节点的故障转移行为,请从命令提示符运行升级操作,并使用 /FAILOVERCLUSTERROLLOWNERSHIP 参数控制升级操作使节点脱机之前的故障转移行为。To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter to control the failover behavior before the upgrade operation takes the node offline. 此参数的用法如下所示:Use of this parameter is as follows:

  • /FAILOVERCLUSTERROLLOWNERSHIP=0 不会将群集所有权(移动组)滚动到已升级的节点,并且在升级结束时不会将此节点添加到 SQL Server 群集的可能所有者列表中。/FAILOVERCLUSTERROLLOWNERSHIP=0 will not roll cluster ownership (move group) to upgraded nodes, and does not add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.

  • /FAILOVERCLUSTERROLLOWNERSHIP=1 会将群集所有权(移动组)滚动到已升级的节点,并且在升级结束时会将此节点添加到 SQL Server 群集的可能所有者列表中。/FAILOVERCLUSTERROLLOWNERSHIP=1 will roll cluster ownership (move group) to upgraded nodes, and will add this node to the list of possible owners of the SQL Server cluster at the end of upgrade.

  • /FAILOVERCLUSTERROLLOWNERSHIP=2 是默认设置。/FAILOVERCLUSTERROLLOWNERSHIP=2 is the default setting. 如果未指定此参数,将使用该默认设置。It will be used if this parameter is not specified. 此设置指示 SQL Server 安装程序将根据需要管理群集所有权(移动组)。This setting indicates that SQL Server Setup will manage cluster ownership (move group) as needed.

实例 ID 或 InstanceID 配置Instance ID or InstanceID Configuration

实例 ID 或 /InstanceID 参数用于指定实例组件的安装位置以及实例的注册表路径。The Instance ID or /InstanceID parameter is used for specifying where you can install the instance components and the registry path of the instance. INSTANCEID 的值为字符串且必须唯一。The value of INSTANCEID is a string and should be unique.

  • SQL 实例 ID:MSSQLxx.<INSTANCEID>SQL Instance ID: MSSQLxx.<INSTANCEID>

  • AS 实例 ID:MSASxx.<INSTANCEID>AS Instance ID: MSASxx.<INSTANCEID>

  • RS 实例 ID:MSRSxx.<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>

备注

如果在命令行中未指定 INSTANCEID,则默认情况下安装程序用 <INSTANCENAME> 替代 <INSTANCEID>。If INSTANCEID is not specified on the command line, then by default Setup substitute <INSTANCEID> with the <INSTANCENAME>.

另请参阅See Also

使用安装向导安装 SQL Server 2016 Install SQL Server 2016 from the Installation Wizard
SQL Server 故障转移群集安装 SQL Server Failover Cluster Installation
安装 SQL Server 2016 商业智能功能Install SQL Server 2016 Business Intelligence Features