Install SQL Server 2014 from the Command PromptInstall SQL Server 2014 from the Command Prompt

在執行 [SQL Server]SQL Server 安裝程式之前,檢閱規劃 SQL Server 安裝Before you run [SQL Server]SQL Server Setup, review Planning a SQL Server Installation.

在命令提示字元中安裝新的 [SQL Server]SQL Server 執行個體,可讓您指定要安裝的功能以及這些功能應該設定的方式。Installing a new instance of [SQL Server]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.

注意

透過命令提示字元安裝時,[SQL Server]SQL Server 支援使用 /Q 參數的完整無訊息模式或使用 /QS 參數的簡單無訊息模式。When installing through the command prompt, [SQL Server]SQL 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.

除非軟體的使用方式受到個別的合約 (例如 MicrosoftMicrosoft 大量授權合約或與 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 MicrosoftMicrosoft 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 軟體授權合約檢閱授權條款。You can review the license terms separately at Microsoft Software License Terms.

注意

根據您收到本軟體的方式 (例如,透過 MicrosoftMicrosoft 大量授權),軟體的使用方式可能會受到其他條款與條件的限制。Depending on how you received the software (for example, through MicrosoftMicrosoft 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]SQL Server 的執行個體和共用元件。Installing, upgrading, or removing an instance and shared components of [SQL Server]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 Server]SQL Server 版本升級為另一個 [SQL Server]SQL Server版本。Upgrading from one [SQL Server]SQL Server edition to another edition of [SQL Server]SQL Server.

  • 使用組態檔中指定的語法和參數,在本機電腦上安裝 [SQL Server]SQL Server 的執行個體。Installing an instance of [SQL Server]SQL 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.

當您在命令提示字元中安裝 [SQL Server]SQL Server 時,請在命令提示字元的安裝語法中指定要用來安裝的安裝程式參數。When you install [SQL Server]SQL Server at the command prompt, specify Setup parameters for your installation at the command prompt as part of your installation syntax.

注意

如果是本機安裝,您必須以管理員身分執行安裝程式。For local installations, you must run Setup as an administrator. 如果您是從遠端共用位置安裝 [SQL Server]SQL Server,則必須使用對遠端共用位置具有讀取和執行權限的網域帳戶。If you install [SQL Server]SQL 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/PARAMETER

  • /PARAMETER=true/false/PARAMETER=true/false

  • /PARAMETER=1/0 (針對布林類型)/PARAMETER=1/0 for Boolean types

  • /PARAMETER="value" (針對所有單一值參數)。/PARAMETER="value" for all single-value parameters. 建議使用雙引號,不過如果值包含空格就必須使用Using double quotation marks is recommended, but required if the value contains a space

  • /PARAMETER="value1" "value2" "value3" (針對所有多重值參數)。/PARAMETER="value1" "value2" "value3" for all multiple-value parameters. 建議使用雙引號,不過如果值包含空格就必須使用Using double quotation marks is recommended, but required if the value contains a space

例外狀況:Exceptions:

  • /FEATURES,這是多重值參數,不過它的格式為 /FEATURES=AS,RS,IS (不含空格且以逗號隔開/FEATURES, which is a multivalued parameter, but its format is /FEATURES=AS,RS,IS without a space, comma-delimited

範例:Examples:

  • 支援 /INSTANCEDIR=c:\Path。/INSTANCEDIR=c:\Path is supported.

  • 支援支援/INSTANCEDIR = "c:\Path"/INSTANCEDIR="c:\Path" is supported

注意

  • 關聯式伺服器值支援在此路徑中使用其他結束的反斜線格式 (一個反斜線或兩個反斜線字元)。The relational server values support the additional terminating backslash formats (backslash or two backslash characters) for the path.
  • /PID (這個參數的值應該用雙引號括住)。/PID, the value for this parameter should be enclosed in double quotation marks.

[SQL Server]SQL Server 參數Parameters

下列各節會針對安裝、更新和修復狀況提供可開發命令列安裝指令碼的參數。The following sections provide parameters to develop command line installation scripts for install, update, and repair scenarios.

針對 [SQL Server]SQL Server 元件所列出的參數是該元件專用的。Parameters that are listed for a [SQL Server]SQL Server component are specific to that component. [SQL Server]SQL Server Agent 和 [SQL Server]SQL Server Browser 參數是在安裝 SQL Server Database EngineSQL Server Database Engine 時適用。Agent and [SQL Server]SQL Server Browser parameters are applicable when you install the SQL Server Database EngineSQL Server Database Engine.

安裝參數Installation Parameters

您可以使用下表中的參數來開發安裝的命令列指令碼。Use the parameters in the following table to develop command line scripts for installation.

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出安裝工作流程的必要參數。Required to indicate the installation workflow. 支援的值:Supported values:

安裝Install
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /FEATURES/FEATURES

- 或 -- Or -

/ROLE/ROLE

必要項Required
指定要安裝的元件。Specifies the components to install.

選擇 /FEATURES 來指定要安裝的個別 [SQL Server]SQL Server 元件。Choose /FEATURES to specify individual [SQL Server]SQL Server components to install. 如需詳細資訊,請參閱< 功能參數 >。For more information, see Feature Parameters below.

選擇 角色參數 來指定安裝程式角色。Choose Role Parameters to specify a setup role. 安裝程式角色會使用預先決定的組態安裝 [SQL Server]SQL ServerSetup roles install [SQL Server]SQL Server in a predetermined configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示安裝參數的使用方式選項。Displays the usage options for installation parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file is piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

選擇性Optional
指定 64 位元共用元件的非預設安裝目錄。Specifies a nondefault installation directory for 64-bit shared components.

預設值為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL 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)%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/INSTANCEDIR

選擇性Optional
指定執行個體特有元件的非預設安裝目錄。Specifies a nondefault installation directory for instance-specific components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

選擇性Optional
指定 InstanceID的非預設值。Specifies a nondefault value for an InstanceID.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制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 會遭到覆寫。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 Server]SQL Server 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server Agent 服務的帳戶。Specifies the account for the [SQL Server]SQL Server Agent service.
[SQL Server]SQL Server AgentAgent /AGTSVCPASSWORD/AGTSVCPASSWORD

必要項Required
指定 [SQL Server]SQL Server Agent 服務帳戶的密碼。Specifies the password for [SQL Server]SQL Server Agent service account.
[SQL Server]SQL Server AgentAgent /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE

選擇性Optional
指定 Agent 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for the [SQL Server]SQL Server Agent service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

選擇性Optional
指定 Analysis ServicesAnalysis Services的定序設定。Specifies the collation setting for Analysis ServicesAnalysis Services. 預設值︰Default value:

Latin1_General_CI_ASLatin1_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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\log。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\log。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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. 如需有關有效值的詳細資訊,請參閱< Install Analysis Services in Tabular Mode>。For more information about valid values, see Install Analysis Services in Tabular Mode.
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.
Analysis ServicesAnalysis Services /ASSVCSTARTUPTYPE/ASSVCSTARTUPTYPE

選擇性Optional
指定 服務的 啟動 Analysis ServicesAnalysis Services 模式。Specifies the startup mode for the Analysis ServicesAnalysis Services service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
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)%\MicrosoftMicrosoft[SQL Server]SQL Server \< I I>\< A s \olap\temp>D \olap\temp。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server \<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\temp。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

選擇性Optional
指定 MSOLAP 提供者是否可以在處理序中執行。Specifies whether the MSOLAP provider can run in-process. 預設值︰Default value:

1=啟用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 Parameters= SPI_AS_NEWFARM.
Analysis ServicesAnalysis Services /FARMPASSWORD/FARMPASSWORD

SPI_AS_NewFarm 的必要參數Required for SPI_AS_NewFarm
指定伺服陣列帳戶的密碼。Specifies a password for the farm account.
Analysis ServicesAnalysis Services /PASSPHRASE/PASSPHRASE

SPI_AS_NewFarm 的必要參數Required for SPI_AS_NewFarm
指定用來將其他應用程式伺服器或 Web 前端伺服器加入至 SharePoint 伺服陣列的密碼片語。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 Parameters = 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 Parameters = SPI_AS_NEWFARM.
[SQL Server]SQL Server BrowserBrowser /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

選擇性Optional
指定 Browser 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for [SQL Server]SQL Server Browser service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
SQL Server Database EngineSQL Server Database Engine /ENABLERANU/ENABLERANU

選擇性Optional
啟用 SQL Server ExpressSQL Server Express 安裝的執行身分認證。Enables run-as credentials for SQL Server ExpressSQL Server Express installations.
SQL Server Database EngineSQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

選擇性Optional
指定 [SQL Server]SQL Server 資料檔案的資料目錄。Specifies the data directory for [SQL Server]SQL Server data files. 預設值:Default values:

