SQL Server installation guide

APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

This article is an index of content that provides guidance for installing SQL Server on Windows.

For other deployment scenarios, see:

Beginning with SQL Server 2016 (13.x), SQL Server is only available as a 64-bit application. Here are important details about how to get SQL Server and how to install it.

Getting started

Installation media

The download location for SQL Server depends on the edition:

Other SQL Server components can be found here:

SQL Server installation

Article Description
Installation Wizard Install SQL Server using the Installation Wizard GUI launched from the setup.exe setup media.
Command Prompt Sample syntax and installation parameters for running a SQL Server installation from the command prompt.
Server Core Install SQL Server on Windows Server Core.
Check Parameters for the System Configuration Checker Discusses the function of the System Configuration Checker (SCC).
Configuration File Sample syntax and installation parameters for running Setup through a configuration file.
SysPrep Sample syntax and installation parameters for running Setup through SysPrep.
Add Features to an Instance Update components of an existing instance of SQL Server.
SQL Server Failover Cluster Installation Install a SQL Server failover cluster instance.
Repair a Failed SQL Server Installation Repair a corrupt SQL Server installation.
Rename a computer with SQL Server Update system metadata that is stored in sys.servers after the hostname of a computer hosting a stand-alone instance of SQL Server has been renamed.
Install SQL Server Servicing Updates Install updates for SQL Server.
Setup Log Files View and read the errors in the SQL Server setup log files.
Validate an 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.

Individual component installation

Article Description
SQL Server Database Engine Install and configure the SQL Server Database Engine.
SQL Server Replication Install and configure SQL Server Replication.
Distributed Replay Lists articles to install the Distributed Replay feature.
SQL Server Management Tools with SSMS Install and configure SQL Server management tools.
SQL Server PowerShell Considerations for installing SQL Server PowerShell components.

SQL Server configuration

Article Description
Configure Windows Firewall (SQL Server) Overview of firewall configuration and how to configure the Windows firewall to allow access to SQL Server.
Configure the Windows Firewall (SSAS) Configure both port and firewall settings to allow access to Analysis Services or Power Pivot for SharePoint.
Configure a Multi-Homed Computer 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.

See also

Upgrade SQL Server
Uninstall SQL Server
Install SQL Server Reporting Services (SSRS) Install SQL Server Analysis Services (SSAS) Install SQL Server Business Intelligence Features
High Availability Solutions (SQL Server)