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
Reference
Features Supported by the Editions of SQL Server 2005
Other Resources
Administering the Database Engine
About SQL Server Agent