若為64位上的 WOW 模式:% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerFor WOW mode on 64-bit:%Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\

若為所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerFor all other installations:%Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server|
SQL Server Database EngineSQL Server Database Engine /SAPWD/SAPWD

當 /SECURITYMODE=SQL 時則為必要參數Required when /SECURITYMODE=SQL
指定 [SQL Server]SQL Server sa 帳戶的密碼。Specifies the password for the [SQL Server]SQL Serversa account.
SQL Server Database EngineSQL Server Database Engine /SECURITYMODE/SECURITYMODE

選擇性Optional
指定 [SQL Server]SQL Server 的安全性模式。Specifies the security mode for [SQL Server]SQL Server. 如果沒有提供這個參數,就會支援僅限 Windows 驗證模式。If this parameter is not supplied, then Windows-only authentication mode is supported. 支援的值:Supported value:

SQLSQL
SQL Server Database EngineSQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

選擇性Optional
指定備份檔的目錄。Specifies the directory for backup files. 預設值︰Default value:

<安裝 SQL 資料目錄>\ <SQL 執行個體識別碼>\MSSQL\Backup<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup
SQL Server Database EngineSQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

選擇性Optional
指定 [SQL Server]SQL Server的定序設定。Specifies the collation settings for [SQL Server]SQL Server.

預設值會根據您 Windows 作業系統的地區設定而異。The default value is based on the locale of your Windows operating system. 如需詳細資訊,請參閱< 安裝程式中的定序設定>。For more information, see Collation Settings in Setup.
SQL Server Database EngineSQL Server Database Engine /ADDCURRENTUSERASSQLADMIN/ADDCURRENTUSERASSQLADMIN

選擇性Optional
將目前的使用者加入至 [SQL Server]SQL Serversysadmin 固定伺服器角色。Adds the current user to the [SQL Server]SQL Serversysadmin fixed server role. 安裝 Express 版本或使用 /Role=ALLFeatures_WithDefaults is used 時,可以使用 /ADDCURRENTUSERASSQLADMIN 參數。The /ADDCURRENTUSERASSQLADMIN parameter can be used when installing Express editions or when /Role=ALLFeatures_WithDefaults is used. 如需詳細資訊,請參閱下面的/ROLEFor more information, see /ROLE below. /ADDCURRENTUSERASSQLADMIN 的使用是選擇性的,但使用 /ADDCURRENTUSERASSQLADMIN 或 /SQLSYSADMINACCOUNTS 則是必要的。Use of /ADDCURRENTUSERASSQLADMIN is optional, but either /ADDCURRENTUSERASSQLADMIN or /SQLSYSADMINACCOUNTS is required. 預設值:Default values:

適用於 SQL Server ExpressSQL Server Express 版本True for editions of SQL Server ExpressSQL Server Express

不適用於其他所有版本False for all other editions
SQL Server Database EngineSQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server 服務的啟動帳戶。Specifies the startup account for the [SQL Server]SQL Server service.
SQL Server Database EngineSQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必要項Required
指定 SQLSVCACCOUNT 的密碼。Specifies the password for SQLSVCACCOUNT.
SQL Server Database EngineSQL Server Database Engine /SQLSVCSTARTUPTYPE/SQLSVCSTARTUPTYPE

選擇性Optional
指定 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for the [SQL Server]SQL Server service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
SQL Server Database EngineSQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必要項Required
您可以使用這個參數來提供登入,以便成為系統管理員 (sysadmin) 角色的成員。Use this parameter to provision logins to be members of the sysadmin role.

對於 [SQL Server]SQL Server 之外的 SQL Server ExpressSQL Server Express 版本,需要 /SQLSYSADMINACCOUNTS。For [SQL Server]SQL 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 Database EngineSQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

選擇性Optional
指定 tempdb 資料檔的目錄。Specifies the directory for the data files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

選擇性Optional
指定 tempdb 記錄檔的目錄。Specifies the directory for the log files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

選擇性Optional
指定使用者資料庫之資料檔案的目錄。Specifies the directory for the data files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

選擇性Optional
指定使用者資料庫之記錄檔的目錄。Specifies the directory for the log files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<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 資料流存取啟用 FILESTREAM2=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. ServiceSID 是用來協助保護 [SQL Server]SQL Server 與全文檢索篩選背景程式之間的通訊。ServiceSID is used to help secure the communication between [SQL Server]SQL Server and Full-text Filter Daemon. 如果沒有提供這些值,就會停用全文檢索篩選啟動器服務。If the values are not provided, the Full-text Filter Launcher Service is disabled. 您必須使用 [SQL Server]SQL Server 控制管理員來變更服務帳戶並啟用全文檢索功能。You have to use [SQL Server]SQL Server Control Manager to change the service account and enable full-text functionality. 預設值︰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.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必要項Required
指定 Integration ServicesIntegration Services的帳戶。Specifies the account for Integration ServicesIntegration Services. 預設值︰Default value:

NT AUTHORITY\NETWORK SERVICENT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
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]SQL Server 服務的具名管道通訊協定狀態。Specifies the state of the Named Pipes protocol for the [SQL Server]SQL Server service. 支援的值:Supported values:

0=停用具名管道通訊協定0=disable the Named Pipes protocol

1=啟用具名管道通訊協定1=enable the Named Pipes protocol
[SQL Server]SQL Server 網路設定Network Configuration /TCPENABLED/TCPENABLED

選擇性Optional
指定 [SQL Server]SQL Server 服務的 TCP 通訊協定狀態。Specifies the state of the TCP protocol for the [SQL Server]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
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services. 支援的值:Supported Values:

SharePointFilesOnlyModeSharePointFilesOnlyMode

DefaultNativeModeDefaultNativeMode

FilesOnlyModeFilesOnlyMode

注意:如果安裝包含 [SQL Server]SQL Server Database EngineDatabase Engine,則預設 RSINSTALLMODE 為 DefaultNativeMode。Note: If the installation includes the [SQL Server]SQL ServerDatabase EngineDatabase Engine, the default RSINSTALLMODE is DefaultNativeMode.

注意:如果安裝不包含 [SQL Server]SQL ServerDatabase EngineDatabase Engine,則預設 RSINSTALLMODE 為 FilesOnlyMode。If the installation does not include the [SQL Server]SQL ServerDatabase EngineDatabase Engine, the default RSINSTALLMODE is FilesOnlyMode.

如果您選擇 DefaultNativeMode,但是安裝不包含 [SQL Server]SQL ServerDatabase EngineDatabase Engine,則安裝作業會自動將 RSINSTALLMODE 變更為 FilesOnlyMode。If you choose DefaultNativeMode but the installation does not include the [SQL Server]SQL ServerDatabase EngineDatabase Engine, the installation will automatically change the RSINSTALLMODE to FilesOnlyMode.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必要項Required
指定 Reporting ServicesReporting Services 的啟動帳戶。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必要項Required
指定 Reporting ServicesReporting Services 服務之啟動帳戶的密碼。Specifies the password for the startup account for the Reporting ServicesReporting Services service.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

選擇性Optional
指定 啟動 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services.
範例語法:Sample Syntax:

SQL Server Database EngineSQL Server Database Engine、複寫和全文檢索搜尋元件一起安裝新的獨立執行個體。To install a new, stand-alone instance with the SQL Server Database EngineSQL Server Database Engine, Replication, and Full-Text Search components.

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

SysPrep 參數SysPrep Parameters

如需有關 [SQL Server]SQL Server SysPrep 的詳細資訊,請參閱For more information about [SQL Server]SQL Server SysPrep, see

使用 SysPrep 安裝 SQL Server 2014Install SQL Server 2014 Using SysPrep.

準備圖像參數Prepare Image Parameters

使用下表中的參數開發命令列指令碼,以便準備 [SQL Server]SQL Server 的執行個體而不必加以設定。Use the parameters in the following table to develop command-line scripts for preparing an instance of [SQL Server]SQL Server without configuring it.

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出安裝工作流程的必要。支援的值:Required to indicate the installation workflow.Supported values:

PrepareImagePrepareImage
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /FEATURES/FEATURES

必要項Required
指定要安裝的 元件Specifies components to install.

支援的值為 SQLEngine、Replication、FullText、DQ、AS、AS_SPI、RS、RS_SHP、RS_SHPWFE、DQC、SSDTBI、Conn、IS、BC、SDK、BOL、SSMS、Adv_SSMS、DREPLAY_CTLR、DREPLAY_CLT、SNAC_SDK、SQLODBC、SQLODBC_SDK、LocalDB、MDSSupported values are SQLEngine, Replication, FullText, DQ, AS, AS_SPI, RS, RS_SHP, RS_SHPWFE, DQC, SSDTBI, Conn, IS, BC, SDK, BOL, SSMS, Adv_SSMS, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, SQLODBC, SQLODBC_SDK, LocalDB, MDS
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示安裝參數的使用方式選項。Displays the usage options for installation parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file is piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

