將功能加入至 SQL Server 2014 的執行個體 (安裝程式)Add Features to an Instance of SQL Server 2014 (Setup)

本主題提供將功能加入 SQL Server 2014SQL Server 2014執行個體的逐步程序。This topic provides a step-by-step procedure for adding features to an instance of SQL Server 2014SQL Server 2014. 某些 [SQL Server]SQL Server 元件或服務是 [SQL Server]SQL Server執行個體所特有,Some [SQL Server]SQL Server components or services are specific to an instance of [SQL Server]SQL Server. 也可感知執行個體。These are also known as instance-aware. 這些元件或服務也會與裝載它們的執行個體共用相同的版本,並專門用於該執行個體。They share the same version as the instance that hosts them, and are used exclusively for that instance. 如果還未安裝感知執行個體元件及其共用元件,可以將其加入執行個體 [SQL Server]SQL ServerYou can add the instance-aware components to an instance [SQL Server]SQL Server, along with the shared components of if they are not already installed. 如需的版本所支援的功能清單[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.

若要將功能加入至執行個體[SQL Server]SQL Server從命令提示字元中,請參閱從命令提示字元安裝 SQL Server 2014To add features to an instance of [SQL Server]SQL Server from the command prompt, see Install SQL Server 2014 from the Command Prompt.

先決條件Prerequisites

在繼續進行之前,請檢閱 規劃 SQL Server 安裝中的主題。Before you continue, review topics in Planning a SQL Server Installation.

注意

如果是本機安裝,您必須以管理員身分執行安裝程式。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 permissions on the remote share.

注意

當您將功能加入 SQL Server 2014SQL Server 2014 的執行個體時,現有的使用方式報表設定會套用至新加入的功能。When you add features to an instance of SQL Server 2014SQL Server 2014, the existing usage report settings are applied to the newly-added features. 若要變更這些設定,請使用 [[SQL Server]SQL Server 組態工具] 功能表中的 [[SQL Server]SQL Server 錯誤和使用方式報表] 工具。To change these settings, use the [SQL Server]SQL Server Error and Usage Reporting tool on the [SQL Server]SQL ServerConfiguration Tools menu.

程序Procedures

若要從命令提示字元,將功能加入 SQL Server 2014SQL Server 2014To add features to an instance of SQL Server 2014SQL Server 2014

  1. 插入 [SQL Server]SQL Server 安裝媒體。Insert the [SQL Server]SQL Server installation media. 在根資料夾中,按兩下 setup.exe。From the root folder, double-click setup.exe. 若要從網路共用進行安裝,請導覽至共用上的根資料夾,然後按兩下 setup.exe。To install from a network share, navigate to the root folder on the share, and then double-click setup.exe. 如果出現 [SQL Server 2012SQL Server 2012 安裝程式] 對話方塊,請按一下 [確定] 。Click OK. 安裝必要條件,然後按一下 [取消] 以結束 SQL Server 2014SQL Server 2014 安裝。If the SQL Server 2012SQL Server 2012 Setup dialog box appears, 按一下 [確定] 。Click OK. to install the prerequisites, then click Cancel to quit SQL Server 2014SQL Server 2014 installation.

  2. 安裝精靈將會啟動 [SQL Server]SQL Server 安裝中心。The Installation Wizard will launch the [SQL Server]SQL Server Installation Center. 若要將功能加入現有的 SQL Server 2014SQL Server 2014 執行個體,請在左側導覽區域中,按一下 [安裝] ,然後按一下 [新增 [SQL Server]SQL Server 獨立安裝或將功能加入至現有安裝] 。To add a new feature to an existing instance of SQL Server 2014SQL Server 2014, click Installation in the left-hand navigation area, and then click New [SQL Server]SQL Server stand-alone installation or add features to an existing installation.

  3. 系統組態檢查將會在電腦上執行探索作業。The System Configuration Checker will run a discovery operation on your computer. 若要檢視驗證詳細資料,請按一下 [檢視詳細資料] 。To view the verification details click View Details. 若要繼續,請按一下 [確定] 。Click OK.To continue, 按一下 [確定] 。Click OK..

  4. 最新可用的 [SQL Server]SQL Server 產品更新會隨即顯示在 [產品更新] 頁面上。On the Product Updates page, the latest available [SQL Server]SQL Server product updates are displayed. 如果不想包含更新,請清除 包含 [SQL Server]SQL Server 產品更新程式 核取方塊。If you don't want to include the updates, clear the Include [SQL Server]SQL Server product updates check box. 如果未偵測到任何產品更新, [SQL Server]SQL Server 安裝程式將不會顯示此頁面,而會自動前往 [安裝安裝程式檔案] 頁面。If no product updates are discovered, [SQL Server]SQL Server Setup does not display this page and auto advances to the Install Setup Files page.

  5. 安裝程式會在 [安裝安裝程式檔案] 頁面上,顯示下載、擷取及安裝安裝程式檔案的進度。On the Install Setup files page, Setup provides the progress of downloading, extracting, and installing the Setup files. 如有找到 [SQL Server]SQL Server 安裝程式的更新,並指定要包含該更新,將會一併安裝。If an update for [SQL Server]SQL Server Setup is found, and is specified to be included, that update will also be installed. 按一下 [安裝] ,以安裝安裝程式支援檔案。Click Install to install Setup Support files.

  6. 系統組態檢查將會先確認電腦的系統狀態,然後安裝程式才會繼續進行。The System Configuration Checker will verify the system state of your computer before Setup continues.

  7. 在 [安裝類型] 頁面上,選取 [將功能加入到現有的 SQL Server 2014SQL Server 2014 執行個體] 選項,然後選取要更新的執行個體。On the Installation Type page, select the option Add features to an existing instance of SQL Server 2014SQL Server 2014, and select the instance you would like to update.

  8. 在 [特徵選取] 頁面上,選取要安裝的元件。On the Feature Selection page, select the components for your installation. 當您選取功能名稱之後,每一個元件群組的描述就會出現在右手邊窗格中。A description for each component group appears in the right-hand pane after you select the feature name. 您可以選取核取方塊的任何組合。You can select any combination of check boxes. 如需詳細資訊,請參閱 < 版本和 SQL Server 2014 元件For more information, see Editions and Components of SQL Server 2014. 在給定的 [SQL Server]SQL Server執行個體上,每個元件都只能安裝一次。Each component can be installed only once on a given instance of [SQL Server]SQL Server. 若要安裝多個元件,您必須安裝其他 [SQL Server]SQL Server執行個體。To install multiple components, you must install an additional instance of [SQL Server]SQL Server.

    右窗格會顯示選取功能的必要條件。The prerequisites for the selected features are displayed on the right-hand pane. [SQL Server]SQL Server 安裝程式將會在這個程序稍後說明的安裝步驟期間安裝尚未安裝的必要條件。Setup will install the prerequisite that are not already installed during the installation step described later in this procedure.

    系統組態檢查將會先確認電腦的系統狀態,然後安裝程式才會繼續進行。The System Configuration Checker will verify the system state of your computer before Setup continues. [下一步] ,繼續進行。Click Next to continue.

  9. [磁碟空間需求] 頁面會計算您所指定之功能的所需磁碟空間,並且比較空間需求與執行安裝程式之電腦的可用磁碟空間。The Disk Space Requirements page calculates the required disk space for the features you specify, and compares requirements to the available disk space on the computer where Setup is running.

  10. 本主題其餘部分的工作流程會因您針對安裝所指定的功能而不同。Work flow for the remainder of this topic depends on the features you have specified for your installation. 您可能不會看到所有頁面,端視您的選取項目而定。You might not see all of the pages, depending on your selections.

  11. 在 [伺服器設定 - 服務帳戶] 頁面中,指定 [SQL Server]SQL Server 服務的登入帳戶。On the Server Configuration - Service Accounts page, specify login accounts for [SQL Server]SQL Server services. 在這個頁面上所設定的實際服務隨著您選取要安裝的功能而不同。The actual services that are configured on this page depend on the features you selected to install.

    您可以將相同登入帳戶指派給所有 [SQL Server]SQL Server 服務,或個別設定每一個服務帳戶。You can assign the same login account to all [SQL Server]SQL Server services, or you can configure each service account individually. 此外,您也可以指定要自動啟動服務、手動啟動服務或停用服務。You can also specify whether services start automatically, are started manually, or are disabled. MicrosoftMicrosoft 建議您個別設定服務帳戶,以針對各項服務提供最低權限,其中 [SQL Server]SQL Server 服務會授與必須完成工作的最小權限。recommends that you configure service accounts individually to provide least privileges for each service, where [SQL Server]SQL Server services are granted the minimum permissions they need to complete their tasks. 如需詳細資訊,請參閱 伺服器組態 - 服務帳戶設定 Windows 服務帳戶與權限For more information, see Server Configuration - Service Accounts and Configure Windows Service Accounts and Permissions.

    若要針對此 [SQL Server]SQL Server執行個體中的所有服務帳戶指定相同的登入帳戶,請在頁面底部的欄位中提供認證。To specify the same login account for all service accounts in this instance of [SQL Server]SQL Server, provide credentials in the fields at the bottom of the page.

    安全性注意事項請勿使用空白密碼。Do not use a blank password. 請使用增強式密碼。Use a strong password.Security Note : 請勿使用空白密碼。Do not use a blank password. 請使用增強式密碼。Use a strong password.

    當您完成針對 [SQL Server]SQL Server 服務指定登入資訊之後,請按 [下一步]When you are finished specifying login information for [SQL Server]SQL Server services, click Next.

  12. 使用 [伺服器組態 - 定序] 索引標籤,為 Database EngineDatabase EngineAnalysis ServicesAnalysis Services 指定非預設的定序。Use the Server Configuration - Collation tab to specify non-default collations for the Database EngineDatabase Engine and Analysis ServicesAnalysis Services. 如需詳細資訊,請參閱伺服器組態 - 定序For more information, see Server Configuration - Collation.

  13. 使用 Database EngineDatabase Engine [組態 - 帳戶提供] 頁面來指定以下項目:Use the Database EngineDatabase Engine Configuration - Account Provisioning page to specify the following:

    • 安全性模式 - 為 [SQL Server]SQL Server執行個體選取 Windows 驗證或混合模式驗證。Security Mode - Select Windows Authentication or Mixed Mode Authentication for your instance of [SQL Server]SQL Server. 如果您選取混合模式驗證,就必須為內建 [SQL Server]SQL Server 系統管理員帳戶提供增強式密碼。If you select Mixed Mode Authentication, you must provide a strong password for the built-in [SQL Server]SQL Server system administrator account.

      當裝置與 [SQL Server]SQL Server建立成功的連接之後,Windows 驗證和混合模式的安全性機制是相同的。After a device establishes a successful connection to [SQL Server]SQL Server, the security mechanism is the same for both Windows Authentication and Mixed Mode. 如需詳細資訊,請參閱 < Database Engine 組態-帳戶佈建For more information, see Database Engine Configuration - Account Provisioning.

    • [SQL Server]SQL Server 管理員 - 您在 [SQL Server]SQL Server執行個體上至少必須指定一個系統管理員。Administrators - You must specify at least one system administrator for the instance of [SQL Server]SQL Server. 若要加入 [SQL Server]SQL Server 安裝程式執行所用的帳戶,請按一下 [加入目前使用者]To add the account under which [SQL Server]SQL Server Setup is running, click Add Current User. 若要從系統管理員清單中加入或移除帳戶,請按一下 [加入][移除] ,然後編輯在 [SQL Server]SQL Server執行個體中將會有管理員權限的使用者、群組或電腦清單。To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for the instance of [SQL Server]SQL Server. 如需詳細資訊,請參閱 < Database Engine 組態-帳戶佈建For more information, see Database Engine Configuration - Account Provisioning.

    當您完成清單的編輯之後,請按一下 [確定]When you are finished editing the list, click OK. 然後,在組態對話方塊中確認管理員的清單。Verify the list of administrators in the configuration dialog box. 當此清單完成時,請按 [下一步]When the list is complete, click Next.

  14. 使用 Database EngineDatabase Engine [組態 - 資料目錄] 頁面來指定非預設的安裝目錄。Use the Database EngineDatabase Engine Configuration - Data Directories page to specify non-default installation directories. 若要安裝到預設目錄,請按 [下一步]To install to default directories, click Next.

    重要

    如果您要指定非預設的安裝目錄,請確定安裝資料夾對於此 [SQL Server]SQL Server執行個體是唯一的。If you specify non-default installation directories, ensure that the installation folders are unique to this instance of [SQL Server]SQL Server. 此對話方塊上的任何目錄都不應該與其他 [SQL Server]SQL Server執行個體中的目錄共用。None of the directories in this dialog box should be shared with directories from other instances of [SQL Server]SQL Server.

    如需詳細資訊,請參閱 Database Engine 組態 - 資料目錄For more information, see Database Engine Configuration - Data Directories.

  15. 使用 [ Database EngineDatabase Engine 組態 - FILESTREAM] 頁面來針對 [SQL Server]SQL Server執行個體啟用 FILESTREAM。Use the Database EngineDatabase Engine Configuration - FILESTREAM page to enable FILESTREAM for your instance of [SQL Server]SQL Server. 如需 FILESTREAM 的詳細資訊,請參閱 Database Engine 組態 - FilestreamFor more information about FILESTREAM, see Database Engine Configuration - Filestream. 若要繼續進行,請按 [下一步]。To continue, click Next.

  16. 您可以使用 [Analysis ServicesAnalysis Services 組態 - 帳戶提供] 頁面指定伺服器模式以及要擁有 Analysis ServicesAnalysis Services 之管理員權限的使用者或帳戶。Use the Analysis ServicesAnalysis Services Configuration - Account Provisioning page to specify the server mode and the users or accounts that will have administrator permissions for Analysis ServicesAnalysis Services. 伺服器模式會決定在伺服器上所要使用的記憶體及儲存體子系統。Server mode determines which memory and storage subsystems are used on the server. 不同方案類型會在不同的伺服器模式中執行。Different solution types run in different server modes. 如果要在伺服器上執行多維度 Cube 資料庫,請選擇預設選項 [多維度及資料採礦伺服器模式]。If you plan to run multidimensional cube databases on the server, choose the default option, Multidimensional and Data Mining server mode. 無論系統管理員權限為何,至少須為 Analysis ServicesAnalysis Services指定一名系統管理員。Regarding administrator permissions, you must specify at least one system administrator for Analysis ServicesAnalysis Services. 如果要加入執行 SQL Server 安裝程式的帳戶,請按一下 [加入目前使用者] 。To add the account under which SQL Server Setup is running, click Add Current User. 若要在系統管理員清單中加入或移除帳戶,請按一下 [加入][移除] ,然後編輯在 Analysis ServicesAnalysis Services中將會有管理員權限的使用者、群組或電腦清單。To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for Analysis ServicesAnalysis Services. 如需伺服器模式及系統管理員權限的詳細資訊,請參閱 Analysis Services 組態 - 帳戶提供For more information about server mode and administrator permissions, see Analysis Services Configuration - Account Provisioning.

    當您完成清單的編輯之後,請按一下 [確定]When you are finished editing the list, click OK. 然後,在組態對話方塊中確認管理員的清單。Verify the list of administrators in the configuration dialog box. 當此清單完成時,請按 [下一步]When the list is complete, click Next.

  17. 使用 Analysis ServicesAnalysis Services [組態 - 資料目錄] 頁面來指定非預設的安裝目錄。Use the Analysis ServicesAnalysis Services Configuration - Data Directories page to specify non-default installation directories. 若要安裝到預設目錄,請按 [下一步]To install to default directories, click Next.

    重要

    如果您要指定非預設的安裝目錄,請確定安裝資料夾對於此 [SQL Server]SQL Server執行個體是唯一的。If you specify non-default installation directories, ensure that the installation folders are unique to this instance of [SQL Server]SQL Server. 此對話方塊上的任何目錄都不應該與其他 [SQL Server]SQL Server執行個體中的目錄共用。None of the directories in this dialog box should be shared with directories from other instances of [SQL Server]SQL Server.

    如需詳細資訊,請參閱 Analysis Services 組態 - 資料目錄For more information, see Analysis Services Configuration - Data Directories.

  18. 使用 [Reporting ServicesReporting Services 組態] 頁面來指定要建立的 Reporting ServicesReporting Services 安裝類型。Use the Reporting ServicesReporting Services Configuration page to specify the type of Reporting ServicesReporting Services installation to create. 如需 Reporting ServicesReporting Services 組態模式的詳細資訊,請參閱 Reporting Services 組態選項 (SSRS)For more information about Reporting ServicesReporting Services configuration modes, see Reporting Services Configuration Options (SSRS).

  19. 您可以使用 [Distributed Replay Controller 組態] 頁面,指定要授與 Distributed Replay Controller 服務之管理權限的使用者。Use the Distributed Replay Controller Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay controller service. 擁有管理權限的使用者將可不受限制地存取 Distributed Replay Controller 服務。Users that have administrative permissions will have unlimited access to the Distributed Replay controller service.

    按一下 [加入目前使用者] 按鈕,可加入要授與 Distributed Replay Controller 服務之存取權限的使用者。Click the Add Current User button to add the users to whom you want to grant access permissions for the Distributed Replay controller service. 按一下 [加入] 按鈕,可加入 Distributed Replay Controller 服務的存取權限。Click the Add button to add access permissions for the Distributed Replay controller service. 按一下 [移除] 按鈕,可移除 Distributed Replay Controller 服務的存取權限。Click the Remove button to remove access permissions from the Distributed Replay controller service.

    若要繼續進行,請按 [下一步]To continue, click Next.

  20. 您可以使用 [Distributed Replay Client 組態] 頁面,指定要授與 Distributed Replay Client 服務之管理權限的使用者。Use the Distributed Replay Client Configuration page to specify the users you want to grant administrative permissions to for the Distributed Replay client service. 擁有管理權限的使用者將可不受限制地存取 Distributed Replay Client 服務。Users that have administrative permissions will have unlimited access to the Distributed Replay client service.

    [控制器名稱] 是選擇性參數,預設值為 <空白 >。Controller Name is an optional parameter, and the default value is <blank>. 針對 Distributed Replay Client 服務,輸入將與用戶端電腦進行通訊之控制器的名稱。Enter the name of the controller that the client computer will communicate with for the Distributed Replay client service. 請注意下列事項:Note the following:

    • 如果您已經設定了控制器,請在設定每個用戶端時輸入該控制器的名稱。If you have already set up a controller, enter the name of the controller while configuring each client.

    • 如果您尚未設定控制器,則可以將控制器名稱留白。If you have not yet set up a controller, you can leave the controller name blank. 不過,您必須在 [用戶端組態] 檔中,手動輸入控制器名稱。However, you must manually enter the controller name in the client configuration file.

    指定 Distributed Replay Client 服務的 工作目錄Specify the Working Directory for the Distributed Replay client service. 預設工作目錄為 <磁碟機代號 >:\Program Files\MicrosoftMicrosoft[SQL Server]SQL Server\DReplayClient\WorkingDir\。The default working directory is <drive letter>:\Program Files\MicrosoftMicrosoft[SQL Server]SQL Server\DReplayClient\WorkingDir\.

    指定 Distributed Replay Client 服務的 結果目錄Specify the Result Directory for the Distributed Replay client service. 預設工作目錄為 <磁碟機代號 >:\Program Files\MicrosoftMicrosoft[SQL Server]SQL Server\DReplayClient\ResultDir\。The default result directory is <drive letter>:\Program Files\MicrosoftMicrosoft[SQL Server]SQL Server\DReplayClient\ResultDir\.

    若要繼續進行,請按 [下一步]To continue, click Next.

  21. 在 [錯誤報告] 頁面上,指定您想要傳送給 MicrosoftMicrosoft 的資訊,以便協助改善 [SQL Server]SQL ServerOn the Error Reporting page, specify the information you would like to send to MicrosoftMicrosoft that will help to improve [SQL Server]SQL Server. 錯誤報告選項預設為啟用。By default, options for error reporting is enabled.

  22. 系統組態檢查將會執行一組額外的規則,以便使用您已指定的 [SQL Server]SQL Server 功能來驗證電腦組態。The System Configuration Checker will run one more set of rules to validate your computer configuration with the [SQL Server]SQL Server features you have specified.

  23. [準備安裝] 頁面會顯示在安裝期間指定之安裝選項的樹狀檢視。The Ready to Install page displays a tree view of installation options that were specified during Setup. 在此頁面上,安裝程式會指出產品更新功能為啟用或停用,以及最後的更新版本。On this page, Setup indicates whether the Product Update feature is enabled or disabled and the final update version. 按一下 [安裝] 之後, [SQL Server]SQL Server 安裝程式會先安裝所選功能所需的必要條件,然後再安裝功能。After you click install, [SQL Server]SQL Server Setup will first install the required prerequisites for the selected features followed by the feature installation.

  24. 在安裝期間,[安裝進度] 頁面會提供狀態,所以您可以在安裝程式進行時監視安裝進度。During installation, the Installation Progress page provides status so you can monitor installation progress as Setup proceeds.

  25. 安裝之後,[完成] 頁面會提供安裝和其他重要注意事項之摘要記錄檔的連結。After installation, the Complete page provides a link to the summary log file for the installation and other important notes. 若要完成 [SQL Server]SQL Server 安裝程序,請按一下 [關閉]To complete the [SQL Server]SQL Server installation process, click Close.

  26. 如果指示您重新啟動電腦,請立刻執行。If you are instructed to restart the computer, do so now. 當您完成安裝時,請務必閱讀安裝精靈所提供的訊息。It is important to read the message from the Installation Wizard when you are done with Setup. 如需安裝程式記錄檔的資訊,請參閱 檢視與讀取 SQL Server 安裝程式記錄檔For information about Setup log files, see View and Read SQL Server Setup Log Files.

後續步驟Next Steps

設定 [SQL Server]SQL Server 安裝。Configure your [SQL Server]SQL Server installation

  • 為了減少系統的可攻擊介面區, [SQL Server]SQL Server 可以選擇性地安裝和啟用主要服務和功能。To reduce the attackable surface area of a system, [SQL Server]SQL Server selectively installs and activates key services and features. 如需詳細資訊,請參閱< Surface Area Configuration>。For more information, see Surface Area Configuration.

另請參閱See Also

檢視與讀取 SQL Server 安裝程式記錄檔 View and Read SQL Server Setup Log Files
驗證 SQL Server 安裝 Validate a SQL Server Installation
卸除 SQL Server 2014 安裝 Drop a SQL Server 2014 Installation
升級為 SQL Server 2014 使用安裝精靈(安裝程式) Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)
從命令提示字元安裝 SQL Server 2014Install SQL Server 2014 from the Command Prompt