Professional Microsoft® SQL Server® 2008 Administration

4.1. Configuration Tools

Now that you have SQL Server installed, or have upgraded to SQL Server 2008, it probably isn't configured exactly for your needs out of the box. In SQL Server 2008, Microsoft has chosen to increase the out of the box security of SQL Server dramatically by turning off features after installation, thereby reducing the software footprint. The features turned off vary based on the edition of SQL Server. For example, TCP/IP is disabled in Developer Edition by default, and every edition has CLR integration turned off. This makes the environment more usable for you as an administrator, as features you don't care about are not crowding your administration screen. It also reduces the options that a hacker can use to penetrate your system.

4.1.1. SQL Server Configuration Manager

The SQL Server Configuration Manager configures the SQL Server services much like the Services applet in the control panel, but it has much more functionality than the applet. For example, the program can also change what ports SQL Server listens on and what protocols each instance uses. You can open the program (see Figure 4-1) from Start All Programs Microsoft SQL Server 2008 Configuration ...