選擇性Optional
指定 64 位元共用元件的非預設安裝目錄。Specifies a nondefault installation directory for 64-bit shared components.

預設值為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/INSTANCEDIR

選擇性Optional
指定執行個體特有元件的非預設安裝目錄。Specifies a nondefault installation directory for instance-specific components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 (2013 年 1 月) 之前,[必要項]Prior to SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 (January 2013) Required

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 開始,為執行個體功能的 必要項Beginning with SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 Required for instance features.
指定要準備之執行個體的 InstanceID。Specifies an InstanceID for the instance that is being prepared.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 Database EngineSQL Server Database Engine、複寫、全文檢索搜尋元件和 Reporting ServicesReporting Services一起準備新的獨立執行個體。To prepare a new, stand-alone instance with the SQL Server Database EngineSQL 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]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 Server.

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出安裝工作流程的必要參數。Required to indicate the installation workflow. 支援的值:Supported values:

CompleteImageCompleteImage
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示安裝參數的使用方式選項。Displays the usage options for installation parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file is piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 (2013 年 1 月) 之前,[必要項]Prior to SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 (January 2013) Required

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 開始, 選擇性Beginning with SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 Optional
使用準備圖像步驟期間指定的執行個體識別碼。Use the Instance ID specified during the prepare image step. 支援的值:Supported Values:

準備之執行個體的 InstanceID。InstanceID of a Prepared Instance.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 (2013 年 1 月) 之前,[必要項]Prior to SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 (January 2013) Required

SQL Server 2012SQL Server 2012 Service Pack 1 累計更新 2 開始, 選擇性Beginning with SQL Server 2012SQL Server 2012 Service Pack 1 Cumulative Update 2 Optional
指定要完成之執行個體的 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name for the instance that is being completed.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.

注意:如果您要安裝 [SQL Server]SQL Server Express、[SQL Server]SQL Server Express with tools 或 [SQL Server]SQL Server Express with Advanced Services,則會預先定義 PID。Note: If you are installing [SQL Server]SQL Server Express, [SQL Server]SQL Server Express with tools or [SQL Server]SQL Server Express with Advanced Services, the PID is predefined.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server Agent 服務的帳戶。Specifies the account for the [SQL Server]SQL Server Agent service.
[SQL Server]SQL Server AgentAgent /AGTSVCPASSWORD/AGTSVCPASSWORD

必要項Required
指定 [SQL Server]SQL Server Agent 服務帳戶的密碼。Specifies the password for [SQL Server]SQL Server Agent service account.
[SQL Server]SQL Server AgentAgent /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE

選擇性Optional
指定 Agent 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for the [SQL Server]SQL Server Agent service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
[SQL Server]SQL Server BrowserBrowser /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

選擇性Optional
指定 [SQL Server]SQL Server Browser 服務的啟動模式。支援的值:Specifies the startup mode for [SQL Server]SQL Server Browser service.Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
SQL Server Database EngineSQL Server Database Engine /ENABLERANU/ENABLERANU

選擇性Optional
啟用 SQL Server ExpressSQL Server Express 安裝的執行身分認證。Enables run-as credentials for SQL Server ExpressSQL Server Express installations.
SQL Server Database EngineSQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

選擇性Optional
指定 [SQL Server]SQL Server 資料檔案的資料目錄。Specifies the data directory for [SQL Server]SQL Server data files. 預設值:Default values:

若為64位上的 WOW 模式:% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerFor WOW mode on 64-bit:%Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\

若為所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerFor all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server|
SQL Server Database EngineSQL Server Database Engine /SAPWD/SAPWD

當 /SECURITYMODE=SQL 時則為必要參數Required when /SECURITYMODE=SQL
指定 [SQL Server]SQL Server sa 帳戶的密碼。Specifies the password for the [SQL Server]SQL Serversa account.
SQL Server Database EngineSQL Server Database Engine /SECURITYMODE/SECURITYMODE

選擇性Optional
指定 [SQL Server]SQL Server 的安全性模式。Specifies the security mode for [SQL Server]SQL Server. 如果沒有提供這個參數,就會支援僅限 Windows 驗證模式。If this parameter is not supplied, then Windows-only authentication mode is supported. 支援的值:Supported value:

SQLSQL
SQL Server Database EngineSQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

選擇性Optional
指定備份檔的目錄。Specifies the directory for backup files.

預設值︰Default value:

<安裝 SQL 資料目錄>\ <SQL 執行個體識別碼>\MSSQL\Backup<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup
SQL Server Database EngineSQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

選擇性Optional
指定 [SQL Server]SQL Server的定序設定。Specifies the collation settings for [SQL Server]SQL Server.

預設值會根據您 Windows 作業系統的地區設定而異。The default value is based on the locale of your Windows operating system. 如需詳細資訊,請參閱< 安裝程式中的定序設定>。For more information, see Collation Settings in Setup.
SQL Server Database EngineSQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server 服務的啟動帳戶。Specifies the startup account for the [SQL Server]SQL Server service.
SQL Server Database EngineSQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必要項Required
指定 SQLSVCACCOUNT 的密碼。Specifies the password for SQLSVCACCOUNT.
SQL Server Database EngineSQL Server Database Engine /SQLSVCSTARTUPTYPE/SQLSVCSTARTUPTYPE

選擇性Optional
指定 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for the [SQL Server]SQL Server service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
SQL Server Database EngineSQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必要項Required
您可以使用這個參數來提供登入,以便成為系統管理員 (sysadmin) 角色的成員。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

選擇性Optional
指定 tempdb 資料檔的目錄。Specifies the directory for the data files for tempdb.

預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

選擇性Optional
指定 tempdb 記錄檔的目錄。Specifies the directory for the log files for tempdb.

預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

選擇性Optional
指定使用者資料庫之資料檔案的目錄。Specifies the directory for the data files for user databases.

預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

選擇性Optional
指定使用者資料庫之記錄檔的目錄。Specifies the directory for the log files for user databases.

預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<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 資料流存取啟用 FILESTREAM2=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. ServiceSID 是用來協助保護 [SQL Server]SQL Server 與全文檢索篩選背景程式之間的通訊。ServiceSID is used to help secure the communication between [SQL Server]SQL Server and Full-text Filter Daemon. 如果沒有提供這些值,就會停用全文檢索篩選啟動器服務。If the values are not provided, the Full-text Filter Launcher Service is disabled. 您必須使用 [SQL Server]SQL Server 控制管理員來變更服務帳戶並啟用全文檢索功能。You have to use [SQL Server]SQL Server Control Manager to change the service account and enable full-text functionality. 預設值︰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.
[SQL Server]SQL Server 網路設定Network Configuration /NPENABLED/NPENABLED

選擇性Optional
指定 [SQL Server]SQL Server 服務的具名管道通訊協定狀態。Specifies the state of the Named Pipes protocol for the [SQL Server]SQL Server service. 支援的值:Supported values:

0=停用具名管道通訊協定0=disable the Named Pipes protocol

1=啟用具名管道通訊協定1=enable the Named Pipes protocol
[SQL Server]SQL Server 網路設定Network Configuration /TCPENABLED/TCPENABLED

選擇性Optional
指定 [SQL Server]SQL Server 服務的 TCP 通訊協定狀態。Specifies the state of the TCP protocol for the [SQL Server]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
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必要項Required
指定 Reporting ServicesReporting Services 的啟動帳戶。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必要項Required
指定 Reporting ServicesReporting Services 服務之啟動帳戶的密碼。Specifies the password for the startup account for the Reporting ServicesReporting Services service.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

選擇性Optional
指定 啟動 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services.
範例語法:Sample Syntax:

完成準備好並包含 SQL Server Database EngineSQL Server Database Engine、複寫和全文檢索搜尋元件的獨立執行個體。To complete a prepared, stand-alone instance that includes SQL Server Database EngineSQL 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 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出安裝工作流程的必要參數。Required to indicate the installation workflow. 支援的值:Supported values:

UPGRADEUpgrade

EditionUpgradeEditionUpgrade

EditionUpgrade 值是用來將現有的 SQL Server 2014SQL Server 2014 版本升級為不同的版本。The value EditionUpgrade is used to upgrade an existing edition of SQL Server 2014SQL Server 2014 to a different edition. 如需有關支援之版本與版別升級的詳細資訊,請參閱< Supported Version and Edition Upgrades>。For more information about the supported version and edition upgrades, see Supported Version and Edition Upgrades.
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/ INSTANCEDIR

選擇性Optional
指定共用元件的非預設安裝目錄。Specifies a nondefault installation directory for shared components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

