Professional Microsoft® SQL Server® 2008 Administration

2.5. Post-Install Configuration

Now that you have your SQL Server components installed, you will probably need to do some additional configuration. Beginning with SQL Server 2005, Microsoft and the world have taken a more serious approach to security. In the past, almost everything was enabled by default. We have learned that it is better to leave most things turned off, so you must make a decision to implement the features and capabilities you need. Microsoft calls this "secure by default."

In SQL Server 2008, the Surface Area Configuration tool, which was used to enable given features in SQL Server 2005, has been discontinued. The following table shows how to perform tasks that used to be performed by Surface Area Configuration in a new manner.

Settings and Component Features	How to Configure
Protocols, and connection and startup options	Use SQL Server Configuration Manager.
Database Engine features	Use Declarative Management Framework.
SSAS features	Use the property settings in SQL Server Management Studio.
SSRS features	Edit the RSReportServer.config configuration file.

2.5.1. SQL Server Configuration Manager

The SQL Server Configuration Manager tool enables you to specify SQL Server Services options and whether the service starts automatically or manually. You can also stop and start services here, as the Service Manager in the toolbar no longer appears in SQL Server 2000. This program also includes a couple of very helpful features. Although I have not mentioned it before, I am ...