Skip to content

discontinued-sql-server-features-in-sql-server-2014.md

Latest commit

 

History

History
79 lines (61 loc) · 6.45 KB

discontinued-sql-server-features-in-sql-server-2014.md

File metadata and controls

79 lines (61 loc) · 6.45 KB
title Discontinued SQL Server Features in SQL Server 2014 | Microsoft Docs
ms.custom
ms.date 05/24/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
ms.assetid 0678bfbc-5d3f-44f4-89c0-13e8e52404da
author mightypen
ms.author genemi
manager craigg

Discontinued SQL Server Features in SQL Server 2014

This topic describes features that are no longer available after you upgrade to [!INCLUDEssCurrent].

Discontinued Features in [!INCLUDEssSQL14]

No discontinued features in [!INCLUDEssSQL14].

Discontinued Features in [!INCLUDEssSQL11]

Discontinued Active Directory Helper Service

The Active Directory Helper service and the related components has been removed. The following table lists the associated components that are removed are a result:

Category Discontinued Feature Replacement
System Stored Procedures sp_ActiveDirectory_Obj

sp_ActiveDirectory_SCP

sp_ActiveDirectory_Start		 No replacement available

Discontinued Features in SQL Server 2008 R2

64-bit Platform Support in Reporting Services

Starting in [!INCLUDEssKilimanjaro], the [!INCLUDEssRSnoversion] component no longer supports Itanium-based servers running Windows Server 2003 or Windows Server 2003 R2. [!INCLUDEssRSnoversion] continues to support other 64-bit operating systems, including Windows Server°2008 for Itanium-Based Systems and Windows Server°2008°R2 for Itanium-Based Systems. To upgrade to [!INCLUDEssKilimanjaro] from a [!INCLUDEssKatmai] installation with [!INCLUDEssRSnoversion] on an Itanium-based system edition of Windows Server 2003 or Windows Server 2003 R2, you must first upgrade the operating system.

Discontinued Features in SQL Server 2008

Discontinued SQL-DMO from SQL Server Express Installation

SQL-DMO for [!INCLUDEssNoVersion] has been removed from [!INCLUDEssExpressEd10]. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO for [!INCLUDEssNoVersion] Express, install the Backward Compatibility Components from the [!INCLUDEssVersion2005] feature pack from the Microsoft Download Center. Use [!INCLUDEssNoVersion] Management Objects (SMO) for new development work.

Discontinued Option for Web Assistant

The sp_configure option to enable Web Assistant has been removed from [!INCLUDEssKatmai]. We recommend that you use [!INCLUDEssRSnoversion] instead.

Surface Area Configuration Tool

The Surface Area Configuration tool is discontinued for [!INCLUDEssKatmai]. The following table shows what you can use to configure settings, options, and component features in this release.

Replacement settings and component features How to configure
Protocols, connection, and startup options Use [!INCLUDEssNoVersion] Configuration Manager.
[!INCLUDEssDE] features Use Policy-Based Management, the property settings in [!INCLUDEssManStudioFull], or sp_Configure.
[!INCLUDEssASnoversion] features Use the property settings in [!INCLUDEssManStudioFull].
[!INCLUDEssRSnoversion] - EnableIntegrated Security property Use the property settings in [!INCLUDEssManStudioFull].
[!INCLUDEssRSnoversion] - "Schedule events and report delivery" and "Web service and HTTP access" Edit the RSReportServer.config configuration file.
Command line options No support in this release.
SOAP and [!INCLUDEssSB] endpoints Use CREATE ENDPOINTand ALTER ENDPOINT.

Discontinued Command Prompt Parameters for SQL Server Setup

The following table shows Setup command prompt parameters from earlier versions of [!INCLUDEssNoVersion] that are not supported in [!INCLUDEssKatmai].

Discontinued parameter Replacement parameter
ADDLOCAL /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/2014/getting-started/Uninstall and /FEATURES
DISABLENETWORKPROTOCOLS /TCPENABLED for TCP/IP1
DISABLENETWORKPROTOCOLS /NPENABLED for Named Pipes1
INSTALLSQLDATADIR /SQLUSERDBDIR

/SQLUSERDBLOGDIR

/SQLBACKUPDIR

/SQLTEMPDBDIR

/SQLTEMPDBLOGDIR
REINSTALL No equivalent in this release.
REINSTALLMODE No equivalent in this release.
REMOVE /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/2014/getting-started/Uninstall and /FEATURES
SAMPLEDATABASE No equivalent in this release.
SAVESYSDB No equivalent in this release.
SKUUPGRADE2 No equivalent in this release.
UPGRADE /ACTION=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/2014/getting-started/Upgrade and /FEATURES
USESYSDB No equivalent in this release.

1These parameters are valid only for installation.

2Starting [!INCLUDEssKatmai], specify /Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/e2c3003d4728ce29584144286df875611d95f6d4/docs/2014/getting-started/EditionUpgrade, to upgrade an existing edition of [!INCLUDEssNoVersion] to a different edition any time without using the original installation media. For more information about the supported version and edition upgrades, see Supported Version and Edition Upgrades.

For more information, see Install SQL Server 2014 from the Command Prompt.