當您從 SQL Server 2008SQL Server 2008 或更新版本升級時,此為必要項。Required when you upgrade from SQL Server 2008SQL Server 2008 or later.

當您從 SQL Server 2005SQL Server 2005 升級時為選擇性參數Optional when you upgrade from SQL Server 2005SQL Server 2005
指定 InstanceID的非預設值。Specifies a nondefault value for an InstanceID.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制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 參數使用。The UIMode setting cannot be used with the /Q or /QS parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies the console window would be hidden or closed.
[SQL Server]SQL Server Browser 服務Browser Service /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

選擇性Optional
指定 Browser 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for [SQL Server]SQL Server Browser service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
[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. 預設值︰Default value:

NT AUTHORITY\NETWORK SERVICENT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
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 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 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
現有報表伺服器服務帳戶的密碼。Password of the existing Report Server service 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 升級現有的執行個體或容錯移轉叢集節點To upgrade an existing instance or failover cluster node from a previous [SQL Server]SQL Server 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 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出修復工作流程的必要參數。Required to indicate the repair workflow. 支援的值:Supported values:

RepairRepair
[SQL Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /FEATURES/FEATURES

必要項Required
指定要修復的 元件Specifies components to repair.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制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 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出重建資料庫工作流程的必要參數。Required to indicate the rebuild database workflow. 支援的值:Supported values:

RebuilddatabaseRebuilddatabase
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制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 Database EngineSQL 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. 如需詳細資訊,請參閱< 安裝程式中的定序設定>。For more information, see Collation Settings in Setup.
SQL Server Database EngineSQL Server Database Engine /SAPWD/SAPWD

在執行個體安裝期間指定了 /SECURITYMODE=SQL 時則為必要參數。Required when /SECURITYMODE=SQL was specified during Installation of the Instance.
指定 SQL SA 帳戶的密碼。Specifies the password for SQL SA account.
SQL Server Database EngineSQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必要項Required
您可以使用這個參數來提供登入,以便成為系統管理員 (sysadmin) 角色的成員。Use this parameter to provision logins to be members of the sysadmin role.

解除安裝參數Uninstall Parameters

您可以使用下表中的參數來開發解除安裝的命令列指令碼。Use the parameters in the following table to develop command-line scripts for uninstallation.

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出解除安裝工作流程的必要參數。Required to indicate the uninstall work flow. 支援的值:Supported values:

UninstallUninstall
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /FEATURES/FEATURES

必要項Required
指定要解除安裝的 元件Specifies components to uninstall.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
範例語法:Sample Syntax:

解除安裝現有的 [SQL Server]SQL Server執行個體To uninstall an existing instance of [SQL Server]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 topic.

容錯移轉叢集參數Failover Cluster Parameters

安裝 [SQL Server]SQL Server 容錯移轉叢集執行個體之前,請先檢閱下列主題:Before you install a [SQL Server]SQL Server failover cluster instance, review the following topics:

測試並修改下列容錯移轉叢集安裝指令碼,以便符合組織的需求。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 AlwaysOn Failover Cluster Instances (SQL Server).

注意

若要在安裝之後新增其他節點,請使用新增節點動作。To add more nodes after the installation, use Add Node action.

[SQL Server]SQL Server 元件component 參數Parameter [詳細資料]Details
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出容錯移轉叢集安裝工作流程的必要參數。Required to indicate the failover cluster installation work flow. 支援的值:Supported values:

InstallFailoverClusterInstallFailoverCluster
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /FAILOVERCLUSTERGROUP/FAILOVERCLUSTERGROUP

選擇性Optional
指定要用於 [SQL Server]SQL Server 容錯移轉叢集之資源群組的名稱。Specifies the name of the resource group to be used for the [SQL Server]SQL Server failover cluster. 它可以是現有叢集群組的名稱或新資源群組的名稱。It can be the name of an existing cluster group or the name of a new resource group.

預設值︰Default value:

[SQL Server]SQL Server (<執行個體名稱>)(<InstanceName>)
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server. 如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /FEATURES/FEATURES

必要項Required
指定要安裝的 元件Specifies components to install.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

選擇性Optional
指定 64 位元共用元件的非預設安裝目錄。Specifies a nondefault installation directory for 64-bit shared components.

預設值為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL 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)%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/INSTANCEDIR

選擇性Optional
指定執行個體特有元件的非預設安裝目錄。Specifies nondefault installation directory for instance-specific components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

選擇性Optional
指定 InstanceID的非預設值。Specifies a nondefault value for an InstanceID.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies the console window would be hidden or closed.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERDISKS/FAILOVERCLUSTERDISKS

選擇性Optional
指定要包含在 [SQL Server]SQL Server 容錯移轉叢集資源群組中的共用磁碟清單。Specifies the list of shared disks to be included in the [SQL Server]SQL Server failover cluster resource group.

預設值︰Default value:

第一個磁碟機會當做所有資料庫的預設磁碟機使用。The first drive is used as the default drive for all databases.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必要項Required
指定編碼的 IP 位址。Specifies an encoded IP address. 編碼都以分號分隔 (;) 並遵循以下格式:<IP 類型>;<位址>;<網路名稱>;<子網路遮罩>。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=DEFAULTFAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERNETWORKNAME/FAILOVERCLUSTERNETWORKNAME

必要項Required
針對新的 [SQL Server]SQL Server 容錯移轉叢集指定網路名稱。Specifies the network name for the new [SQL Server]SQL Server failover cluster. 這個名稱是用來在網路上識別新的 [SQL Server]SQL Server 容錯移轉叢集執行個體。This name is used to identify the new [SQL Server]SQL Server failover cluster instance on the network.
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server Agent 服務的帳戶。Specifies the account for the [SQL Server]SQL Server Agent service.
[SQL Server]SQL Server AgentAgent /AGTSVCPASSWORD/AGTSVCPASSWORD

必要項Required
指定 [SQL Server]SQL Server Agent 服務帳戶的密碼。Specifies the password for [SQL Server]SQL Server Agent service 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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For all other installations:%Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

選擇性Optional
指定 Analysis ServicesAnalysis Services的定序設定。Specifies the collation setting for Analysis ServicesAnalysis Services.

預設值︰Default value:

- Latin1_General_CI_AS- 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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\log。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Log.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\log。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\temp。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>D \olap\temp。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

選擇性Optional
指定 MSOLAP 提供者是否可以在處理序中執行。Specifies whether the MSOLAP provider can run in-process. 預設值︰Default value:

1=啟用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 Database EngineSQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

必要項Required
指定 [SQL Server]SQL Server 資料檔案的資料目錄。Specifies the data directory for [SQL Server]SQL Server data files.

您必須指定此資料目錄,而且它必須位於共用叢集磁碟上。The data directory must to specified and on a shared cluster disk.
SQL Server Database EngineSQL Server Database Engine /SAPWD/SAPWD

當 /SECURITYMODE=SQL 時則為必要參數Required when /SECURITYMODE=SQL
指定 [SQL Server]SQL Server sa 帳戶的密碼。Specifies the password for the [SQL Server]SQL Serversa account.
SQL Server Database EngineSQL Server Database Engine /SECURITYMODE/SECURITYMODE

選擇性Optional
指定 [SQL Server]SQL Server 的安全性模式。Specifies the security mode for [SQL Server]SQL Server. 如果沒有提供這個參數,就會支援僅限 Windows 驗證模式。If this parameter is not supplied, then Windows-only authentication mode is supported. 支援的值:Supported value:

SQLSQL
SQL Server Database EngineSQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

選擇性Optional
指定備份檔的目錄。Specifies the directory for backup files. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Backup。<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup.
SQL Server Database EngineSQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

選擇性Optional
指定 [SQL Server]SQL Server的定序設定。Specifies the collation settings for [SQL Server]SQL Server.

預設值會根據您 Windows 作業系統的地區設定而異。The default value is based on the locale of your Windows operating system. 如需詳細資訊,請參閱< 安裝程式中的定序設定>。For more information, see Collation Settings in Setup.
SQL Server Database EngineSQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server 服務的啟動帳戶。Specifies the startup account for the [SQL Server]SQL Server service.
SQL Server Database EngineSQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必要項Required
指定 SQLSVCACCOUNT 的密碼。Specifies the password for SQLSVCACCOUNT.
SQL Server Database EngineSQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必要項Required
您可以使用這個參數來提供登入,以便成為系統管理員 (sysadmin) 角色的成員。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

選擇性Optional
指定 tempdb 資料檔的目錄。Specifies the directory for the data files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

選擇性Optional
指定 tempdb 記錄檔的目錄。Specifies the directory for the log files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

選擇性Optional
指定使用者資料庫之資料檔案的目錄。Specifies the directory for the data files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

選擇性Optional
指定使用者資料庫之記錄檔的目錄。Specifies the directory for the log files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<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 資料流存取啟用 FILESTREAM2=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 時則為必要參數。Requiredwhen 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. ServiceSID 是用來協助保護 [SQL Server]SQL Server 與全文檢索篩選背景程式之間的通訊。ServiceSID will be used to help secure the communication between [SQL Server]SQL Server and Full-text Filter Daemon.

如果沒有提供這些值,就會停用全文檢索篩選啟動器服務。If the values are not provided the Full-text Filter Launcher Service will be disabled. 您必須使用 [SQL Server]SQL Server 控制管理員來變更服務帳戶並啟用全文檢索功能。You have to use [SQL Server]SQL Server Control Manager to change the service account and enable full-text functionality. 預設值︰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.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必要項Required
指定 Integration ServicesIntegration Services的帳戶。Specifies the account for Integration ServicesIntegration Services. 預設值︰Default value:

NT AUTHORITY\NETWORK SERVICENT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
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
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必要項Required
指定 Reporting ServicesReporting Services 的啟動帳戶。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必要項Required
指定 Reporting ServicesReporting Services 服務之啟動帳戶的密碼。Specifies the password for the startup account for Reporting ServicesReporting Services service.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

選擇性Optional
指定 啟動 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services.

1建議您使用服務 SID,而不要使用網域群組。1 We recommend that you use Service SID instead of domain groups.

其他注意事項:Additional Notes:

Database EngineDatabase EngineAnalysis ServicesAnalysis Services 是唯一可感知叢集的元件。The Database EngineDatabase 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 ServerDatabase EngineDatabase Engine 等預設執行個體的單一節點 Analysis ServicesAnalysis Services 容錯移轉叢集執行個體。To install a single-node [SQL Server]SQL Server failover cluster instance with the Database EngineDatabase 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 AlwaysOn Failover Cluster Instances (SQL Server).

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出容錯移轉叢集準備工作流程的必要參數。Required to indicate the failover cluster prepare work flow. 支援的值:Supported values:

PrepareFailoverClusterPrepareFailoverCluster
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /FEATURES/FEATURES

必要項Required
指定要安裝的 元件Specifies components to install.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTALLSHAREDDIR/INSTALLSHAREDDIR

選擇性Optional
指定 64 位元共用元件的非預設安裝目錄。Specifies a nondefault installation directory for 64-bit shared components.

預設值為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files (x86)%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL 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)%\MicrosoftMicrosoft[SQL Server]SQL ServerDefault is %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server

