Skip to content

quick-start-installation-of-sql-server-2014.md

Latest commit

 

History

History
152 lines (105 loc) · 17.6 KB

quick-start-installation-of-sql-server-2014.md

File metadata and controls

152 lines (105 loc) · 17.6 KB
title Quick-Start Installation of SQL Server 2014 | Microsoft Docs
ms.custom
ms.date 11/25/2019
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
quick start installation [SQL Server]
installation [SQL Server]
installing SQL Server, quick start installations
ms.assetid 672afac9-364d-4946-ad5d-8a2d89cf8d81
author mightypen
ms.author genemi
manager craigg

Quick-Start Installation of SQL Server 2014

Introduction

The [!INCLUDEssNoVersion] Installation Wizard is based on Windows Installer. It provides a single feature tree for installation of the following [!INCLUDEssNoVersion] components:

You can install each component individually or select a combination of the components listed above. To make the best choice among the editions and components available in [!INCLUDEssCurrent], see Editions and Components of SQL Server 2014.

[!INCLUDEssNoVersion] is available in 32-bit and 64-bit editions. [!INCLUDEssNoVersion] Setup supports the following installation options:

By default, sample databases and sample code are not installed as part of [!INCLUDEssNoVersion] Setup. To install sample databases and sample code for non-Express editions of [!INCLUDEssNoVersion], see the CodePlex Web site. To read about support for [!INCLUDEssNoVersion] sample databases and sample code for [!INCLUDEssExpress], see Databases and Samples Overview.

[!INCLUDEssNoVersion] Installation

Regardless of whether you use the [!INCLUDEssNoVersion] Installation Wizard or the command prompt to install [!INCLUDEssNoVersion], setup involves one or more of the following steps:

You can find detailed explanations of these tasks in the next section.

Related Tasks

Planning a [!INCLUDEssNoVersion] Installation

Before you install [!INCLUDEssCurrent], you must review the hardware and software requirements, network and Internet considerations, and security considerations to install and run [!INCLUDEssNoVersion]. 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
Review the security considerations for a [!INCLUDEssNoVersion] installation. Security Considerations
Review the details of the features supported by the different editions of [!INCLUDEssCurrent]. Features and Editions
Determine the best choice among the editions and components available in [!INCLUDEssNoVersion]. Editions and Components of SQL Server 2014
Review the hardware configuration, and learn to prepare for [!INCLUDEssNoVersion] failover cluster installation. Before Installing Failover Clustering

Upgrading to [!INCLUDEssCurrent]

You can upgrade existing instances of [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], or [!INCLUDEssSQL11] to [!INCLUDEssCurrent]. For more information, see Upgrade to SQL Server 2014. Before running [!INCLUDEssNoVersion] Setup to upgrade to [!INCLUDEssCurrent], review the following topics about the upgrade process:

Description Topic
Documents supported upgrade paths to [!INCLUDEssCurrent]. Supported Upgrades
Describes Upgrade Advisor, a tool that analyzes instances of [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro] and [!INCLUDEssSQL11] to identify known upgrade issues. Use Upgrade Advisor to Prepare for Upgrades
Describes the Distributed Replay Utility, a tool that can use multiple computers to replay trace data, simulating a mission-critical workload. By performing a replay on a test server before and after a [!INCLUDEssNoVersion] upgrade, you can measure performance differences and look for any incompatibilities your application may have with the upgrade. Use the Distributed Replay Utility to Prepare for Upgrades
Lists the significant changes that might affect your applications after you upgrade to [!INCLUDEssCurrent]. Backward Compatibility
The procedural topic to upgrade a stand-alone instance of [!INCLUDEssNoVersion] to [!INCLUDEssCurrent]. Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)
The procedural topic to upgrade an edition of [!INCLUDEssCurrent] to another edition. For information about supported edition upgrade paths, see Supported Version and Edition Upgrades. Upgrade to a Different Edition of SQL Server 2014 (Setup)
[!INCLUDEssNoVersion] supports upgrade of the [!INCLUDEssDE] and [!INCLUDEssASnoversion] from [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro] or [!INCLUDEssSQL11] to [!INCLUDEssCurrent] failover clusters separately on all failover cluster nodes. Review this topic for more information. Upgrade a SQL Server Failover Cluster

Installing [!INCLUDEssCurrent]

Review the following topics for information about various installation scenarios for [!INCLUDEssCurrent].

Description Topic
Provides links to the topics for installing various components of [!INCLUDEssCurrent] and procedural topics for installing [!INCLUDEssCurrent]. Install SQL Server 2014
Review this topic to install [!INCLUDEssCurrent] on Windows Server Core. Install SQL Server 2014 on Server Core
Review this topic to add individual features to an existing instance of [!INCLUDEssCurrent]. Add Features to an Instance of SQL Server 2014 (Setup)
Review this topic to create a new [!INCLUDEssNoVersion] failover cluster instance. Create a New SQL Server Failover Cluster (Setup)
Use this topic to manage nodes in an existing [!INCLUDEssNoVersion] failover cluster instance. Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
Use this topic to install [!INCLUDEssNoVersion] client tools on a failover cluster. Install Client Tools on a SQL Server Failover Cluster
Review the use of the SQL Discovery report to verify the version of [!INCLUDEssNoVersion] and the [!INCLUDEssNoVersion] features installed on the computer. Validate a SQL Server Installation
Provides links to procedural topics for installing [!INCLUDEssCurrent] from the installation wizard, from the command prompt, by using configuration files, and by using SysPrep. Installation How-to Topics

Related Content

This section provides information about configuring and uninstalling [!INCLUDEssNoVersion].

Configuring [!INCLUDEssCurrent]

After you have installed [!INCLUDEssNoVersion], you can further configure [!INCLUDEssNoVersion] by using graphical and command-prompt utilities. See the following topics to configure [!INCLUDEssNoVersion] for the first time:

Description Topic
Use the information in this topic to determine whether you need to unblock ports in a firewall to allow access to [!INCLUDEssASnoversion] or PowerPivot for SharePoint. You can follow the steps provided in this topic to configure both port and firewall settings. Configure the Windows Firewall to Allow Analysis Services Access
This topic provides an overview of firewall configuration and summarizes information of interest to a [!INCLUDEssNoVersion] administrator. Configure the Windows Firewall to Allow SQL Server Access
This topic describes how to configure [!INCLUDEssNoVersion] and Windows Firewall with Advanced Security to provide for network connections to an instance of [!INCLUDEssNoVersion] in a multi-homed environment. Configure a Multi-Homed Computer for SQL Server Access

Uninstalling [!INCLUDEssCurrent]

The following topics describe how to manually uninstall a stand-alone instance and a failover-clustered instance of [!INCLUDEssNoVersion]:

Description Topic
This topic describes how to manually uninstall a stand-alone instance of [!INCLUDEssNoVersion]. Uninstall SQL Server 2014
This topic describes how to uninstall a [!INCLUDEssNoVersion] failover-clustered instance. Remove a SQL Server Failover Cluster Instance (Setup)
This topic provides information about manually removing [!INCLUDEssDQSnoversion] (DQS) objects after uninstalling [!INCLUDEssNoVersion] or just DQS server. Remove Data Quality Server Objects

See Also

Product Specifications for SQL Server 2014
Get Started with Product Documentation for SQL Server Backward Compatibility