Setup Role

SQL Server 2008 R2

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.

Options

SQL Server Feature Installation

Choose this option to select individual features and shared components. Features include Database Engine Services, Analysis Services (native mode), Reporting Services, and Service Broker.

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 service in a farm, enabling query and data processing for published Excel workbooks that contain embedded PowerPivot data.

There are two configuration options for PowerPivot for SharePoint:

  • Existing Farm adds PowerPivot for SharePoint to a farm or standalone server that is already configured.
  • New Server is used to deploy PowerPivot for SharePoint in the fewest steps possible. This role requires that you have SharePoint server installed but not configured. SQL Server Setup will configure SharePoint for you and create a Web application, site collection, and a server configuration that is optimized for PowerPivot features.

For this role, Setup does the following:

  • Provisions the Analysis Services service instance.
  • Installs program files on a SharePoint application server.
  • Deploys two PowerPivot solution packages that add application files to Web front end servers.
  • (New Server only) Adds Database Engine Services to the installation and uses it as the database server for the farm.
  • (New Server only) Adds SQL Server Management Studio, configuration tools, and performance tools.
  • (New Server only) Creates a PowerPivot service application and application database.

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 Server sysadmin role. Values set by this option can be overridden by specifying additional command line parameters.

On Windows Vista or Windows Server 2008 or higher and 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