O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 FeaturesHow to Configure
Protocols, and connection and startup optionsUse SQL Server Configuration Manager.
Database Engine featuresUse Declarative Management Framework.
SSAS featuresUse the property settings in SQL Server Management Studio.
SSRS featuresEdit 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required