Discontinued SQL Server Features in SQL Server 2012

This topic describes features that are no longer available after you upgrade to SQL Server 2012.

If you are upgrading from SQL Server 2005, we recommend that you also review the content in the SQL Server 2008, and SQL Server 2008 R2 sections.

If you are upgrading from SQL Server 2008, we recommend that you also review the content in the SQL Server 2008 R2 section.

Discontinued Features in SQL Server 2012

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 SQL Server 2008 R2, the Reporting Services component no longer supports Itanium-based servers running Windows Server 2003 or Windows Server 2003 R2. Reporting Services 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 SQL Server 2008 R2 from a SQL Server 2008 installation with Reporting Services 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 SQL Server has been removed from SQL Server 2008 Express. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO for SQL Server Express, install the Backward Compatibility Components from the SQL Server 2005 feature pack from the Microsoft Download Center. Use SQL Server Management Objects (SMO) for new development work.

Discontinued Option for Web Assistant

The sp_configure option to enable Web Assistant has been removed from SQL Server 2008. We recommend that you use Reporting Services instead.

Surface Area Configuration Tool

The Surface Area Configuration tool (SAC) for SQL Server has been removed from SQL Server 2008. Replacement functionality in this release is as follows:

Category	Discontinued feature	Replacement
Tools	Surface Area Configuration tool	The Surface Area Configuration tool is discontinued for SQL Server 2008. The following table shows what you can use to configure settings, options, and component features in this release. Settings and component features How to configure Protocols, connection, and startup options Use SQL Server Configuration Manager. Database Engine features Use Policy-Based Management, the property settings in SQL Server Management Studio, or sp_Configure. Analysis Services features Use the property settings in SQL Server Management Studio. Reporting Services - EnableIntegrated Security property Use the property settings in SQL Server Management Studio. Reporting Services - "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 Service Broker 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 SQL Server that are not supported in SQL Server 2008.

Discontinued parameter	Replacement parameter
ADDLOCAL	/ACTION=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=Uninstall and /FEATURES
SAMPLEDATABASE	No equivalent in this release.
SAVESYSDB	No equivalent in this release.
SKUUPGRADE2	No equivalent in this release.
UPGRADE	/ACTION=Upgrade and /FEATURES
USESYSDB	No equivalent in this release.

1These parameters are valid only for installation.

2Starting SQL Server 2008, specify /Action=EditionUpgrade, to upgrade an existing edition of SQL Server 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 How to: Install SQL Server 2008 from the Command Prompt.