無法設定為% Program Files%\MicrosoftMicrosoft[SQL Server]SQL ServerCannot be set to %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/INSTANCEDIR

選擇性Optional
指定執行個體特有元件的非預設安裝目錄。Specifies nondefault installation directory for instance specific components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

選擇性Optional
指定 InstanceID的非預設值。Specifies a nondefault value for an InstanceID.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 若未指定這個參數,If this parameter is not specified,

會使用 Evaluation。Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server Agent 服務的帳戶。Specifies the account for the [SQL Server]SQL Server Agent service.
[SQL Server]SQL Server AgentAgent /AGTSVCPASSWORD/AGTSVCPASSWORD

必要項Required
指定 [SQL Server]SQL Server Agent 服務帳戶的密碼。Specifies the password for [SQL Server]SQL Server Agent service 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.
SQL Server Database EngineSQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server 服務的啟動帳戶。Specifies the startup account for the [SQL Server]SQL Server service.
SQL Server Database EngineSQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必要項Required
指定 SQLSVCACCOUNT 的密碼。Specifies the password for SQLSVCACCOUNT.
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 資料流存取啟用 FILESTREAM2=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. ServiceSID 是用來協助保護 [SQL Server]SQL Server 與全文檢索篩選背景程式之間的通訊。ServiceSID will be used to help secure the communication between [SQL Server]SQL Server and Full-text Filter Daemon.

如果沒有提供這些值,就會停用全文檢索篩選啟動器服務。If the values are not provided the Full-text Filter Launcher Service will be disabled. 您必須使用 [SQL Server]SQL Server 控制管理員來變更服務帳戶並啟用全文檢索功能。You have to use [SQL Server]SQL Server Control Manager to change the service account and enable full-text functionality. 預設值︰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.
Integration ServicesIntegration Services /ISSVCACCOUNT/ISSVCACCOUNT

必要項Required
指定 Integration ServicesIntegration Services的帳戶。Specifies the account for Integration ServicesIntegration Services. 預設值︰Default value:

NT AUTHORITY\NETWORK SERVICENT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
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.
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCACCOUNT/RSSVCACCOUNT

必要項Required
指定 Reporting ServicesReporting Services 的啟動帳戶。Specifies the startup account for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必要項Required
指定 Reporting ServicesReporting Services 服務之啟動帳戶的密碼。Specifies the password for the startup account for Reporting ServicesReporting Services service.
Reporting ServicesReporting Services /RSSVCStartupType/RSSVCStartupType

選擇性Optional
指定 啟動 Reporting ServicesReporting Services模式。Specifies the startup mode for Reporting ServicesReporting Services.

1建議您使用服務 SID,而不要使用網域群組。1 We recommend that you use Service SID instead of domain groups.

範例語法:Sample Syntax:

執行 Database EngineDatabase EngineAnalysis ServicesAnalysis Services容錯移轉叢集進階安裝狀況的「準備」步驟。To perform the "Preparation" step of a failover cluster advanced installation scenario for the Database EngineDatabase 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. 在所有容錯移轉叢集節點上執行準備作業之後,您就可以在擁有共用磁碟的節點上執行這個命令。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 AlwaysOn Failover Cluster Instances (SQL Server).

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出容錯移轉叢集完成工作流程的必要參數。Required to indicate the failover cluster complete work flow. 支援的值:Supported values:

CompleteFailoverClusterCompleteFailoverCluster
[SQL Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /FAILOVERCLUSTERGROUP/FAILOVERCLUSTERGROUP

選擇性Optional
指定要用於 [SQL Server]SQL Server 容錯移轉叢集之資源群組的名稱。Specifies the name of the resource group to be used for the [SQL Server]SQL Server failover cluster. 它可以是現有叢集群組的名稱或新資源群組的名稱。It can be the name of an existing cluster group or the name of a new resource group.

預設值︰Default value:

[SQL Server]SQL Server (<執行個體名稱>)(<InstanceName>)
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERDISKS/FAILOVERCLUSTERDISKS

選擇性Optional
指定要包含在 [SQL Server]SQL Server 容錯移轉叢集資源群組中的共用磁碟清單。Specifies the list of shared disks to be included in the [SQL Server]SQL Server failover cluster resource group.

預設值︰Default value:

第一個磁碟機會當做所有資料庫的預設磁碟機使用。The first drive is used as the default drive for all databases.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必要項Required
指定編碼的 IP 位址。Specifies an encoded IP address. 編碼都以分號分隔 (;) 並遵循以下格式:<IP 類型>;<位址>;<網路名稱>;<子網路遮罩>。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=DEFAULTFAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERNETWORKNAME/FAILOVERCLUSTERNETWORKNAME

必要項Required
針對新的 [SQL Server]SQL Server 容錯移轉叢集指定網路名稱。Specifies the network name for the new [SQL Server]SQL Server failover cluster. 這個名稱是用來在網路上識別新的 [SQL Server]SQL Server 容錯移轉叢集執行個體。This name is used to identify the new [SQL Server]SQL Server failover cluster instance on the network.
[SQL Server]SQL Server 安裝程式控制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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Backup。For all other installations:%Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Backup.
Analysis ServicesAnalysis Services /ASCOLLATION/ASCOLLATION

選擇性Optional
指定 Analysis ServicesAnalysis Services的定序設定。Specifies the collation setting for Analysis ServicesAnalysis Services. 預設值︰Default value:

Latin1_General_CI_ASLatin1_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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Config.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Config。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\<INSTANCEDIR>\<ASInstanceID>\OLAP\Data.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< I I>\< A s \olap\temp>\OLAP\Data。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\ <I I >\< A s \olap\temp>D \olap\log。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Log.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\ <I I >\< A s \olap\temp>D \olap\log。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]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)%\MicrosoftMicrosoft[SQL Server]SQL Server\ <I I >\< A s \olap\temp>D \olap\temp。For WOW mode on 64-bit: %Program Files(x86)%\MicrosoftMicrosoft[SQL Server]SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.

針對所有其他安裝:% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\ <I I >\< A s \olap\temp>D \olap\temp。For all other installations: %Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\ <INSTANCEDIR>\<ASInstanceID>\OLAP\Temp.
Analysis ServicesAnalysis Services /ASPROVIDERMSOLAP/ASPROVIDERMSOLAP

