Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
Cannot retrieve contributors at this time
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
SQL Server installation guide
An index of content that helps you install SQL Server and associated components using options such as the installation wizard, command prompt, or sysprep.
AdventureWorks sample database
installing SQL Server, preparing to install
installation [SQL Server]

SQL Server installation guide

[!INCLUDE SQL Server - Windows Only]

This article is an index of content that provides guidance for installing [!INCLUDEssnoversion] on Windows.

For other deployment scenarios, see:

Beginning with [!INCLUDEsssql16-md], [!INCLUDEssnoversion] is only available as a 64-bit application. Here are important details about how to get [!INCLUDEssnoversion] and how to install it.

Get started

  • Editions and features: Review the supported features for the different editions and versions of [!INCLUDEssnoversion] to determine which best suits your business needs.

    • [[!INCLUDEsssql22-md]](../../sql-server/editions-and-components-of-sql-server-2022.md)
    • [[!INCLUDEsssql19-md]](../../sql-server/editions-and-components-of-sql-server-2019.md)
    • [[!INCLUDEsssql17-md]](../../sql-server/editions-and-components-of-sql-server-2017.md)
    • [[!INCLUDEsssql16-md]](../../sql-server/editions-and-components-of-sql-server-2016.md)
    • [[!INCLUDEss2014]](/previous-versions/sql/2014/getting-started/features-supported-by-the-editions-of-sql-server-2014)
  • Requirements: Review hardware and software installation requirements for SQL Server 2016 and SQL Server 2017, SQL Server 2019, SQL Server 2022, or SQL Server on Linux, as well as system configuration checks, and security considerations in Planning a SQL Server Installation

  • Sample databases and sample code aren't installed as part of [!INCLUDEssnoversion] Setup by default, but can be installed for non-Express editions of [!INCLUDEssnoversion]. For more information, see Microsoft SQL samples.

Installation media

The download location for [!INCLUDEssnoversion] depends on the edition:

Other [!INCLUDEssnoversion] components can be found here:


  • Installation fails if you launch setup through Remote Desktop Connection with the media on a local resource in the RDC client. To install remotely the media must be on a network share or local to the physical or virtual machine. [!INCLUDEssNoVersion] installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine.

  • [!INCLUDEssNoVersion] Setup installs the following software components required by the product:

SQL Server installation

Article Description
Installation Wizard Install [!INCLUDEssnoversion] using the Installation Wizard GUI launched from the setup.exe setup media.
Command Prompt Sample syntax and installation parameters for running a [!INCLUDEssnoversion] installation from the command prompt.
Server Core Install [!INCLUDEssnoversion] 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 [!INCLUDEssnoversion].
SQL Server Failover Cluster Installation Install a SQL Server failover cluster instance.
Repair a Failed SQL Server Installation Repair a corrupt [!INCLUDEssnoversion] 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 [!INCLUDEssnoversion].
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 [!INCLUDEssNoVersion] and the [!INCLUDEssNoVersion] features installed on the computer.

Individual component installation

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

1 Distributed Replay is deprecated in [!INCLUDE sssql22-md].

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 [!INCLUDEssnoversion].
Configure the Windows Firewall (SSAS) Configure both port and firewall settings to allow access to [!INCLUDEssASnoversion] or [!INCLUDEpower-pivot-md] for SharePoint.
Configure a Multi-Homed Computer Configure [!INCLUDEssNoVersion] and Windows Firewall with Advanced Security to provide for network connections to an instance of [!INCLUDEssNoVersion] in a multi-homed environment.

See also