Setup Role

Use this page to specify whether to use the Feature Selection page to select individual features, or to install using a setup role.

A setup role is a fixed selection of all the features and shared components that are required to implement a predefined SQL Server configuration.


SQL Server Feature Installation
Choose this option to select individual features and shared components. Instance features include Database Engine Services, Analysis Services (native mode), and Reporting Services.

SQL Server PowerPivot for SharePoint
Choose this option to install Analysis Services server components in a SharePoint 2010 farm. This option deploys the PowerPivot System Service and the Analysis Services server in a farm, enabling query and data processing for published Excel workbooks that contain embedded PowerPivot data.

Optionally, you can add a relational database engine instance to your installation if you require it to host databases in a SharePoint farm. If the farm is already configured, you can skip this option.

After Setup is finished, you must configure the software using one of the following approaches: PowerPivot Configuration tool, PowerShell cmdlets, or SharePoint 2010 Central Administration. In contrast with previous releases, Setup no longer performs any configuration tasks for a PowerPivot installation.

A role-based installation does not include the SQL Server PowerPivot for Excel client application. The client application is installed separately.

All Features With Defaults
Choose this setup role to install all features that are available for this release. Note that PowerPivot for SharePoint is excluded from this role. You must use the PowerPivot for SharePoint setup role to install that feature.

The Database Engine is configured to start using the NT AUTHORITY\NETWORK SERVICE account. The current user will be provisioned as a member of the SQL Serversysadmin role. Values set by this option can be overridden by specifying additional command line parameters.

When the operating system is not a domain controller, by default the Database Engine and Reporting Services will use the NTAUTHORITY\NETWORK SERVICE account, Integration Services will use the NTAUTHORITY\NETWORK SERVICE account, and the SQL Full text Filter Daemon Launcher will use the NTAUTHORITY\LOCAL SERVICE account.

See Also

Installing PowerPivot for SharePoint
Hardware and Software Requirements (PowerPivot for SharePoint
Feature Selection