Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Install SQL Server 2016 Business Intelligence Features


Updated: October 26, 2015

Applies To: SQL Server 2016 Preview

SQL Server features that are part of the Microsoft Business Intelligence platform include Analysis Services, Integration Services, Master Data Services, Reporting Services, and several client applications used for creating or working with analytical data. This section of the SQL Server Setup documentation explains how to install these features.

Analysis Services and Reporting Services can be installed as standalone servers, in scale-out configurations, or as shared service applications in a SharePoint farm. Installing the services in a farm enables BI features that are only available in SharePoint, including Power Pivot for SharePoint and Power View, the Reporting Services ad hoc interactive report designer that runs on Power Pivot or Analysis Services tabular model databases.

In this section:



Install Analysis Services

This section provides installation instructions for all modes of an Analysis Services server.

Install Data Quality Services

Install Integration Services

Install Master Data Services

Install Reporting Services Native Mode Report Server

This section provides installation instructions for Reporting Services native mode or SharePoint mode.

Verify or Troubleshoot SQL Server BI Feature Installation Problems

This section includes steps for verifying an installation. It also provides links to problem resolution information on the web.



Upgrade to SQL Server 2016

Upgrade Analysis Services

Upgrade Power Pivot for SharePoint

Upgrade and Migrate Reporting Services

Use the instructions in this section to upgrade servers and content from a previous release to SQL Server 2016.

Uninstall SQL Server 2016

Uninstall Power Pivot for SharePoint

Uninstall Reporting Services

Use the instructions in this section to uninstall BI features.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft