SQL Server 2005 provides a number of tools for configuration of its components. The configuration tasks are tasks you perform after installing an instance of SQL Server. The configuration tasks cover a wide variety of things in SQL Server 2005. Some configuration tasks change attributes of the Windows services associated with SQL Server components. Others change the Registry and file settings that affect networking and connectivity behavior. Although there is no crisp distinction between configuration, management, and administration tasks, it is important for you to understand the tasks that SQL Server treats as configuration tasks so you can start with the right tools. Here are the types of tasks that are classified as configuration tasks:
We've broken this chapter into two main parts to give you a broad perspective on configuration. The first part briefly describes the configuration tools and their architecture. The second part focuses on the tasks and scenarios that are enabled by these tools. As database system professionals, you can apply these tasks to the everyday scenarios you encounter on the job.