Skip to content

supported-combinations-of-sharepoint-and-reporting-services-server.md

Latest commit

 

History

History
80 lines (58 loc) · 5.7 KB

supported-combinations-of-sharepoint-and-reporting-services-server.md

File metadata and controls

80 lines (58 loc) · 5.7 KB
title Supported combinations of SharePoint & Reporting Services server | Microsoft Docs
description A SQL Server Reporting Services report server installed in SharePoint mode requires a version of SharePoint and the SQL Server Reporting Services add-in (rsSharePoint.msi) for SharePoint products, which you install on the SharePoint servers.
ms.date 12/04/2019
ms.prod reporting-services
ms.prod_service reporting-services-sharepoint
ms.custom seo-lt-2019​, seo-mmd-2019
ms.topic conceptual
helpviewer_keywords
SharePoint mode
add-in for sharepoint
rsSharePoint
ms.assetid dc6a3372-db26-43f0-b7aa-f725acc635c2
author maggiesMSFT
ms.author maggies
monikerRange >=sql-server-2016 <=sql-server-2016||=sqlallproducts-allversions

Supported combinations of SharePoint and Reporting Services server

[!INCLUDE ssrs-appliesto] [!INCLUDE ssrs-appliesto-2016] [!INCLUDE ssrs-appliesto-not-2017] [!INCLUDEssrs-appliesto-sharepoint-2013-2016i] [!INCLUDE ssrs-appliesto-not-pbirs]

[!INCLUDE ssrs-previous-versions]

A SQL Server Reporting Services report server installed in SharePoint mode requires a version of SharePoint and the SQL Server Reporting Services add-in (rsSharePoint.msi) for SharePoint products, which you install on the SharePoint servers. This topic summarizes the supported combinations.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

Supported combinations of SharePoint and Reporting Services components

The following table summarizes the supported combinations of report server, the Reporting Services add-in for SharePoint products, and SharePoint products. Combinations that are not list in the following table are not supported

Supported combinations

Report server Add-in SharePoint version
1 SQL Server 2016 SQL Server 2016 SharePoint 2016
2 SQL Server 2016 SQL Server 2016 SharePoint 2013
3 SQL Server 2014 SQL Server 2014 SharePoint 2013
4 SQL Server 2014 SQL Server 2014 SharePoint 2010
5 SQL Server 2012 SP4 SQL Server 2014 and SQL Server 2012 SP4 SharePoint 2013
6 SQL Server 2012 SP3 SQL Server 2014 and SQL Server 2012 SP3 SharePoint 2013
7 SQL Server 2012 SP2 SQL Server 2014 and SQL Server 2012 SP2 SharePoint 2013
8 SQL Server 2012 SP1 SQL Server 2014 and SQL Server 2012 SP1 SharePoint 2013
9 SQL Server 2012 and SQL Server 2012 SP1* SQL Server 2014 SharePoint 2010
10 SQL Server 2012 SQL Server 2012 SharePoint 2010
11 SQL Server 2008 R2 SQL Server 2014 SharePoint 2010
12 SQL Server 2008 R2 SQL Server 2012 and SQL Server 2012 SP1 or later SharePoint 2010
13 SQL Server 2008 R2 SQL Server 2008 R2 SharePoint 2010
14 SQL Server 2008 R2 SQL Server 2008 SP2 SharePoint 2007
15 SQL Server 2008 SP2 SQL Server 2008 R2 SharePoint 2010
16 SQL Server 2008 SP2 SQL Server 2008 and SQL Server 2008 SP2 SharePoint 2007

*Exception: Power view integration is not supported.

For links to the add-in download pages, see Where to find the Reporting Services add-in for SharePoint Products.

Additional considerations:

  • Be sure to upgrade to upgrade all of the SharePoint servers within the farm. This includes the App and Web Front End servers.

  • SharePoint 2016 support, including Power view integration, requires the [!INCLUDEssRSnoversion] report server and the [!INCLUDEssRSnoversion] add-in version of SQL Server 2016 or later.

  • SharePoint 2013 support, including Power view integration, requires the [!INCLUDEssRSnoversion] report server and the [!INCLUDEssRSnoversion] add-in version of SQL Server 2012 SP1 or later.

  • Power View was introduced in SQL Server 2012. Therefore, Power View integration with SharePoint 2010 requires the SQL Server 2012 or later of the add-in.

  • The SQL Server 2008 R2 Add-In is not supported by SQL Server 2012 (or later) report servers. The SharePoint 2010 prerequisite installer automatically installs the SQL Server 2008 R2 Add-In. It must be uninstalled before installing newer versions of the add-in. In place upgrade of the add-in is not supported.

  • Upgrade: SharePoint 2010 with the [!INCLUDEssRSnoversion] Add-In installed, cannot be upgraded in-place to SharePoint 2013. SharePoint 2013 requires SQL Server 2012 SP1 or later of the [!INCLUDEssRSnoversion] add-in and report server. For more information on upgrade, see Upgrade and Migrate Reporting Services.

Next steps

Where to find the Reporting Services add-in for SharePoint Products
Features Supported by the Editions of SQL Server 2016
Hardware and Software Requirements for Installing SQL Server 2016

More questions? Try asking the Reporting Services forum