Configuring the SQL Server Database Engine

After Setup completes the installation of SQL Server, 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.

Tool or utility


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 Using 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 Overview (Integration Services).

SQL Server Setup

Install, upgrade to, or change components in an instance of SQL Server. For more information, see How to: Install SQL Server 2008 R2 (Setup).

Default Configuration

Default configurations for new instances of SQL Server 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