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.
| 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 |
| 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 |
SQL Server Surface Area Configuration Tools
Configuring SQL Server