A description for each component group appears in the Description pane when you select it. You can select any combination of check boxes. To continue, you must make a selection.

SQL Server SysPrep: The Database Engine and Reporting Services are the only SQL Server 2008 R2 features that support SQL Server SysPrep. You can select these features and components during the prepare image step of the process. You cannot make the selection while completing a prepared image of SQL Server. For more information, see How to: Install SQL Server 2008 R2 using SysPrep.

SQL Server Failover Clusters: The Database Engine and Analysis Services components are the only SQL Server 2008 R2 features that support failover clustering. You can install other components, like Reporting Services or Integration Services, on a failover cluster node, but they are not cluster-aware, and their services do not fail over if the failover cluster node goes offline. For more information, see Getting Started with SQL Server Failover Clustering.

Component group	Components and features
Database Engine Services	The SQL Server Database Engine includes the following components: The Database Engine is the core service for storing, processing, and securing data. Replication: Optional: 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. SQL Server Failover Clusters: Replication is required and automatically selected by Setup for SQL Server failover clustering installations when you select Database Engine Services. Full-Text Search: Optional: Full-Text Search provides functionality to issue full-text queries against plain character-based data in SQL Server tables. SQL Server Failover Clusters: Full-Text Search is required and automatically selected by Setup for SQL Server failover clustering installations when you select Database Engine Services. 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 Services 2,3	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.
Integration Services	Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data.
Shared Features: Client Tools SQL Server Books Online Business Intelligence Development Studio 4,5 Integration Services	Client Tools includes components for communication between clients and servers, including network libraries for DB-Library, OLEDB for OLAP, ODBC, ADODB, and ADOMD+, and the following SQL Server Management Tools: SQL Server Management Studio (SSMS) 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 SQL Server Books Online is the core documentation for SQL Server. Business Intelligence Development Studio is an integrated development environment for Analysis Services, Reporting Services, and Integration Services solutions. Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data.
Client Tools Backward Compatibility	Client Tools Backward Compatibility includes the following components: SQL Distributed Management Objects (SQL-DMO). For more information, see Discontinued SQL Server Features in SQL Server 2008 R2. Decision Support Objects (DSO). For more information, see Breaking Changes to Analysis Services Features in SQL Server 2008 R2. Data Transformation Services (DTS). For more information, see Deprecated Integration Services Features in SQL Server 2008 R2.

¹Setup does not configure load-balancing and single-URL addressing for multiple nodes in a Reporting Services 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 Reporting Services for Scale-Out Deployment.

² Microsoft Internet Explorer 6.0 SP 1 is required for the Report Designer component of Reporting Services.

³ Reporting 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.

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

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

Features shared by all instances of SQL Server on a single computer are installed to a single directory. They include the following:

• Client Tools
  
• SQL Server Books Online
  
• Business Intelligence Development Studio
  
• Integration Services
  

By default, shared components are installed to %Program Files%Microsoft SQL Server\. To change the installation path, click the Browse button. If you change the installation path for one shared component, you also change it for other shared components. Subsequent installations will install shared components to the same location as the original installation.

On x64-based operating systems, you can specify where 64-bit components will be installed, and where on the WOW64 subsystem 32-bit components will be installed.

By default, sample databases and sample code are not installed as part of SQL Server Setup. For more information about installing sample databases and sample code, see the CodePlex Web site.

Additional information about samples is available after SQL Server 2008 R2 has been installed. From the Start menu, click All Programs, click Microsoft SQL Server 2008 R2, click Documentation and Tutorials, and then click Microsoft SQL Server Samples Overview.

Other Resources