Configuring a SQL Server Installation

After Setup completes the installation of Microsoft SQL Server 2005, you can further configure SQL Server using graphical and command-prompt utilities. The following table describes support for tools used to manage an instance of SQL Server 2005.

Tool or utility Description

SQL Server Management Studio

SQL Server Management Studio is used for editing and executing queries, and for launching standard wizard tasks. For more information, see Introducing SQL Server Management Studio.

SQL Server Profiler

SQL Server Profiler provides a graphical user interface for monitoring an instance of the SQL Server Database Engine or an instance of Analysis Services. For more information, see Introducing SQL Server Profiler.

Database Engine Tuning Advisor

Database Engine Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions. For more information, see Using Database Engine Tuning Advisor.

Business Intelligence Development Studio

Business Intelligence Development Studio is an integrated development environment for Analysis Services and Integration Services solutions. For more information, see Introducing Business Intelligence Development Studio.

Command Prompt Utilities

Manage SQL Server objects from the command prompt. For more information, see Command Prompt Utilities.

SQL Server Configuration Manager

Manage server and client network configuration settings. For more information, see SQL Server Configuration Manager.

Import and Export Data

Integration Services provides a set of graphical tools and programmable objects for moving, copying, and transforming data. For more information, see Integration Services Overview.

SQL Server Setup

Install, upgrade to, or change components in an instance of SQL Server 2005. For more information, see Database Engine Installation How-to Topics.

Default Configuration

Default configurations for new instances of SQL Server 2005 disable some features and components to reduce the attackable surface area of the product.

The following components and features are off by default:

  • Integration Services
  • SQL Server Agent
  • SQL Server Browser
  • Full-Text Search

For more information, see SQL Server Surface Area Configuration.

See Also


Features Supported by the Editions of SQL Server 2005

Other Resources

Administering the Database Engine
About SQL Server Agent

Help and Information

Getting SQL Server 2005 Assistance