SQL Server 2014 快速入門安裝Quick-Start Installation of SQL Server 2014

簡介Introduction

[SQL Server]SQL Server 安裝精靈是以 Windows Installer 為基礎。The [SQL Server]SQL Server Installation Wizard is based on Windows Installer. 它提供了安裝下列 [SQL Server]SQL Server 元件的單一功能樹狀目錄:It provides a single feature tree for installation of the following [SQL Server]SQL Server components:

  • Database EngineDatabase Engine

  • Analysis ServicesAnalysis Services

  • Reporting ServicesReporting Services

  • Integration ServicesIntegration Services

  • Master Data ServicesMaster Data Services

  • Data Quality ServicesData Quality Services

  • 管理工具Management tools

  • 連接元件Connectivity components

您可以個別安裝每個元件,也可以選取上面所列出元件的組合。You can install each component individually or select a combination of the components listed above. 在中提供版本及元件之間最好的選擇SQL Server 2014SQL Server 2014,請參閱 < Edition 和 SQL Server 2014 元件To make the best choice among the editions and components available in SQL Server 2014SQL Server 2014, see Editions and Components of SQL Server 2014.

[SQL Server]SQL Server 有 32 位元和 64 位元兩種版本。is available in 32-bit and 64-bit editions. [SQL Server]SQL Server 安裝程式支援下列安裝選項:Setup supports the following installation options:

根據預設, [SQL Server]SQL Server 安裝程序中不會安裝範例資料庫和範例程式碼。By default, sample databases and sample code are not installed as part of [SQL Server]SQL Server Setup. 若要針對非 [SQL Server]SQL Server Express Edition 安裝範例資料庫和範例程式碼,請參閱 CodePlex 網站To install sample databases and sample code for non-Express editions of [SQL Server]SQL Server, see the CodePlex Web site. 如需查閱 [SQL Server]SQL ServerSQL Server ExpressSQL Server Express範例資料庫及範例程式碼的支援資訊,請參閱< 資料庫及範例概觀>。To read about support for [SQL Server]SQL Server sample databases and sample code for SQL Server ExpressSQL Server Express, see Databases and Samples Overview.

[SQL Server]SQL Server 安裝Installation

不論您是使用 [[SQL Server]SQL Server 安裝精靈] 或命令提示字元安裝 [SQL Server]SQL Server,安裝程式都包含下列一個或多個步驟:Regardless of whether you use the [SQL Server]SQL Server Installation Wizard or the command prompt to install [SQL Server]SQL Server, setup involves one or more of the following steps:

  • 檢閱 [SQL Server]SQL Server 安裝的安裝需求、系統組態檢查與安全性考量。Review installation requirements, system configuration checks, and security considerations for a [SQL Server]SQL Server installation. 如需詳細資訊,請參閱 Planning a SQL Server InstallationFor more information, see Planning a SQL Server Installation.

  • 執行 [SQL Server]SQL Server 安裝程式,將現有的 [SQL Server]SQL Server 版本升級至 SQL Server 2014SQL Server 2014Run [SQL Server]SQL Server Setup to upgrade an existing version of [SQL Server]SQL Server to SQL Server 2014SQL Server 2014. 如需詳細資訊,請參閱 < 升級至 SQL Server 2014For more information, see Upgrading to SQL Server 2014.

  • 執行 [SQL Server]SQL Server 安裝程式,以安裝新的 SQL Server 2014SQL Server 2014 執行個體。Run [SQL Server]SQL Server Setup to install a new instance of SQL Server 2014SQL Server 2014. 如需詳細資訊,請參閱 < 安裝 SQL Server 2014For more information, see Installing SQL Server 2014.

  • 完成 [SQL Server]SQL Server 安裝後,下一個主要的步驟是 [SQL Server]SQL Server 及其元件的設定。After you are finished with [SQL Server]SQL Server installation, the next major step is configuration of [SQL Server]SQL Server and its components. 使用 [SQL Server]SQL Server 公用程式來設定 [SQL Server]SQL ServerUse [SQL Server]SQL Server utilities to configure [SQL Server]SQL Server. 如需詳細資訊,請參閱 < 設定 SQL Server 2014For more information, see Configuring SQL Server 2014.