選擇性Optional
指定 MSOLAP 提供者是否可以在處理序中執行。Specifies whether the MSOLAP provider can run in-process. 預設值︰Default value:

1=啟用1=enabled
SQL Server Database EngineSQL Server Database Engine /INSTALLSQLDATADIR/INSTALLSQLDATADIR

必要項Required
指定 [SQL Server]SQL Server 資料檔案的資料目錄。Specifies the data directory for [SQL Server]SQL Server data files.

您必須指定此資料目錄,而且它必須位於共用叢集磁碟上。The data directory must to specified and on a shared cluster disk.
SQL Server Database EngineSQL Server Database Engine /SAPWD/SAPWD

當 /SECURITYMODE=SQL 時則為必要參數Required when /SECURITYMODE=SQL
指定 [SQL Server]SQL Server sa 帳戶的密碼。Specifies the password for the [SQL Server]SQL Serversa account.
SQL Server Database EngineSQL Server Database Engine /SECURITYMODE/SECURITYMODE

選擇性Optional
指定 [SQL Server]SQL Server 的安全性模式。Specifies the security mode for [SQL Server]SQL Server.

如果沒有提供這個參數,就會支援僅限 Windows 驗證模式。If this parameter is not supplied, then Windows-only authentication mode is supported. 支援的值:Supported values:

SQLSQL
SQL Server Database EngineSQL Server Database Engine /SQLBACKUPDIR/SQLBACKUPDIR

選擇性Optional
指定備份檔的目錄。Specifies the directory for backup files. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Backup。<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Backup.
SQL Server Database EngineSQL Server Database Engine /SQLCOLLATION/SQLCOLLATION

選擇性Optional
指定 [SQL Server]SQL Server的定序設定。Specifies the collation settings for [SQL Server]SQL Server.

預設值會根據您 Windows 作業系統的地區設定而異。The default value is based on the locale of your Windows operating system. 如需詳細資訊,請參閱< 安裝程式中的定序設定>。For more information, see Collation Settings in Setup.
SQL Server Database EngineSQL Server Database Engine /SQLSYSADMINACCOUNTS/SQLSYSADMINACCOUNTS

必要項Required
您可以使用這個參數來提供登入,以便成為系統管理員 (sysadmin) 角色的成員。Use this parameter to provision logins to be members of the sysadmin role.
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBDIR/SQLTEMPDBDIR

選擇性Optional
指定 tempdb 資料檔的目錄。Specifies the directory for the data files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \Mssql\data。<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data.
SQL Server Database EngineSQL Server Database Engine /SQLTEMPDBLOGDIR/SQLTEMPDBLOGDIR

選擇性Optional
指定 tempdb 記錄檔的目錄。Specifies the directory for the l files for tempdb. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBDIR/SQLUSERDBDIR

選擇性Optional
指定使用者資料庫之資料檔案的目錄。Specifies the directory for the data files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
SQL Server Database EngineSQL Server Database Engine /SQLUSERDBLOGDIR/SQLUSERDBLOGDIR

選擇性Optional
指定使用者資料庫之記錄檔的目錄。Specifies the directory for the log files for user databases. 預設值︰Default value:

<安裝 > \ <SQLInstanceID > \MSSQL\Data<InstallSQLDataDir>\ <SQLInstanceID>\MSSQL\Data
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

適用於僅限檔案模式。Available on files only mode.
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services.
範例語法:Sample Syntax:

執行 Database EngineDatabase EngineAnalysis ServicesAnalysis Services容錯移轉叢集進階安裝狀況的「完成」步驟。To perform the "Completion" step of a failover cluster advanced installation scenario for the Database EngineDatabase 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. 如需詳細資訊,請參閱Upgrade a SQL Server 故障(轉移)叢集實例設定AlwaysOn 容錯移轉叢集實例(SQL Server)For more information, see Upgrade a SQL Server Failover Cluster Instance (Setup) and AlwaysOn Failover Cluster Instances (SQL Server).

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出安裝工作流程的必要參數。Required to indicate the installation workflow. 支援的值:Supported values:

UPGRADEUpgrade
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /ERRORREPORTING/ERRORREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的錯誤報告。Specifies the error reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control / INSTANCEDIR/ INSTANCEDIR

選擇性Optional
指定共用元件的非預設安裝目錄。Specifies a nondefault installation directory for shared components.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCEID/INSTANCEID

當您從 SQL Server 2008SQL Server 2008 或更新版本升級時為必要參數。Required when you upgrade from SQL Server 2008SQL Server 2008 or higher.

當您從 SQL Server 2005SQL Server 2005 升級時為選擇性參數Optional when you upgrade from SQL Server 2005SQL Server 2005
指定 InstanceID的非預設值。Specifies a nondefault value for an InstanceID.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /SQMREPORTING/SQMREPORTING

選擇性Optional
指定 [SQL Server]SQL Server的功能使用方式報告。Specifies feature usage reporting for [SQL Server]SQL Server.

如需詳細資訊,請參閱< 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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERROLLOWNERSHIP/FAILOVERCLUSTERROLLOWNERSHIP 指定升級期間的 容錯移轉行為Specifies the failover behavior during upgrade.
[SQL Server]SQL Server Browser 服務Browser Service /BROWSERSVCSTARTUPTYPE/BROWSERSVCSTARTUPTYPE

選擇性Optional
指定 Browser 服務的 啟動 [SQL Server]SQL Server 模式。Specifies the startup mode for [SQL Server]SQL Server Browser service. 支援的值:Supported values:

AutomaticAutomatic

DisabledDisabled

ManualManual
[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. 預設值︰Default value:

NT AUTHORITY\NETWORK SERVICENT AUTHORITY\NETWORK SERVICE
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
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 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 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
現有報表伺服器服務帳戶的密碼。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 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出 AddNode 工作流程的必要參數。Required to indicate AddNode work flow. 支援的值:Supported value:

AddNodeAddNode
[SQL Server]SQL 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 Server]SQL Server 安裝程式控制Setup Control /ENU/ENU

選擇性Optional
當安裝媒體包含英文以及與作業系統對應之語言的語言套件時,使用此參數在當地語系化的作業系統上安裝英文版的 [SQL Server]SQL ServerUse this parameter to install the English version of [SQL Server]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 安裝程式控制Setup Control /UpdateEnabled/UpdateEnabled

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式是否應該探索及包含產品更新。Specify whether [SQL Server]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]SQL Server 安裝程式會包含找到的更新。By default, [SQL Server]SQL Server setup will include updates that are found.
[SQL Server]SQL Server 安裝程式控制Setup Control /UpdateSource/UpdateSource

選擇性Optional
指定 [SQL Server]SQL Server 安裝程式將取得產品更新的位置。Specify the location where [SQL Server]SQL Server setup will obtain product updates. 有效值為 "MU",表示搜尋 MicrosoftMicrosoft 更新、有效資料夾路徑、相對路徑 (例如 .\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]SQL Server 安裝程式會搜尋 MicrosoftMicrosoft Update 或透過 Windows Server Update Services 搜尋 Windows Update Service。By default, [SQL Server]SQL Server setup will search MicrosoftMicrosoft Update or a Windows Update Service through the Windows Server Update Services.
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制Setup Control /PID/PID

選擇性Optional
指定 [SQL Server]SQL Server版的產品金鑰。Specifies the product key for the edition of [SQL Server]SQL Server. 如果沒有指定這個參數,就會使用 Evaluation。If this parameter is not specified, Evaluation is used.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server 安裝程式控制Setup Control /FAILOVERCLUSTERIPADDRESSES/FAILOVERCLUSTERIPADDRESSES

必要項Required
指定編碼的 IP 位址。Specifies an encoded IP address. 編碼都以分號分隔 (;) 並遵循以下格式:<IP 類型>;<位址>;<網路名稱>;<子網路遮罩>。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=DEFAULTFAILOVERCLUSTERIPADDRESSES=DEFAULT

FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv4;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255FAILOVERCLUSTERIPADDRESSES=IPv4;172.16.0.0;ClusterNetwork1;172.31.255.255

FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;DHCP;ClusterNetwork1

FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1FAILOVERCLUSTERIPADDRESSES=IPv6;2001:db8:23:1002:20f:1fff:feff:b3a3;ClusterNetwork1



如需詳細資訊,請參閱在 SQL Server 容錯移轉叢集中加入或移除節點 (Setup)For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup).
[SQL Server]SQL Server 安裝程式控制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 容錯移轉叢集中加入或移除節點 (Setup)For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup). 支援的值:Supported values:

0 = False (預設值)0 = False (Default)

1 = True1 = True
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server Agent 服務的帳戶。Specifies the account for the [SQL Server]SQL Server Agent service.
[SQL Server]SQL Server AgentAgent /AGTSVCPASSWORD/AGTSVCPASSWORD

