| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
Upgrade SQL Server Management Tools |
This article describes support for upgrading SQL Server Management Tools and management components, such as SQL Server Agent. |
rwestMSFT |
randolphwest |
07/24/2017 |
sql |
install |
upgrade-and-migration-article |
|
>=sql-server-2016 |
[!INCLUDE SQL Server -Windows Only]
[!INCLUDEssnoversion] supports upgrade from [!INCLUDEsql2008-md] and later. This article documents support and behavior for upgrading [!INCLUDEssNoVersion] Management Tools and management components such as [!INCLUDEssNoVersion] Agent, Database Mail, Maintenance Plans, XPStar, and XPWeb.
Important
For local installations, you must run [!INCLUDEssNoVersion] Setup as an administrator. If you run [!INCLUDEssNoVersion] Setup from a remote share, you must use a domain account that has read and execute permissions on the remote share.
Consider the following issues before you upgrade to [!INCLUDEssnoversion]:
-
All TSX servers should be upgraded before the MSX server is upgraded. For more information about MSX/TSX in [!INCLUDEssNoVersion], see Automated Administration Across an Enterprise.
-
All components in an instance of [!INCLUDEssNoVersion] must be upgraded at the same time. Version numbers of the [!INCLUDEssDE], [!INCLUDEssASnoversion], and [!INCLUDEssRSnoversion] components must be the same in an instance of [!INCLUDEssnoversion].
-
You can add components to an existing installation of [!INCLUDEssNoVersion] at the time that you upgrade to [!INCLUDEssnoversion]. For more information, see Upgrade SQL Server 2016 Using the Installation Wizard (Setup).
-
[!INCLUDEssNoVersion] Client Tools, such as [!INCLUDEssManStudioFull], [!INCLUDEssSqlProfiler], the [!INCLUDEssDE] Tuning Advisor, sqlcmd, and osql are not upgraded to [!INCLUDEssnoversion]. Instead, Client Tools run side-by-side with tools from previous [!INCLUDEssNoVersion] versions. [!INCLUDEssnoversion] supports importing settings from earlier versions of [!INCLUDEssNoVersion] Client Tools.
-
Authentication from [!INCLUDEssNoVersion] Agent to [!INCLUDEssNoVersion] will be updated from [!INCLUDEssNoVersion] Authentication to Windows Authentication during upgrade. [!INCLUDEssNoVersion] Authentication is not supported in [!INCLUDEssnoversion].
-
Data for jobs and alerts will be preserved during upgrade to [!INCLUDEssnoversion].
-
If SQLMail is being used in the instance to be upgraded, associated XPs will be supported and enabled after the upgrade. Otherwise, they will be off.
-
Database Mail, also known as SQLiMail, will be upgraded with the [!INCLUDEssDE] component of [!INCLUDEssnoversion]. By default, Database Mail will be off after upgrade. Any schema updates should be reconciled with an update script after upgrade.
Supported Version and Edition Upgrades
Backward Compatibility_deleted
Upgrade SQL Server Using the Installation Wizard (Setup)