Share via


Install SQL Server 2014

Download SQL Server 2014 Express

Thank you to Scott Hanselman for collecting all of the installer package links in one place!

This topic provides an overview of different installation options we have for installing SQL Server 2014. For more information about the various SQL Server components that can be installed, and the installation process, see Installation for SQL Server 2014.

NOTE: SQL Server is available in 32-bit and 64-bit editions. The 64-bit and 32-bit editions of SQL Server are installed either through the Installation Wizard, or at a command prompt. For more information about SQL Server components, see Editions and Components of SQL Server 2014 and Features Supported by the Editions of SQL Server 2014.

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

Before you install SQL Server, review installation requirements, system configuration checks, and security considerations. For more information, see Planning a SQL Server Installation. Review the topics in the next section for information about various installation scenarios for SQL Server 2014.

Install SQL Server 2014 Components

Topic Description
About the SQL Server Database Engine Describes how to install and configure the SQL Server Database Engine.
Install SQL Server Replication Describes how to install and configure SQL Server Replication.
Install Distributed Replay Lists down the topics to install the Distributed Replay feature.
Install SQL Server Management Tools Describes how to install and configure SQL Server management tools.
Install SQL Server PowerShell Describes the considerations for installing SQL Server PowerShell components.

How to Install SQL Server 2014

Title Description
Installation How-to Topics Provides links to procedural topics for installing SQL Server 2014 from the installation wizard, from the command prompt, by using configuration files, and by using SysPrep.
Install SQL Server 2014 on Server Core Review this topic to install SQL Server 2014 on Windows Server Core.
Validate a SQL Server Installation Review the use of the SQL Discovery report to verify the version of SQL Server and the SQL Server features installed on the computer.
Check Parameters for the System Configuration Checker Discusses the function of the System Configuration Checker (SCC).

Configuration

Topic Description
Configure the Windows Firewall to Allow SQL Server Access This topic provides an overview of firewall configuration and how to configure the Windows firewall.
Configure a Multi-Homed Computer for SQL Server Access This topic describes how to configure SQL Server and Windows Firewall with Advanced Security to provide for network connections to an instance of SQL Server in a multi-homed environment.
Configure the Windows Firewall to Allow Analysis Services Access You can follow the steps provided in this topic to configure both port and firewall settings to allow access to Analysis Services or PowerPivot for SharePoint.

Install SQL Server 2014 BI Features
SQL Server features that are part of the Microsoft BI platform include Analysis Services, Integration Services, Reporting Services, Data Quality Services, and several client applications used for creating or working with analytical data. This section of the SQL Server Setup documentation explains how to install Analysis Services, Integration Services, Master Data Services, Data Quality Services, and Reporting Services.

SQL Server Failover Cluster Installation
This section of the SQL Server Setup documentation explains how to install, and configure SQL Server failover cluster.

See Also

Planning a SQL Server Installation
Upgrade to SQL Server 2014
Uninstall SQL Server 2014
High Availability Solutions (SQL Server)