必要項Required
指定 [SQL Server]SQL Server Agent 服務帳戶的密碼。Specifies the password for [SQL Server]SQL Server Agent service 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.
SQL Server Database EngineSQL Server Database Engine /SQLSVCACCOUNT/SQLSVCACCOUNT

必要項Required
指定 [SQL Server]SQL Server 服務的啟動帳戶。Specifies the startup account for the [SQL Server]SQL Server service.
SQL Server Database EngineSQL Server Database Engine /SQLSVCPASSWORD/SQLSVCPASSWORD

必要項Required
指定 SQLSVCACCOUNT 的密碼。Specifies the password for SQLSVCACCOUNT.
Integration ServicesIntegration Services /ISSVCPASSWORD/ISSVCPASSWORD

必要項Required
指定 Integration ServicesIntegration Services 密碼。Specifies the Integration ServicesIntegration Services password.
Reporting ServicesReporting Services /RSINSTALLMODE/RSINSTALLMODE

適用於僅限檔案模式Available in Files only mode
指定 Reporting ServicesReporting Services 的安裝模式。Specifies the Install mode for Reporting ServicesReporting Services.
Reporting ServicesReporting Services /RSSVCPASSWORD/RSSVCPASSWORD

必要項Required
指定 Reporting ServicesReporting Services 服務的啟動帳戶密碼。Specifies the startup account password for the Reporting ServicesReporting Services service.
其他注意事項:Additional Notes:

Database EngineDatabase EngineAnalysis ServicesAnalysis Services 是唯一可感知叢集的元件。The Database EngineDatabase 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 EngineDatabase EngineAnalysis ServicesAnalysis Services的現有容錯移轉叢集執行個體。To add a node to an existing failover cluster instance with the Database EngineDatabase 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

您可以使用下表中的參數來開發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 AlwaysOn Failover Cluster Instances (SQL Server).

[SQL Server]SQL Server 元件component 參數Parameter [描述]Description
[SQL Server]SQL Server 安裝程式控制Setup Control /ACTION/ACTION

必要項Required
指出 RemoveNode 工作流程的必要參數。Required to indicate RemoveNode work flow. 支援的值:Supported value:

RemoveNodeRemoveNode
[SQL Server]SQL Server 安裝程式控制Setup Control /CONFIGURATIONFILE/CONFIGURATIONFILE

選擇性Optional
指定要使用的 ConfigurationFileSpecifies the ConfigurationFile to use.
[SQL Server]SQL Server 安裝程式控制Setup Control /HELP、H、?/HELP, H, ?

選擇性Optional
顯示參數的使用方式選項。Displays the usage options for the parameters.
[SQL Server]SQL Server 安裝程式控制Setup Control /INDICATEPROGRESS/INDICATEPROGRESS

選擇性Optional
指定要將詳細安裝程式記錄檔送到主控台。Specifies that the verbose Setup log file will be piped to the console.
[SQL Server]SQL Server 安裝程式控制Setup Control /INSTANCENAME/INSTANCENAME

必要項Required
指定 [SQL Server]SQL Server 執行個體名稱。Specifies a [SQL Server]SQL Server instance name.

如需詳細資訊,請參閱< Instance Configuration>。For more information, see Instance Configuration.
[SQL Server]SQL Server 安裝程式控制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 安裝程式控制Setup Control /QS/QS

選擇性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 安裝程式控制Setup Control /HIDECONSOLE/HIDECONSOLE

選擇性Optional
指定要隱藏或關閉主控台視窗。Specifies that the console window is hidden or closed.
[SQL Server]SQL Server 安裝程式控制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 容錯移轉叢集中加入或移除節點 (Setup)For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup). 支援的值:Supported values:

0 = False (預設值)0 = False (Default)

1 = True1 = True
範例語法:Sample Syntax:

叢具有 Database EngineDatabase EngineAnalysis ServicesAnalysis Services的現有容錯移轉叢集執行個體移除節點。To remove a node from an existing failover cluster instance with the Database EngineDatabase Engine and Analysis ServicesAnalysis Services.

setup.exe /q /ACTION=RemoveNode /INSTANCENAME="<Insert Instance Name>" [/INDICATEPROGRESS] /CONFIRMIPDEPENDENCYCHANGE=0  

服務帳戶參數Service Account Parameters

您可以使用內建帳戶、本機帳戶或網域帳戶來設定 [SQL Server]SQL Server 服務。You can configure the [SQL Server]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 元件component 帳戶參數Account parameter 密碼參數Password parameter 啟動類型Startup type
[SQL Server]SQL Server AgentAgent /AGTSVCACCOUNT/AGTSVCACCOUNT /AGTSVCPASSWORD/AGTSVCPASSWORD /AGTSVCSTARTUPTYPE/AGTSVCSTARTUPTYPE
Analysis ServicesAnalysis Services /ASSVCACCOUNT/ASSVCACCOUNT /ASSVCPASSWORD/ASSVCPASSWORD /ASSVCSTARTUPTYPE/ASSVCSTARTUPTYPE
SQL Server Database EngineSQL 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

功能參數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版本所支援的功能清單,請參閱SQL Server 2014 版本支援的功能For a list of features that are supported by the editions of [SQL Server]SQL Server, see Features Supported by the Editions of SQL Server 2014.

父功能參數Parent feature parameter 功能參數Feature parameter [描述]Description
SQLSQL 安裝 SQL Server Database EngineSQL Server Database Engine、複寫、全文檢索和 Data Quality ServerData Quality ServerInstalls the SQL Server Database EngineSQL Server Database Engine, Replication, Fulltext, and Data Quality ServerData Quality Server.
SQLEngineSQLEngine 只安裝 SQL Server Database EngineSQL Server Database EngineInstalls just the SQL Server Database EngineSQL Server Database Engine.
複寫Replication 安裝 SQL Server Database EngineSQL Server Database Engine時一併安裝複寫元件。Installs the Replication component along with SQL Server Database EngineSQL Server Database Engine.
FullTextFullText 安裝 SQL Server Database EngineSQL Server Database Engine時一併安裝全文檢索元件。Installs the FullText component along with SQL Server Database EngineSQL Server Database Engine.
DQDQ 複製完成 Data Quality ServerData Quality Server 安裝所需的檔案。Copies the files required for completing the Data Quality ServerData Quality Server installation. 在完成 [SQL Server]SQL Server 安裝之後,您必須執行 DQSInstaller.exe 來完成 Data Quality ServerData Quality Server 安裝。After completing [SQL Server]SQL Server installation, you must run the DQSInstaller.exe file to complete the Data Quality ServerData Quality Server installation. 如需詳細資訊,請參閱 執行 DQSInstaller.exe 完成 Data Quality Server 安裝For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation. 這樣也會安裝 SQL Server Database EngineSQL Server Database EngineThis also installs SQL Server Database EngineSQL Server Database Engine.
ASAS 安裝所有 Analysis ServicesAnalysis Services 元件。Installs all Analysis ServicesAnalysis Services components.
RSRS 安裝所有 Reporting ServicesReporting Services 元件。Installs all Reporting ServicesReporting Services components.
DQCDQC 安裝 Data Quality ClientData Quality ClientInstalls Data Quality ClientData Quality Client.
ISIS 安裝所有 Integration ServicesIntegration Services 元件。Installs all Integration ServicesIntegration Services components.
MDSMDS 安裝 Master Data ServicesMaster Data ServicesInstalls Master Data ServicesMaster Data Services.
工具Tools 安裝用戶端工具和《 [SQL Server]SQL Server 線上叢書》元件。Installs client tools and [SQL Server]SQL Server Books Online components.
BCBC 安裝回溯相容性元件。Installs backward compatibility components.
BOLBOL 安裝《 [SQL Server]SQL Server 線上叢書》元件,以檢視並管理說明內容。Installs [SQL Server]SQL Server Books Online components to view and manage help content.
ConnConn 安裝連接元件。Installs connectivity components.
SSMSSSMS 安裝 [SQL Server]SQL Server 管理工具-基本。Installs [SQL Server]SQL Server Management Tools - Basic. 這包括下列項目:This includes the following:

Transact-SQLSQL Server Management Studio SQL Server Database EngineSQL Server Database EngineSQL Server ExpressSQL Server Expresssqlcmd公用程式和 [SQL Server]SQL Server PowerShell 提供者的支援support for the SQL Server Database EngineSQL Server Database Engine, SQL Server ExpressSQL Server Express, sqlcmd utility, and the [SQL Server]SQL Server PowerShell provider
ADV_SSMSADV_SSMS 安裝 [SQL Server]SQL Server 管理工具-完成。Installs [SQL Server]SQL Server Management Tools - Complete. 除了基本版的元件以外,還包括下列元件:This includes the following components in addition to the components in the Basic version:

