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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.