Surface Area Configuration for Features

SQL Server 2008 Books Online

[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

Other Resources

SQL Server Surface Area Configuration Tools
Configuring SQL Server

Help and Information

Getting SQL Server 2008 Assistance