使用安裝精靈升級為 SQL Server 2014 (安裝程式)Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)

[SQL Server]SQL Server 安裝精靈提供了升級 [SQL Server]SQL Server 元件的單一功能樹狀目錄。The [SQL Server]SQL Server Installation Wizard provides a single feature tree for upgrade of [SQL Server]SQL Server components. 您也可以將 SQL Server 2014SQL Server 2014 與舊版並存安裝,或是從舊版的 [SQL Server]SQL Server 移轉現有的資料庫和組態設定,然後將它們套用至 SQL Server 2014SQL Server 2014 的執行個體。You can also install SQL Server 2014SQL Server 2014 side by side with an earlier version, or migrate existing databases and configuration settings from an earlier [SQL Server]SQL Server version, and apply them to an instance of SQL Server 2014SQL Server 2014.

如需詳細資訊,請參閱下列主題:For more information, see these topics:

注意

在執行 [SQL Server]SQL Server Server Core SP1 的電腦上,不支援將舊版 SQL Server 2014SQL Server 2014 升級為 Windows Server 2008 R2Windows Server 2008 R2Upgrade of an earlier version of [SQL Server]SQL Server to SQL Server 2014SQL Server 2014 is not supported on a computer that is running Windows Server 2008 R2Windows Server 2008 R2 Server Core SP1. 如需有關 Server Core 安裝的詳細資訊,請參閱在 Server Core 上安裝 SQL Server 2014For more information on Server Core installations, see Install SQL Server 2014 on Server Core.

先決條件Prerequisites

您必須以系統管理員身分執行安裝程式。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, and is a local administrator.

在升級 Database EngineDatabase Engine 之前,請檢閱下列主題:Before upgrading the Database EngineDatabase Engine, review the following topics:

警告

請注意,您無法變更要升級的功能,而且您無法在升級作業期間加入功能。Be aware that you cannot change the features to be upgraded, and you cannot add features during the upgrade operation. 如需有關如何將功能加入至升級的執行個體SQL Server 2014SQL Server 2014升級作業完成之後,請參閱將功能加入至執行個體 SQL Server 2014 的(安裝)For more information about how to add features to an upgraded instance of SQL Server 2014SQL Server 2014 after the upgrade operation is complete, see Add Features to an Instance of SQL Server 2014 (Setup).

程序Procedure