在下一節中,您可以找到這些工作的詳細說明。You can find detailed explanations of these tasks in the next section.

規劃[SQL Server]SQL Server安裝Planning a [SQL Server]SQL Server Installation

在安裝 SQL Server 2014SQL Server 2014 之前,您必須檢閱硬體和軟體需求、網路和網際網路考量,以及安全考量,才能安裝並執行 [SQL Server]SQL ServerBefore you install SQL Server 2014SQL Server 2014, you must review the hardware and software requirements, network and Internet considerations, and security considerations to install and run [SQL Server]SQL Server. 如需詳細資訊,請參閱 < 規劃 SQL Server 安裝和下列主題:For more information, see Planning a SQL Server Installation and also the following topics:

工作描述Task Description 主題Topic
請檢閱硬體及軟體需求、作業系統支援、網路及網際網路考量,以及硬碟空間需求。Review the hardware and software requirements, operating system support, network and Internet considerations, and hard disk space requirements. 安裝的必要條件Installation Prerequisites
檢閱 [SQL Server]SQL Server 安裝的安全性考量。Review the security considerations for a [SQL Server]SQL Server installation. 安全性考量Security Considerations
請檢閱由不同版本 SQL Server 2014SQL Server 2014 所支援功能的詳細資料。Review the details of the features supported by the different editions of SQL Server 2014SQL Server 2014. 功能和版本Features and Editions
請判斷 [SQL Server]SQL Server 中可用版本及元件之間最好的選擇。Determine the best choice among the editions and components available in [SQL Server]SQL Server. SQL Server 2014 的版本和元件Editions and Components of SQL Server 2014
請檢閱硬體組態,並學習如何準備 [SQL Server]SQL Server 容錯移轉叢集安裝。Review the hardware configuration, and learn to prepare for [SQL Server]SQL Server failover cluster installation. 安裝容錯移轉叢集之前Before Installing Failover Clustering

升級至 SQL Server 2014SQL Server 2014Upgrading to SQL Server 2014SQL Server 2014

您可以將 SQL Server 2005SQL Server 2005SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 的現有執行個體升級至 SQL Server 2014SQL Server 2014You can upgrade existing instances of SQL Server 2005SQL Server 2005, SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, or SQL Server 2012SQL Server 2012 to SQL Server 2014SQL Server 2014. 如需詳細資訊,請參閱 < 升級至 SQL Server 2014For more information, see Upgrade to SQL Server 2014. 在執行 [SQL Server]SQL Server 安裝程式升級至 SQL Server 2014SQL Server 2014 之前,請先檢閱下列升級程序的主題:Before running [SQL Server]SQL Server Setup to upgrade to SQL Server 2014SQL Server 2014, review the following topics about the upgrade process:

描述Description 主題Topic
支援 SQL Server 2014SQL Server 2014 升級路徑的文件。Documents supported upgrade paths to SQL Server 2014SQL Server 2014. 支援的升級Supported Upgrades
描述 Upgrade Advisor,這是用於分析 SQL Server 2005SQL Server 2005SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 執行個體以識別已知升級問題的工具。Describes Upgrade Advisor, a tool that analyzes instances of SQL Server 2005SQL Server 2005, SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2 and SQL Server 2012SQL Server 2012 to identify known upgrade issues. 使用 Upgrade Advisor 來準備升級Use Upgrade Advisor to Prepare for Upgrades
描述 Distributed Replay Utility,一種可使用多個元件重新執行追蹤資料,並模擬關鍵任務工作負載的工具。Describes the Distributed Replay Utility, a tool that can use multiple computers to replay trace data, simulating a mission-critical workload. [SQL Server]SQL Server 升級前後於測試伺服器上進行重新執行作業,可讓您衡量效能差異,並找出應用程式在升級後可能會發生的不相容情況。By performing a replay on a test server before and after a [SQL Server]SQL Server upgrade, you can measure performance differences and look for any incompatibilities your application may have with the upgrade. 使用 Distributed Replay Utility 來準備升級Use the Distributed Replay Utility to Prepare for Upgrades
列出當您升級到 SQL Server 2014SQL Server 2014 之後會影響應用程式的一些重大變更。Lists the significant changes that might affect your applications after you upgrade to SQL Server 2014SQL Server 2014. 回溯相容性Backward Compatibility
[SQL Server]SQL Server 的獨立執行個體升級到 SQL Server 2014SQL Server 2014 的程序主題。The procedural topic to upgrade a stand-alone instance of [SQL Server]SQL Server to SQL Server 2014SQL Server 2014. 升級為 SQL Server 2014 使用安裝精靈(安裝程式)Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)
SQL Server 2014SQL Server 2014 的版本升級至另一個版本的程序主題。The procedural topic to upgrade an edition of SQL Server 2014SQL Server 2014 to another edition. 如需支援版本升級方式的詳細資訊,請參閱 支援的版本與版本升級For information about supported edition upgrade paths, see Supported Version and Edition Upgrades. 升級至不同的 SQL Server 2014 版本(安裝程式)Upgrade to a Different Edition of SQL Server 2014 (Setup)
[SQL Server]SQL Server 支援在所有容錯移轉叢集節點上,將 Database EngineDatabase EngineAnalysis ServicesAnalysis Services 分別從 SQL Server 2005SQL Server 2005SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2SQL Server 2012SQL Server 2012 升級至 SQL Server 2014SQL Server 2014 容錯移轉叢集。supports upgrade of the Database EngineDatabase Engine and Analysis ServicesAnalysis Services from SQL Server 2005SQL Server 2005, SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2 or SQL Server 2012SQL Server 2012 to SQL Server 2014SQL Server 2014 failover clusters separately on all failover cluster nodes. 如需詳細資訊,請檢閱本主題。Review this topic for more information. 升級 SQL Server 容錯移轉叢集Upgrade a SQL Server Failover Cluster

安裝 SQL Server 2014SQL Server 2014Installing SQL Server 2014SQL Server 2014

如需不同 SQL Server 2014SQL Server 2014 安裝案例的詳細資訊,請檢閱下列主題。Review the following topics for information about various installation scenarios for SQL Server 2014SQL Server 2014.

描述Description 主題Topic
提供主題的連結以安裝 SQL Server 2014SQL Server 2014 的多個元件,以及提供程序主題以安裝 SQL Server 2014SQL Server 2014Provides links to the topics for installing various components of SQL Server 2014SQL Server 2014 and procedural topics for installing SQL Server 2014SQL Server 2014. 安裝 SQL Server 2014Install SQL Server 2014
檢閱本主題了解如何在 Windows Server Core 上安裝 SQL Server 2014SQL Server 2014Review this topic to install SQL Server 2014SQL Server 2014 on Windows Server Core. 在 Server Core 上安裝 SQL Server 2014Install SQL Server 2014 on Server Core
請檢閱本主題以將個別功能加入現有 SQL Server 2014SQL Server 2014 的執行個體。Review this topic to add individual features to an existing instance of SQL Server 2014SQL Server 2014. 將功能加入至 SQL Server 2014 執行個體的(安裝程式)Add Features to an Instance of SQL Server 2014 (Setup)
請檢閱本主題以建立新的 [SQL Server]SQL Server 容錯移轉叢集執行個體。Review this topic to create a new [SQL Server]SQL Server failover cluster instance. 建立新的 SQL Server 容錯移轉叢集 (安裝程式)Create a New SQL Server Failover Cluster (Setup)
您可以使用本主題管理現有 [SQL Server]SQL Server 容錯移轉叢集執行個體中的節點。Use this topic to manage nodes in an existing [SQL Server]SQL Server failover cluster instance. 在 SQL Server 容錯移轉叢集中新增或移除節點 (安裝程式)Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
您可以使用本主題在容錯移轉叢集上安裝 [SQL Server]SQL Server 用戶端工具。Use this topic to install [SQL Server]SQL Server client tools on a failover cluster. 在 SQL Server 容錯移轉叢集上安裝用戶端工具Install Client Tools on a SQL Server Failover Cluster
檢閱 SQL 探索報告的使用狀況,以驗證電腦上所安裝之 [SQL Server]SQL Server 的版本與 [SQL Server]SQL Server 功能。Review the use of the SQL Discovery report to verify the version of [SQL Server]SQL Server and the [SQL Server]SQL Server features installed on the computer. 驗證 SQL Server 安裝Validate a SQL Server Installation
提供如何從安裝精靈、從命令提示字元、使用組態檔及使用 SysPrep 安裝 SQL Server 2014SQL Server 2014 的程序性主題連結。Provides links to procedural topics for installing SQL Server 2014SQL Server 2014 from the installation wizard, from the command prompt, by using configuration files, and by using SysPrep. 安裝的使用說明主題Installation How-to Topics

