Components to Install

  • Article

Use the check boxes on the Components to Install page of the Microsoft SQL Server Installation Wizard to select component groups for your SQL Server installation.

Options

A description for each component group appears in the Components to be Installed pane when you select it. You can select any combination of check boxes.

To select individual features for your installation, click Advanced. To install components to a custom destination folder or to see the disk space requirements for an individual component or feature, click Advanced.

Select this component group To install these components and features

SQL Server Database Services

SQL Server Database Engine includes the following technologies:

  • The Database Engine is the core service for storing, processing, and securing data.
  • Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.
  • Full-Text Search provides functionality to issue full-text queries against plain character-based data in SQL Server tables.
  • Tools for managing relational and XML data.

Analysis Services

Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications.

Reporting Services1,2,3,4

Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications.

Notification Services

Notification Services is a platform for developing and deploying applications that send personalized, timely information to subscribers on a variety of devices.

Integration Services

Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data.

Workstation Components, Books Online, and Development Tools5,6

Installs components for communication between clients and servers, including network libraries for DB-Library, OLEDB for OLAP, ODBC, ADODB, and ADOMD+.

Management Tools

  • SQL Server Management Studio (SSMS), new in Microsoft SQL Server 2005, is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment that provides SQL Server access to developers and administrators of all skill levels.
  • SQL Server Configuration Manager provides basic configuration management for SQL Server services, server protocols, client protocols, and client aliases.
  • SQL Server Profiler provides a graphical user interface for monitoring an instance of the Database Engine or an instance of Analysis Services.
  • Database Engine Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
  • Replication Monitor allows you to track the status and performance of publications and subscriptions across a replication topology.
  • SQLXML Client Features

Documentation

  • SQL Server Books Online is the core documentation for SQL Server 2005.
  • Software development kits

Development Tools

  • The Business Intelligence Development Studio is an integrated development environment for Analysis Services, Reporting Services, and Integration Services solutions.

1Setup does not configure load-balancing and single-URL addressing for multiple nodes in a Report Server scale-out deployment. To complete a scale-out deployment, you must use Windows Server, Microsoft Application Center, or third-party cluster management software. For more information about setting up Web farm deployment, see Configuring a Report Server Scale-Out Deployment.

2Reporting Services is not available if Internet Information Services (IIS) 5.0 or higher is not installed. Microsoft Internet Explorer 6.0 Service Pack (SP) 1 is required for the Report Designer component of Reporting Services.

3For Reporting Services (64-bit) installations on 64-bit servers, the 64-bit version of ASP.NET must be installed. For Reporting Services (32-bit) installations on 32-bit systems, and on the 32-bit subsystem (WOW64) of a 64-bit server, the 32-bit version of ASP.NET must be installed.

4Reporting Services is not supported in side-by-side configurations on the 64-bit platform and on the 32-bit subsystem (WOW64) of a 64-bit server at the same time.

5Internet Explorer 6.0 SP1 is required for SQL Server Management Studio installations.

6Internet Explorer 6.0 SP1 is required for Business Intelligence Development Studio installations.

Installing a Failover Cluster

When you select SQL Server or Analysis Services, if Setup detects that you are installing to a virtual server, the Create a SQL Server failover cluster or Create an Analysis Server failover cluster check boxes are enabled. You must select this option to install a failover cluster.

To upgrade a SQL Server instance to a SQL Server 2005 failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server 2005 failover cluster, install a new SQL Server 2005 failover cluster and then migrate user databases from the stand-alone instance using the Copy Database Wizard. For more information on upgrade, see How to: Upgrade to a SQL Server 2005 Failover Cluster Instance (Setup). For more information on database migration, see Using the Copy Database Wizard.

Installing AdventureWorks Sample Databases

AdventureWorks, AdventureWorksDW, AdventureWorksAS, and related samples are not installed by default. To install one or more of these features, select Workstation Components, Books Online, and Development Tools from the Components to Install page during SQL Server 2005 Setup, and then click Advanced. Expand Documentation and Samples, and then select the databases and samples to be installed.

See Also

Reference

Editions and Components of SQL Server 2005
Feature Selection

Help and Information

Getting SQL Server 2005 Assistance