Install SQL Server 2014 BI Features
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 PowerPivot for SharePoint and Power View, the Reporting Services ad hoc interactive report designer that runs on PowerPivot or Analysis Services tabular model databases.
If you are already familiar with the installation steps for Reporting Services, Analysis Services, or PowerPivot for SharePoint, you can skip ahead to the checklists for guidance on how to enable specific scenarios. For more information, see Checklists for Installing BI Features with SharePoint.
Contents
In this section:
| Link | Task |
|---|---|
| Checklists for Installing BI Features with SharePoint | If you already know what you want to install and are familiar with the installation steps for Reporting Services, Analysis Services, or PowerPivot for SharePoint, you can use the checklists in this section for guidance on installation order, account and permission requirements, and steps deploying advanced topologies, including multi-server and multi-feature deployments. |
| Install SQL Server BI Features with SharePoint (PowerPivot and Reporting Services) | This section explains how to install SQL Server features in a SharePoint environment. It identifies which SQL Server features are available given a specific version and edition of SharePoint. It also includes installation procedures for PowerPivot for SharePoint and Reporting Services in SharePoint mode. |
| Install Analysis Services in Multidimensional and Data Mining Mode Install Analysis Services in Tabular Mode Install Data Quality Services Install Integration Services Install Master Data Services Install Reporting Services Native Mode Report Server |
This section provides instructions for installing Analysis Services, Integration Services, Master Data Services, and Reporting Services, where Analysis Services and Reporting Services are installed without SharePoint. This is sometimes referred to as native mode, and it is the most common installation scenario for both Reporting Services and Analysis Services. In this section, you will learn about installation options that directly determine the operational context of your server. For Reporting Services, this might be a server that is pre-configured or one that requires multiple configuration steps before you can use it. For Analysis Services, the installation options you select will determine the type of project you can deploy to the server. |
| 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. |
Related content
| Link | Task |
|---|---|
| Upgrade to SQL Server 2014 Upgrade Analysis Services Upgrade PowerPivot 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 2014. |
| Uninstall SQL Server 2014 Uninstall PowerPivot for SharePoint Uninstall Reporting Services |
Use the instructions in this section to uninstall BI features. |