install-sql-server-management-tools.md

title	Install SQL Server Management Tools | Microsoft Docs
ms.custom
ms.date	05/24/2017
ms.prod	sql-server-2014
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	SQL Server Management Tools
ms.assetid	af68d59a-a04d-4f23-9967-ad4ee2e63381
caps.latest.revision	17
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

Install SQL Server Management Tools

[!INCLUDEssNoVersion] Management tools include the following components:

• [!INCLUDEssManStudioFull]

• [!INCLUDEssSqlProfiler]

• [!INCLUDEssNoVersion] Database Tuning Advisor

• Command prompt tools, such as sqlcmd.exe and osql.exe.

• [!INCLUDEssBIDevStudioFull] add-ins to [!INCLUDEmsCoName] [!INCLUDEvsprvs]

Note that [!INCLUDEssBIDevStudioFull] is a separate option during [!INCLUDEssNoVersion] installation.

Regardless of how many instances of [!INCLUDEssNoVersion], [!INCLUDEssASnoversion], or [!INCLUDEssRSnoversion] are installed on a computer, only one copy of [!INCLUDEssCurrent] Management Tools will be installed.

[!INCLUDEssCurrent] Management Tools can run side-by-side on the same computer with earlier versions of [!INCLUDEssNoVersion] Management Tools.

See Also

Features Supported by the Editions of SQL Server 2014
Editions and Components of SQL Server 2014
Install SQL Server 2014 from the Installation Wizard (Setup)
Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)