Skip to content

install-sql-server-database-engine.md

Latest commit

 

History

History
78 lines (56 loc) · 4.85 KB

install-sql-server-database-engine.md

File metadata and controls

78 lines (56 loc) · 4.85 KB
title Install SQL Server Database Engine | Microsoft Docs
description Learn about features that can be installed when you select SQL Server Database Engine from Components to Install of the SQL Server Installation Wizard.
ms.custom
ms.date 07/26/2019
ms.prod sql
ms.reviewer
ms.technology install
ms.topic conceptual
helpviewer_keywords
Database Engine [SQL Server], installing
ms.assetid d0876e7f-aa52-4dd7-bd5c-029e2ffded5f
author MashaMSFT
ms.author mathoma
monikerRange >=sql-server-2016||=sqlallproducts-allversions

Install SQL Server Database Engine

[!INCLUDE SQL Server -Windows Only]

Overview

The [!INCLUDEssDE] component of [!INCLUDEssNoVersion] is the core service for storing, processing, and securing data. The [!INCLUDEssDE] provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications in your enterprise.

[!INCLUDEssNoVersion] supports up to 50 instances of the [!INCLUDEssDE] on a single computer. To create a typical [!INCLUDEssNoVersion] installation, see Install SQL Server from the Installation Wizard (Setup).

Important

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

Features

The following features are installed when you select [!INCLUDEssNoVersion] Database Engine on the Components to Install page of the [!INCLUDEssNoVersion] Installation Wizard:

::: moniker range=">=sql-server-ver15||=sqlallproducts-allversions"

::: monikerRange=">=sql-server-2017 <=sql-server-2017||=sqlallproducts-allversions"

::: monikerRange=">=sql-server-2016 <=sql-server-2016||=sqlallproducts-allversions"

  • R Services (In-Database) - is an optional component ::: moniker-end

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

  • Polybase Query Service for External Data - is an optional component. Starting with SQL Server 2019, Java connector for HDFS data sources is also available.

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

  • Data Quality Client
  • [!INCLUDEssISnoversion]
  • Connectivity components
  • Programming models
  • Management tools
  • [!INCLUDEssManStudio]
  • Documentation components

Note

By default, sample databases and sample code are not installed as part of [!INCLUDEssNoVersion] 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)