Surface Area Configuration for Features

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

The Surface Area Configuration for Features tool provides a single interface for enabling or disabling many Database Engine, Analysis Services, and Reporting Services features. Disabling unused features helps to secure your SQL Server installations by reducing the SQL Server surface area.

The tables below list the default for each setting and provide links to F1 Help topics.

Database Engine Feature Defaults

Setting Default value F1 Help topic

Ad hoc distributed queries

Disabled in new installations.

Surface Area Configuration for Features (Ad Hoc Remote Queries) - Database Engine

Common language runtime (CLR) integration

Disabled in new installations.

Surface Area Configuration for Features (CLR Integration) - Database Engine

Dedicated administrator connection (DAC)

Disabled in new installations.

Surface Area Configuration for Features (DAC) - Database Engine

Database Mail

Disabled in new installations.

Surface Area Configuration for Features (Database Mail) - Database Engine

Native XML Web services

Endpoints are not configured by default.

Surface Area Configuration for Features (Native XML Web Services) - Database Engine

OLE Automation stored procedures

Disabled in new installations.

Surface Area Configuration for Features (OLE Automation) - Database Engine

Service Broker

Endpoints are not configured by default.

Surface Area Configuration for Features (Service Broker) - Database Engine

SQL Mail

Disabled in new installations.

Surface Area Configuration for Features (SQL Mail) - Database Engine

Web Assistant stored procedures

Disabled in new installations.

Surface Area Configuration for Features (Web Assistant) - Database Engine

xp_cmdshell

Disabled in new installations.

Surface Area Configuration for Features (xp_cmdshell) - Database Engine

Analysis Services Feature Defaults

Setting Default value F1 Help topic

Ad hoc data mining queries

Disabled in new installations.

Surface Area Configuration for Features (Ad Hoc Data Mining Queries) - Analysis Services

Anonymous connections

Disabled in new installations.

Surface Area Configuration for Features (Anonymous Connections) - Analysis Services

Linked objects

Disabled in new installations.

Surface Area Configuration for Features (Linked Objects) - Analysis Services

User-defined functions

Disabled in new installations.

Surface Area Configuration for Features (User-Defined Functions) - Analysis Services

Reporting Services Feature Defaults

Feature Default setting F1 Help topic

Web service requests and HTTP access

Enabled in new installations.

Surface Area Configuration for Features (Web Service and HTTP Access) - Reporting Services

Scheduled events and report delivery

Enabled in new installations.

Surface Area Configuration for Features (Scheduled Events and Report Delivery) - Reporting Services

Windows Integrated Security

Enabled in new installations

Surface Area Configuration for Features (Windows Integrated Security) - Reporting Services

See Also

Other Resources

SQL Server Surface Area Configuration Tools
Configuring SQL Server

Help and Information

Getting SQL Server 2008 Assistance