Skip to content

install-sql-server-database-engine.md

Latest commit

 

History

History
79 lines (55 loc) · 4.52 KB

install-sql-server-database-engine.md

File metadata and controls

79 lines (55 loc) · 4.52 KB
title Install SQL Server Database Engine
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.
author rwestMSFT
ms.author randolphwest
ms.date 06/03/2025
ms.service sql
ms.subservice install
ms.topic install-set-up-deploy
ms.custom
intro-installation
helpviewer_keywords
Database Engine [SQL Server], installing
monikerRange >=sql-server-2016

Install SQL Server Database Engine

[!INCLUDE SQL Server -Windows Only]

Overview

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

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

Important

For local installations, you must run Setup as an administrator. If you install [!INCLUDE ssNoVersion] 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 SQL Server Database Engine on the Components to Install page of the [!INCLUDE ssNoVersion] Installation Wizard:

::: moniker range=">=sql-server-ver15"

::: moniker range=">=sql-server-2017 <=sql-server-2017"

::: moniker range=">=sql-server-2016 <=sql-server-2016"

  • 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 doesn't install the Data Quality Services (DQS) server. You'll have to perform additional steps post installation to install DQS server. For more information, see Install Data Quality Services.

  • Data virtualization with PolyBase in SQL Server is an optional component. In [!INCLUDE sssql19-md], a Java connector for HDFS data sources is also available.

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

  • Data Quality Client
  • [!INCLUDE ssISnoversion]
  • Connectivity components
  • Programming models
  • Management tools
  • [!INCLUDE ssManStudio]
  • Documentation components

Note

By default, sample databases and sample code aren't installed as part of [!INCLUDE ssNoVersion] Setup. To install sample databases and sample code, see SQL samples. See older samples on CodePlex.

Related content