Discontinued SQL Server Features in SQL Server 2008

SQL Server Setup

This topic describes features that are no longer available in SQL Server 2008.

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 the February 2008 CTP.

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.

SKUUPGRADE

No equivalent in this release.

UPGRADE

/ACTION=Upgrade and /FEATURES

USESYSDB

No equivalent in this release.

1These parameters are valid only for installation.

For more information, see How to: Install SQL Server 2008 from the Command Prompt.