| SQL Server Setup Help | |
| Surface Area Configuration for Features | |
See Also
|
|
|
| Configuring a SQL Server Installation > SQL Server Surface Area Configuration > |
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 Microsoft 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
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 |