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 |
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 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