Transact-SQLSQL Server Management StudioReporting ServicesReporting ServicesAnalysis ServicesAnalysis ServicesIntegration ServicesIntegration Services 支援support for Reporting ServicesReporting Services, Analysis ServicesAnalysis Services, and Integration ServicesIntegration Services

SQL Server ProfilerSQL Server Profiler

Database EngineDatabase Engine Tuning AdvisorTuning Advisor

[SQL Server]SQL Server 公用程式管理Utility management
DREPLAY_CTLRDREPLAY_CTLR 安裝 Distributed Replay ControllerInstalls Distributed Replay controller
DREPLAY_CLTDREPLAY_CLT 安裝 Distributed Replay ClientInstalls Distributed Replay client
SNAC_SDKSNAC_SDK 安裝適用于 MicrosoftMicrosoft[SQL Server]SQL Server Native Client 的 SDKInstalls SDK for MicrosoftMicrosoft[SQL Server]SQL Server Native Client
SDKSDK 安裝軟體開發套件。Installs the software development kit.
LocalDB1LocalDB1 安裝 LocalDB,這是專供程式開發人員使用的 SQL Server ExpressSQL Server Express 執行模式。Installs LocalDB, an execution mode of SQL Server ExpressSQL Server Express targeted to program developers.

1 LocalDB 是安裝 SQL Server 2014SQL Server 2014 Express 的任何 SKU 時的選項。1 LocalDB is an option when installing any SKU of SQL Server 2014SQL Server 2014 Express. 如需詳細資訊,請參閱SQL Server 2014 Express LocalDBFor more information, see SQL Server 2014 Express LocalDB.

功能參數範例:Feature parameter examples:

參數和值Parameter and values [描述]Description
/FEATURES=SQLEngine/FEATURES=SQLEngine 安裝不含複寫和全文檢索的 Database EngineDatabase EngineInstalls the Database EngineDatabase Engine without replication and full-text.
/FEATURES=SQLEngine, FullText/FEATURES=SQLEngine, FullText 安裝 Database EngineDatabase Engine 和全文檢索。Installs the Database EngineDatabase Engine and full-text.
/FEATURES=SQL, Tools/FEATURES=SQL, Tools 安裝完整的 Database EngineDatabase Engine 和所有工具。Installs the complete Database EngineDatabase Engine and all tools.
/FEATURES=BOL/FEATURES=BOL 安裝《 [SQL Server]SQL Server 線上叢書》元件,以檢視並管理說明內容。Installs [SQL Server]SQL Server Books Online components to view and manage help content.

角色參數Role Parameters

安裝程式角色或 /Role 參數是用來安裝預先設定的功能選項。The setup role or /Role parameter is used to install a preconfigured selection of features. Analysis ServicesAnalysis Services 角色會在現有的 SharePoint 伺服陣列或未設定的新伺服陣列中安裝 Analysis ServicesAnalysis Services 執行個體。The Analysis ServicesAnalysis Services roles install an Analysis ServicesAnalysis Services instance in either an existing SharePoint farm, or a new un-configured farm. 為支援每個狀況,提供兩個安裝程式角色。Two setup roles are provided to support each scenario. 您一次只能選擇一個要安裝的安裝程式角色。You can only choose one setup role to install at a time. 如果您選擇安裝程式角色,安裝程式會安裝屬於該角色的功能與元件。If you choose a setup role, Setup installs the features and components that belong to the role. 您無法改變為該角色所指定的功能與元件。You cannot vary the features and components that are designated for that role. 如需如何使用功能角色參數的詳細資訊,請參閱從命令提示字元安裝 PowerPivotFor more information about how to use the feature role parameter, see Install PowerPivot 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 ServerSQL Server ExpressSQL Server Express 版本時,可以從命令列指定該角色。It can be specified from the command line when installing a [SQL Server]SQL Server edition that is not SQL Server ExpressSQL Server Express.

角色Role [描述]Description 安裝...Installs...
SPI_AS_ExistingFarmSPI_AS_ExistingFarm 在現有的 Analysis ServicesAnalysis Services 伺服陣列或獨立伺服器上,將 PowerPivotPowerPivot 安裝為 SharePoint Server 2010SharePoint Server 2010 具名執行個體。Installs Analysis ServicesAnalysis Services as a PowerPivotPowerPivot 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.

PowerPivotPowerPivot 方案套件solution packages

PowerPivot for ExcelPowerPivot for Excel 的安裝程式Installer program for the PowerPivot for ExcelPowerPivot for Excel

[SQL Server]SQL Server 線上叢書Books Online
SPI_AS_NewFarmSPI_AS_NewFarm 在全新且未設定的 Office Analysis ServicesAnalysis Services 伺服陣列或獨立伺服器上,將 Database EngineDatabase EnginePowerPivotPowerPivot 安裝為 SharePoint Server 2010SharePoint Server 2010 具名執行個體。Installs Analysis ServicesAnalysis Services and Database EngineDatabase Engine as a PowerPivotPowerPivot named instance on a new, un-configured 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.

PowerPivotPowerPivot 方案套件solution packages

[SQL Server]SQL Server 線上叢書Books Online

Database EngineDatabase Engine

組態工具Configuration Tools

Transact-SQLSQL Server Management Studio
AllFeatures_WithDefaultsAllFeatures_WithDefaults 安裝適用於目前版本的所有功能。Installs all features that are available with the current edition.

將目前的使用者加入至 [SQL Server]SQL Server sysadmin 固定伺服器角色。Adds the current user to the [SQL Server]SQL Server sysadmin fixed server role.

Windows Server 2008Windows Server 2008 或更新版本上,以及當作業系統不是網域控制站時, Database EngineDatabase 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 EngineDatabase 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 Server]SQL Server 功能。For other editions, installs all [SQL Server]SQL Server features.

AllFeatures_WithDefaults 參數可以結合會覆寫 AllFeatures_WithDefaults 參數設定的其他參數。The AllFeatures_WithDefaults parameter can be combined with other parameters which override the AllFeatures_WithDefaults parameter settings. 例如,使用 AllFeatures_WithDefaults 參數與 /Features=RS 參數會覆寫安裝所有功能的命令,而僅安裝 Reporting ServicesReporting Services,但接受 AllFeatures_WithDefaults 參數則會使用 Reporting ServicesReporting Services的預設服務帳戶。For 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]SQL Server 代理程式的服務帳戶與密碼。Add /AGTSVCACCOUNT and /AGTSVCPASSWORD to specify a service account and password for the [SQL Server]SQL Server Agent.

使用 /FAILOVERCLUSTERROLLOWNERSHIP 參數來控制容錯移轉行為Controlling Failover Behavior using the /FAILOVERCLUSTERROLLOWNERSHIP Parameter

若要將 [SQL Server]SQL Server 容錯移轉叢集升級為 SQL Server 2014SQL Server 2014,您必須在容錯移轉叢集節點上執行安裝程式 (從被動節點開始,一次一個)。To upgrade a [SQL Server]SQL Server failover cluster to SQL Server 2014SQL Server 2014, 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]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]SQL Server cluster at the end of upgrade.

  • /FAILOVERCLUSTERROLLOWNERSHIP=1 會將叢集擁有權 (移動群組) 轉交給升級的節點,而且在升級結束時,會將這個節點加入至 [SQL Server]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]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]SQL Server 安裝程式將會視需要管理叢集擁有權 (移動群組)。This setting indicates that [SQL Server]SQL Server Setup will manage cluster ownership (move group) as needed.

執行個體識別碼或 InstanceID 組態Instance ID or InstanceID Configuration

執行個體識別碼或 /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 實例識別碼: MSSQL12.CONTOSO。<INSTANCEID >SQL Instance ID:MSSQL12.<INSTANCEID>

  • AS Instance ID: MSAS12。<INSTANCEID >AS Instance ID:MSAS12.<INSTANCEID>

  • RS 實例識別碼: MSRS12。<INSTANCEID >RS Instance ID:MSRS12.<INSTANCEID>

可感知執行個體的元件會安裝至下列位置:The instance-aware components are installed to the following locations:

% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< SQLInstanceID>%Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<SQLInstanceID>

% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< A s \olap\temp>%Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\<ASInstanceID>

% Program Files%\MicrosoftMicrosoft[SQL Server]SQL Server\< RSInstanceID>%Program Files%\MicrosoftMicrosoft[SQL Server]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

從安裝 Wizard (安裝程式) 安裝 SQL Server 2014Install SQL Server 2014 from the Installation Wizard (Setup)
SQL Server 容錯移轉叢集安裝 SQL Server Failover Cluster Installation
安裝 SQL Server 2014 BI 功能Install SQL Server 2014 BI Features