Install SQL Server Database Engine

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The Database Engine component of SQL Server is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications in your enterprise.

SQL Server supports up to 50 instances of the Database Engine on a single computer. To create a typical SQL Server installation, see Install SQL Server from the Installation Wizard (Setup).

Important

For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

The following features are installed when you select SQL Server Database Engine on the Components to Install page of the SQL Server Installation Wizard:

  • Database Engine

  • Replication - is an optional component

  • Full-Text Search - is an optional component

  • Data Quality Services – is an optional component

    Note

    In this release, selecting the Data Quality Services check box in setup does not install the Data Quality Services (DQS) server. You will have to perform additional steps post installation to install DQS server. For more information, see Install Data Quality Services.

    The following additional features are options for many typical user scenarios:

  • Data Quality Client

  • Integration Services

  • Connectivity components

  • Programming models

  • Management tools

  • Management Studio

  • Documentation components

Note

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code, see Microsoft SQL Server Samples. See older samples on CodePlex.

See also

Editions and supported features of SQL Server 2017
Planning a SQL Server Installation
High Availability Solutions (SQL Server)
Upgrade SQL Server Using the Installation Wizard (Setup)