Section 2.2. SQL Server Configuration Manager

2.2. SQL Server Configuration Manager

SQL Server 2005 runs as a collection of servicesapplication types that run in the system background. SQL Server Configuration Manager is a Microsoft Management Console (MMC) snap-in that lets you start, stop, pause, resume, restart, and configure services, including:

• SQL Server

• SQL Server Agent

• SQL Server Analysis Services

• SQL Server Browser

• SQL Server Full-Text Search

• SQL Server Integration Services

• SQL Server Reporting Services

Start SQL Server Configuration Manager by selecting Start All Programs Microsoft SQL Server 2005 Configuration Tools SQL Server Configuration Manager from the taskbar. Figure 2-17 shows SQL Server Configuration Manager.

Figure 2-17. SQL Server Configuration Manager

In addition to managing services, SQL Server Management Studio lets you manage server and client network protocolsyou can enable or disable protocols and force protocol encryptionand manage server aliases.

SQL Server Configuration Manager combines the functionality of the following: Server Network Utility, Client Network Utility, and Service Manager from SQL Server 2000.