升級至 SQL Server 2014SQL Server 2014To upgrade to SQL Server 2014SQL Server 2014

  1. 插入 [SQL Server]SQL Server 安裝媒體,然後在根資料夾中,按兩下 Setup.exe。Insert the [SQL Server]SQL Server installation media, and from the root folder, double-click Setup.exe. 若要從網路共用區進行安裝,請移到共用區上的根資料夾,然後按兩下 Setup.exe。To install from a network share, move to the root folder on the share, and then double-click Setup.exe.

  2. 安裝精靈會啟動 [SQL Server]SQL Server 安裝中心。The Installation Wizard starts the [SQL Server]SQL Server Installation Center. 若要升級現有的 [SQL Server]SQL Server 執行個體,請按一下左側導覽區域中的 [安裝] ,然後再按一下 [從 SQL Server 2005SQL Server 2005SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 升級] 。To upgrade an existing instance of [SQL Server]SQL Server, click Installation in the left-hand navigation area, and then click Upgrade from SQL Server 2005SQL Server 2005, SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, or SQL Server 2012SQL Server 2012.

  3. 在 [產品金鑰] 頁面上,按一下選項,指出您要升級為免費的 [SQL Server]SQL Server版本,還是您擁有產品之產品版本的 PID 金鑰。On the Product Key page, click an option to indicate whether you are upgrading to a free edition of [SQL Server]SQL Server, or whether you have a PID key for a production version of the product. 如需詳細資訊,請參閱 < 版本和 SQL Server 2014 元件Supported Version and Edition UpgradesFor more information, see Editions and Components of SQL Server 2014 and Supported Version and Edition Upgrades.

  4. 在 [授權條款] 頁面上,檢閱授權合約,並在同意時,選取 [我接受授權條款] 核取方塊,然後按 [下一步] 。On the License Terms page, review the license agreement and, if you agree, select the I accept the license terms check box, and then click Next. 若要協助提升 [SQL Server]SQL Server,您也可以啟用功能使用方式選項,並傳送報告給 MicrosoftMicrosoftTo help improve [SQL Server]SQL Server, you can also enable the feature usage option and send reports to MicrosoftMicrosoft.

  5. 在 [全域規則] 視窗中,如果沒有規則錯誤,安裝程序會自動前進到 [產品更新] 視窗。In the Global Rules window, the setup procedure will automatically advance to the Product Updates window if there are no rule errors.

  6. 如果沒有核取控制台\所有控制台項目\Windows Update\變更設定中的 [ MicrosoftMicrosoft 更新] 核取方塊,則接著會出現 [ MicrosoftMicrosoft 更新] 頁面。The MicrosoftMicrosoft Update page will appear next if the MicrosoftMicrosoft Update check box in Control Panel\All Control Panel Items\Windows Update\Change settings is not checked. 如果在 [ MicrosoftMicrosoft 更新] 頁面中核取,會將電腦設定變更為當您掃描 Windows Update 時,包含最新的更新。Putting a check in the MicrosoftMicrosoft Update page will change the computer settings to include the latest updates when you scan for Windows Update.

  7. 最新可用的 [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.

  8. 安裝程式會在 [安裝安裝檔案] 頁面上,顯示下載、擷取及安裝安裝檔案的進度。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.

  9. 在 [升級規則] 視窗中,如果沒有規則錯誤,安裝程序會自動前進到 [選取執行個體] 視窗。In the Upgrade Rules window, the setup procedure will automatically advance to the Select instance window if there are no rule errors.

  10. 在 [選取執行個體] 頁面中,指定要升級的 [SQL Server]SQL Server 執行個體。On the Select Instance page, specify the instance of [SQL Server]SQL Server to upgrade. 若要升級管理工具和共用功能,請選取 [僅升級共用功能] 。To upgrade Management tools and shared features, select Upgrade shared features only.

  11. 在 [選取功能] 頁面上,系統會預先選取要升級的功能。On the Select Features page, the features to upgrade will be preselected. 當您選取功能名稱之後,每一個元件群組的描述就會出現在右窗格中。A description for each component group appears in the right pane after you select the feature name.

    右窗格會顯示選取功能的必要條件。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.

    注意

    如果您在 [選取執行個體] 頁面上選取 [<僅升級共用功能>] 來選擇升級共用功能,則 [功能選取] 頁面上會預先選取所有共用功能。If you have opted to upgrade the shared features by selecting <Upgrade shared features only> on the Select Instance page, all the shared features are preselected on the Feature Selection page. 所有共用元件都會同時升級。All the shared components are upgraded at the same time.

  12. 在 [執行個體組態] 頁面上,指定 [SQL Server]SQL Server執行個體的執行個體識別碼。On the Instance Configuration page, specify the Instance ID for the instance of [SQL Server]SQL Server.

    執行個體識別碼 :依預設,此執行個體名稱會當作執行個體識別碼使用。Instance ID - By default, the instance name is used as the Instance ID. 這是用來識別 [SQL Server]SQL Server執行個體的安裝目錄和登錄機碼。This is used to identify installation directories and registry keys for your instance of [SQL Server]SQL Server. 這是預設執行個體和具名執行個體的狀況。This is the case for default instances and named instances. 如果是預設執行個體,執行個體名稱和執行個體識別碼將會是 MSSQLSERVER。For a default instance, the instance name and instance ID would be MSSQLSERVER. 若要使用非預設的執行個體識別碼,請提供 [執行個體識別碼] 文字方塊的值。To use a non-default instance ID, provide a value for the Instance ID textbox.

    所有的 [SQL Server]SQL Server Service Pack 和升級項目都會套用至 [SQL Server]SQL Server執行個體的每一個元件。All [SQL Server]SQL Server service packs and upgrades will apply to every component of an instance of [SQL Server]SQL Server.

    安裝的執行個體:此方格會顯示執行安裝程式之電腦上的 [SQL Server]SQL Server 執行個體。Installed instances - The grid will show instances of [SQL Server]SQL Server that are on the computer where Setup is running. 如果預設執行個體已經安裝在電腦上,您就必須安裝 SQL Server 2014SQL Server 2014的具名執行個體。If a default instance is already installed on the computer, you must install a named instance of SQL Server 2014SQL Server 2014.

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

  14. [伺服器組態 - 服務帳戶] 頁面上會顯示 [SQL Server]SQL Server 服務的預設服務帳戶。On the Server Configuration - Service Accounts page, the default service accounts are displayed for [SQL Server]SQL Server services. 在這個頁面上所設定的實際服務隨著您要升級的功能而不同。The actual services that are configured on this page depend on the features that you are upgrading.

    驗證和登入資訊將來自先前的 [SQL Server]SQL Server執行個體。Authentication and login information will be carried forward from the previous instance of [SQL Server]SQL Server. 您可以將相同登入帳戶指派給所有 [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 so that [SQL Server]SQL Server services are granted the minimum permissions they have to have to complete their tasks. 如需詳細資訊,請參閱 設定 Windows 服務帳戶與權限預覽版本升級問題的解答。For more information, see 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.

  15. 在 [全文檢索搜尋升級選項] 頁面上,針對升級的資料庫指定升級選項。On the Full-Text Search Upgrade Options page, specify the upgrade options for the databases being upgraded. 如需詳細資訊,請參閱 全文檢索搜尋升級選項For more information, see Full-Text Search Upgrade Options.

  16. 如果所有規則都通過,[功能規則] 視窗會自動前進。The Feature Rules window will automatically advance if all rules pass.

  17. [準備升級] 頁面會顯示在安裝期間指定之安裝選項的樹狀檢視。The Ready to Upgrade page displays a tree view of installation options that were specified during Setup. 若要繼續,請按一下 [安裝]To continue, click Install. [SQL Server]SQL Server 安裝程式會先安裝選取功能所需的必要條件,之後再進行功能安裝。Setup will first install the required prerequisites for the selected features followed by the feature installation.

  18. 在安裝期間,進度頁面會提供狀態,好讓您可以在安裝程式進行時監視安裝進度。During installation, the progress page provides status so that you can monitor installation progress as Setup continues.

  19. 安裝之後,[完成] 頁面會提供安裝和其他重要注意事項之摘要記錄檔的連結。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.

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

後續步驟Next Steps

在升級為 [SQL Server]SQL Server之後,請完成下列工作:After you upgrade to [SQL Server]SQL Server, complete the following tasks:

  • 註冊伺服器:升級會移除先前 [SQL Server]SQL Server 執行個體的登錄設定。Register your servers - Upgrade removes registry settings for the previous instance of [SQL Server]SQL Server. 在升級之後,您必須重新註冊伺服器。After you upgrade, you must reregister your servers.

  • 更新統計資料:若要協助最佳化查詢效能,我們建議您在升級之後,更新所有資料庫的統計資料。Update statistics - To help optimize query performance, we recommend that you update statistics on all databases following upgrade. 請使用 sp_updatestats 預存程序更新 [SQL Server]SQL Server 資料庫中使用者定義資料表的統計資料。Use the sp_updatestats stored procedure to update statistics in user-defined tables in [SQL Server]SQL Server databases.

  • 設定新的 [SQL Server]SQL Server 安裝:為了減少系統的可攻擊介面區,[SQL Server]SQL Server 會選擇性地安裝及啟用主要服務和功能。Configure your new [SQL Server]SQL Server installation - To reduce the attackable surface area of a system, [SQL Server]SQL Server selectively installs and enables key services and features. 如需有關介面區組態的詳細資訊,請參閱這一版的讀我檔案。For more information about surface area configuration, see the readme file for this release.

另請參閱See Also

升級到 SQL Server 2014 Upgrade to SQL Server 2014
回溯相容性Backward Compatibility