Skip to content

install-sql-server.md

Latest commit

 

History

History
102 lines (76 loc) · 9.17 KB

install-sql-server.md

File metadata and controls

102 lines (76 loc) · 9.17 KB
title Install SQL Server | Microsoft Docs
ms.custom
SQL2016_New_Updated
ms.date 07/24/2017
ms.prod
sql-server-2016
sql-server-2017
ms.reviewer
ms.suite
ms.technology
setup-install
ms.tgt_pltfrm
ms.topic get-started-article
helpviewer_keywords
AdventureWorks sample database
installing SQL Server, preparing to install
installation [SQL Server]
ms.assetid 0300e777-d56b-4d10-9c33-c9ebd2489ee5
caps.latest.revision 59
author MikeRayMSFT
ms.author mikeray
manager jhubbard

Install SQL Server

For content related to previous versions of SQL Server, see Install SQL Server 2014.

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

Installation details

  • Options: Install through the Installation Wizard, a command prompt, or through sysprep

  • Requirements: Before you install, take some time to review installation requirements, system configuration checks, and security considerations in Planning a SQL Server Installation

  • Process: See Installation for SQL Server for complete instructions on the installation process

  • Sample databases and sample code:

    • They are not installed as part of SQL Server setup by default
    • To install them for non-Express editions of SQL Server, see the GitHub

Get the installation media

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

  • SQL Server Enterprise, Standard, and Express Editions are licensed for production use. For Enterprise and Standard Editions, contact your software vendor for the installation media. You can find purchasing information and a directory of Microsoft partners on the Microsoft purchasing website.

  • Free editions are available at SQL Server Downloads.

How to install [!INCLUDEssnoversion]

Title Description
[Install [!INCLUDEssnoversion] on Server Core](../../database-engine/install-windows/install-sql-server-on-server-core.md) Review this topic to install [!INCLUDEssnoversion] on Windows Server Core.
Check Parameters for the System Configuration Checker Discusses the function of the System Configuration Checker (SCC).
[Install [!INCLUDEssnoversion] from the Installation Wizard (Setup)](../../database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup.md) Procedural topic for a typical [!INCLUDEssNoVersion] installation by using the Installation Wizard.
[Install [!INCLUDEssnoversion] from the Command Prompt](../../database-engine/install-windows/install-sql-server-2016-from-the-command-prompt.md) Procedural topic that provides sample syntax and installation parameters for running unattended Setup.
[Install [!INCLUDEssnoversion] Using a Configuration File](../../database-engine/install-windows/install-sql-server-2016-using-a-configuration-file.md) Procedural topic that provides sample syntax and installation parameters for running Setup through a configuration file.
[Install [!INCLUDEssnoversion] Using SysPrep](../../database-engine/install-windows/install-sql-server-using-sysprep.md) Procedural topic that provides sample syntax and installation parameters for running Setup through SysPrep.
[Add Features to an Instance of [!INCLUDEssnoversion] (Setup)](../../database-engine/install-windows/add-features-to-an-instance-of-sql-server-2016-setup.md) Procedural topic for updating components of an existing instance of [!INCLUDEssnoversion].
[Repair a Failed [!INCLUDEssnoversion] Installation](../../database-engine/install-windows/repair-a-failed-sql-server-installation.md) Procedural topic for repairing a corrupt [!INCLUDEssnoversion] installation.
Rename a Computer that Hosts a Stand-Alone Instance of SQL Server Procedural topic for updating system metadata that is stored in sys.servers.
[Install [!INCLUDEssnoversion] Servicing Updates](../../database-engine/install-windows/install-sql-server-servicing-updates.md) Procedural topic for installing updates for [!INCLUDEssnoversion].
View and Read SQL Server Setup Log Files Procedural topic for checking errors in setup log files.
Validate a SQL Server Installation Review the use of the SQL Discovery report to verify the version of [!INCLUDEssNoVersion] and the [!INCLUDEssNoVersion] features installed on the computer.

How to install individual components

Topic Description
Install SQL Server Database Engine Describes how to install and configure the [!INCLUDEssDEnoversion].
Install SQL Server Replication Describes how to install and configure [!INCLUDEssNoVersion] Replication.
Install Distributed Replay - Overview Lists down the topics to install the Distributed Replay feature.
Install SQL Server Management Tools with SSMS Describes how to install and configure [!INCLUDEssNoVersion] management tools.
Install SQL Server PowerShell Describes the considerations for installing [!INCLUDEssNoVersion] PowerShell components.

How to configure SQL Server

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 [!INCLUDEssNoVersion] and Windows Firewall with Advanced Security to provide for network connections to an instance of [!INCLUDEssNoVersion] 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 [!INCLUDEssASnoversion] or [!INCLUDEssGemini] for SharePoint.

Related sections

[Editions and Supported Features for [!INCLUDEssnoversion]](../../sql-server/editions-and-supported-features-for-sql-server-2016.md)
[Install [!INCLUDEssnoversion] Business Intelligence Features](../../sql-server/install/install-sql-server-business-intelligence-features.md)
SQL Server Failover Cluster Installation

See also

Planning a SQL Server Installation
[Upgrade to [!INCLUDEssnoversion]](../../database-engine/install-windows/upgrade-sql-server.md)
[Uninstall [!INCLUDEssnoversion]](../../sql-server/install/uninstall-sql-server.md)
High Availability Solutions (SQL Server)