Microsoft® SQL Server® 2016 Reporting Services Add-in for Microsoft SharePoint®

The SQL Server 2016 Reporting Services Add-in for Microsoft SharePoint technologies deploys the Reporting Services user interface pages and features on a SharePoint web front-end server.

• The SQL Server 2016 version of the Reporting Services add-in supports SharePoint 2010 and SharePoint 2013.
• To use connected mode features of Reporting Services with the 2016 add-in, the report server version must also be 2016 version.
• For more information on supported versions, see “Supported Combinations of SharePoint and Reporting Services Components”.
• For more information on Local mode and connected mode, see “Use Access Services with SQL Reporting Services”.

After you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. The Reporting Services Add-in provides the following functionality:

• Power View, a feature of Microsoft SQL Server 2016 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View reports are in a new file format, RDLX.
• Open reports in Report Builder from a SharePoint library, and save reports to SharePoint libraries.
• A Report Viewer Web Part, which provides report-viewing capability, export to multiple rendering formats, page navigation, search, print, and zoom.
• SharePoint web pages so that you can create subscriptions and schedules, and manage reports and data sources.
• Support for standard SharePoint Foundation 2010 and SharePoint Server 2010 features including document management, collaboration, security, and deployment with report server content types.
• The ability to add the Reporting Services Report Viewer Web Part to any page or dashboard on a SharePoint site and customize its appearance.
• The ability to use SharePoint permission levels and roles to control access to report server content. You can also use SharePoint forms authentication to support access over Internet connections.
• Reporting Services data alerts, a data-driven alerting solution for SharePoint Server 2010 Enterprise Edition that informs you about changes in report data that are of interest to you, and at a relevant time.

For a detailed list of what’s new in Reporting Services, see What's New (Reporting Services) for more information.

Supported Operating Systems

Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

• 37 MB of available hard disk space is needed for the Add-in.
• Review the Windows SharePoint Foundation or SharePoint Services documentation for relevant system requirements.

The computer must meet the following software requirements:

• One of the following:
• Microsoft SharePoint 2010.
• Microsoft SharePoint Foundation 2010 with .NET Programmability Support.
• Microsoft SharePoint Server 2013.
• To use connected mode Reporting Services features, Microsoft SQL Server 2016 Reporting Services in SharePoint mode is required.
• The Web sites cannot be enabled for Anonymous access.
• Microsoft Internet Explorer 7.0 with the latest service packs.

You can install and configure the servers in any order, but integrated operations will not be available until the configuration steps are complete for both servers. For detailed information on the installation steps, see the Readme for the existing Reporting Services Add-in.

Step 1: Install an instance of a SharePoint product.

Step 2: Download the Reporting Services Add-in (RsSharePoint.msi) by clicking the Download button on this page. To start the installation immediately, click Run. To install later, click Save.

Step 3:To allow local mode Reporting Services functionality, Install the Reporting Services Add-in on web front-end servers. For connected mode Reporting Services functionality, complete the remaining steps.

Step 4: Install SQL Server 2016 Reporting Services on a SharePoint application server. In the SQL Server 2016 installation wizard, choose ‘Reporting Services – SharePoint’ on the feature selection page. You can also install the Reporting Services add-in from the SQL Server 2016 installation wizard instead of downloading from this page.

Step 5:Configure the Reporting Services SharePoint service and create at least one Reporting Services service application.

Step 6: Set permissions and add Reporting Services content types.

Step 7: Verify the installation.

The Reporting Services add-in should be installed on each SharePoint web server that you want to use for accessing the Reporting Services Local mode features or the connected SharePoint mode features such as Power View and data alerts.

For detailed information on installing the add-in, see "Install or Uninstall the Reporting Services Add-in for SharePoint”.

• If you have questions about the Reporting Services Add-in, visit the SQL Server Reporting Services Forum on MSDN.



• Help improve the Reporting Services Add-in by submitting bugs to the Connect Feedback Center.