本節提供設定及解除安裝 [SQL Server]SQL Server 的詳細資訊。This section provides information about configuring and uninstalling [SQL Server]SQL Server.

設定 SQL Server 2014SQL Server 2014Configuring SQL Server 2014SQL Server 2014

在您安裝 [SQL Server]SQL Server 之後,可以使用圖形化公用程式和命令提示字元公用程式來進一步設定 [SQL Server]SQL ServerAfter you have installed [SQL Server]SQL Server, you can further configure [SQL Server]SQL Server by using graphical and command-prompt utilities. 請參閱下列主題以進行第一次的 [SQL Server]SQL Server 設定:See the following topics to configure [SQL Server]SQL Server for the first time:

描述Description 主題Topic
使用本主題中的資訊可判斷是否需要在防火牆中解除封鎖通訊埠,以允許存取 Analysis ServicesAnalysis Services 或 PowerPivot for SharePoint。Use the information in this topic to determine whether you need to unblock ports in a firewall to allow access to Analysis ServicesAnalysis Services or PowerPivot for SharePoint. 您可以遵循本主題所提供的步驟,設定通訊埠以及防火牆。You can follow the steps provided in this topic to configure both port and firewall settings. 設定 Windows 防火牆以允許 Analysis Services 存取Configure the Windows Firewall to Allow Analysis Services Access
本主題會提供防火牆組態的概觀,並且摘要列出 [SQL Server]SQL Server 管理員感興趣的資訊。This topic provides an overview of firewall configuration and summarizes information of interest to a [SQL Server]SQL Server administrator. 設定 Windows 防火牆以允許 SQL Server 存取Configure the Windows Firewall to Allow SQL Server Access
此主題描述如何設定 [SQL Server]SQL Server 和具有進階安全性的 Windows 防火牆,以便在多重主目錄環境中提供給 [SQL Server]SQL Server 執行個體的網路連接。This topic describes how to configure [SQL Server]SQL Server and Windows Firewall with Advanced Security to provide for network connections to an instance of [SQL Server]SQL Server in a multi-homed environment. 設定多重主目錄電腦進行 SQL Server 存取Configure a Multi-Homed Computer for SQL Server Access

解除安裝 SQL Server 2014SQL Server 2014Uninstalling SQL Server 2014SQL Server 2014

下列主題描述如何手動解除安裝 [SQL Server]SQL Server 的獨立執行個體及容錯移轉叢集執行個體:The following topics describe how to manually uninstall a stand-alone instance and a failover-clustered instance of [SQL Server]SQL Server:

描述Description 主題Topic
此主題描述如何手動解除安裝 [SQL Server]SQL Server的獨立執行個體。This topic describes how to manually uninstall a stand-alone instance of [SQL Server]SQL Server. 解除安裝 SQL Server 2014Uninstall SQL Server 2014
此主題描述如何解除安裝 [SQL Server]SQL Server 容錯移轉叢集執行個體。This topic describes how to uninstall a [SQL Server]SQL Server failover-clustered instance. 移除 SQL Server 容錯移轉叢集執行個體 (安裝程式)Remove a SQL Server Failover Cluster Instance (Setup)
本主題提供有關在解除安裝 Data Quality ServicesData Quality Services 或只解除安裝 DQS 伺服器之後,手動移除 [SQL Server]SQL Server (DQS) 物件的資訊。This topic provides information about manually removing Data Quality ServicesData Quality Services (DQS) objects after uninstalling [SQL Server]SQL Server or just DQS server. 移除 Data Quality Server 物件Remove Data Quality Server Objects

另請參閱See Also

適用於 SQL Server 2014 的產品規格 Product Specifications for SQL Server 2014
開始使用適用於 SQL Server 的產品文件回溯相容性Get Started with Product Documentation for SQL Server Backward Compatibility