Share via


Feature Selection

Use the check boxes on the Feature Selection page of the SQL Server Installation wizard to select components for your SQL Server installation.

Installing SQL Server Features

On the Feature Selection page, the SQL Server features are separated into two main sections: Instance Features and Shared Features.

Instance Features refers to the components that are installed once for each instance so that you have multiple copies of them (one for each instance). Each instance can be a separate version that has a different patch level. When you install a patch, whether it is a service pack, a hotfix, or a cumulative update, it updates only the files for one instance on a given machine, plus the shared features if they have not already been updated.

Shared Features refers to features that are common across all instances on a given machine. Each of these shared features is designed to be backward compatible with supported SQL Server versions (service packs, cumulative updates, and hotfixes) that can install side by side.

Note

SQL Server SysPrep: The Database Engine and Reporting Services are the only SQL Server 2012 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 2012 using SysPrep (https://go.microsoft.com/fwlink/?LinkId=190965).

SQL Server Failover Clusters: The Database Engine and Analysis Services components are the only SQL Server 2012 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 (https://go.microsoft.com/fwlink/?LinkId=190953).

Instance Features

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.

Features

Description

Database Engine Services

SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, and the Data Quality Services (DQS) server.

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

  • Full-Text Search: Optional: Full-Text Search provides functionality to issue full-text queries against plain character-based data in SQL Server tables.

  • Data Quality Services: Optional: Data Quality Services (DQS) is a data-cleansing solution that enables you to discover inconsistent and incorrect data in your data source, and provides computer-assisted and interactive ways to cleanse your data. Select this check box to install DQS server. After the SQL Server installation completes, you have to run the DQSInstaller.exe file to complete the DQS server installation. If you installed the default instance of SQL server, this file is available at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn.

SQL Server Failover Clusters: Replication and Full-Text Search components are required, and automatically selected by Setup for SQL Server failover clustering installations when you select Database Engine Services.

Analysis Services

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

Reporting Services –Native

Reporting Services Native mode 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.

Important

  1. 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 (https://go.microsoft.com/fwlink/?LinkId=199448).

  2. For browser requirements of components, see Planning for Reporting Services and Power View Browser Support (SSRS 2012).

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

Shared Features

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

Feature

Description

Reporting Services – SharePoint

Reporting Services SharePoint mode is a server based application for creating, managing, and delivering reports to email, multiple file formats, and interactive Web-based formations. SharePoint mode integrates the report viewing and report management experience with SharePoint products. For more information, see Reporting Services Report Server (SharePoint Mode).

Reporting Services Add-in for SharePoint Products

Reporting Services Add-in for SharePoint products includes management and user interface components to integrate a SharePoint product with an Reporting Services report server in SharePoint mode. For more information, see Where to find the Reporting Services add-in for SharePoint Products.

Data Quality Client

Data Quality Client is a standalone application that connects to the DQS server, and provides an intuitive graphical user interface to perform data-cleansing and data-matching operations, and to perform administrative tasks in DQS.

SQL Server Data Tools1

SQL Server Data Tools (SSDT) provides an IDE for building solutions for the Business Intelligence components: Analysis Services, Reporting Services, and Integration Services.

(Formerly called Business Intelligence Development Studio).

SSDT also includes “Database Projects”, which provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.

Client Tools Connectivity

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

Integration Services

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:

Client Tools SDK

Includes the software development kit containing resources for programmers.

Documentation Components

Documentation components include the components to view and manage help content.

Management Tools - Basic

Management Tools – Basic : This includes the following:

  • SQL Server Management Studio support for the SQL Server Database Engine, SQL Server Express, sqlcmd utility, and the SQL Server PowerShell provider

Management Tools – Complete : This includes the following components in addition to the components in the basic version:

  • SQL Server Management Studio support for Reporting Services, Analysis Services, and Integration Services

  • SQL Server Profiler

  • Database Engine Tuning Advisor

  • SQL Server Utility management

Distributed Replay Controller

The Distributed Replay controller orchestrates the actions of the distributed replay clients. There can only be one controller instance in each Distributed Replay environment. For more information, see SQL Server Distributed Replay (https://go.microsoft.com/fwlink/?LinkId=229847).

Distributed Replay Client

The Distributed Replay clients work together to simulate workloads against an instance of SQL Server. There can be one or more clients in each Distributed Replay environment. For more information, see SQL Server Distributed Replay (https://go.microsoft.com/fwlink/?LinkId=229847).

SQL Client Connectivity SDK

Includes SQL Server Native Client (ODBC/OLE DB) SDK for database application development.

Master Data Services

Master Data Services is a platform for integrating data from disparate systems across an organization into a single source of master data for accuracy and auditing purposes. The Master Data Services option installs Master Data Services Configuration Manager, assemblies, a Windows PowerShell snap-in, and folders and files for Web applications and services.

LocalDB

LocalDB is an execution mode of SQL Server Express targeted to program developers. Initiated by a special connection string, the necessary SQL Server infrastructure is automatically created and started, enabling the application to use the database without configuration or management tasks.

1Internet Explorer 6.0 SP1 is required for SQL Server Data Tools (SSDT) installations.

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.

Installing AdventureWorks Sample Databases

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 Microsoft SQL Server Community Projects & Samples (https://go.microsoft.com/fwlink/?LinkId=87843).

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

See Also

Other Resources

Editions and Components of SQL Server 2012