Using SQL Server Surface Area Configuration

SQL Server 2005 by default disables some features, services, and connections for new installations in order to reduce the attackable surface area and, thereby, help protect your system. This security scheme is new in SQL Server 2005 and is very different from earlier versions, which by default always enable all installed components.

The SQL Server Surface Area Configuration tool is a new configuration tool that ships with SQL Server 2005 and can be used to enable, disable, start, or stop features, services, and remote connectivity. This tool provides a single interface for managing Database Engine, Analysis Services, and Reporting Services features and can be used locally or from a remote server.

The following ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.