Skip to main content
TechNet
Install SQL Server 2016
 

Published: July 21, 2016

Updated: July 21, 2016

Applies To: SQL Server 2016

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

System_CAPS_ICON_note.jpg Note


SQL Server is a 64-bit application. Editions of SQL Server are installed either through the Installation Wizard, a command prompt, or through sysprep. For more information about SQL Server components, see Editions and Components of SQL Server 2016 and Features Supported by the Editions of SQL Server 2016.

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 2016.

Get the SQL Server 2016 Installation Media

The download location for SQL Server 2016 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.

The following table contains links to various free editions of SQL Server:

EditionDescription
Developer EditionFree, full-featured set of SQL Server 2016 Enterprise edition software that allows developers to build, test, and demonstrate applications in a non-production environment.
Express EditionEntry-level, free database that is ideal for deploying small databases in production environments. Build desktop, and small server, data-driven applications up to 10 GB of disk size.
Evaluation EditionFull feature set of SQL Server Enterprise edition software that provides a 180 day evaluation period.

For more information about which features are available by edition, see Features Supported by the Edition of SQL Server 2016.

Installing SQL Server 2016 Components

TopicDescription
Install SQL Server Database EngineDescribes how to install and configure the SQL Server Database Engine.
Install SQL Server ReplicationDescribes how to install and configure SQL Server Replication.
Install Distributed Replay - OverviewLists down the topics to install the Distributed Replay feature.
Install SQL Server Management Tools with SSMSDescribes how to install and configure SQL Server management tools.
Install SQL Server PowerShellDescribes the considerations for installing SQL Server PowerShell components.

Installing SQL Server 2016

TitleDescription
Install SQL Server 2016 on Server CoreReview this topic to install SQL Server 2016 on Windows Server Core.
Check Parameters for the System Configuration CheckerDiscusses the function of the System Configuration Checker (SCC).
Install SQL Server 2016 from the Installation Wizard (Setup)Procedural topic for a typical SQL Server installation by using the Installation Wizard.
Install SQL Server 2016 from the Command PromptProcedural topic that provides sample syntax and installation parameters for running unattended Setup.
Install SQL Server 2016 Using a Configuration FileProcedural topic that provides sample syntax and installation parameters for running Setup through a configuration file.
Install SQL Server 2016 Using SysPrepProcedural topic that provides sample syntax and installation parameters for running Setup through SysPrep.
Add Features to an Instance of SQL Server 2016 (Setup)Procedural topic for updating components of an existing instance of SQL Server 2016.
Repair a Failed SQL Server 2016 InstallationProcedural topic for repairing a corrupt SQL Server 2016 installation.
Rename a Computer that Hosts a Stand-Alone Instance of SQL ServerProcedural topic for updating system metadata that is stored in sys.servers.
Install SQL Server 2016 Servicing UpdatesProcedural topic for installing updates for SQL Server 2016.
View and Read SQL Server Setup Log FilesProcedural topic for checking errors in setup log files.
Validate a SQL Server InstallationReview the use of the SQL Discovery report to verify the version of SQL Server and the SQL Server features installed on the computer.

Configuration Topics

TopicDescription
Configure the Windows Firewall to Allow SQL Server AccessThis topic provides an overview of firewall configuration and how to configure the Windows firewall.
Configure a Multi-Homed Computer for SQL Server AccessThis 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 AccessYou can follow the steps provided in this topic to configure both port and firewall settings to allow access to Analysis Services or Power Pivot for SharePoint.

Install SQL Server 2016 Business Intelligence 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.

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