This Readme document contains information about how to install Microsoft^® SQL Server 2014 Reporting Services Add-in for SharePoint products. The most up-to-date version of this file is available online at the Microsoft Download Center: SQL Server 2014 Reporting Services Add-in Readme for SharePoint (http://go.microsoft.com/fwlink/p/?LinkId=524504).

The information in this document is provided “as-is”. Information and views expressed in this document, including URL and other internet website references, may change without notice. This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes.

© 2014 Microsoft. All rights reserved.

Microsoft Access and Microsoft SharePoint are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.

The SQL Server 2014  Reporting Services add-in for SharePoint Products integrates a Reporting Services report server with a deployment of Microsoft  SharePoint products ®. The Reporting Services Add-in provides the following functionality:

·         Ad-hoc data exploration and visualization with Power View, a feature of SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint Server Enterprise Edition.

·         Open reports in Report Builder from a SharePoint library, and save reports to SharePoint libraries.

·         A Report Viewer Web Part, which provides report-viewing, exports to multiple rendering formats, page navigation, search report content, print, and zoom.

·         Web pages so that in SharePoint you can: create Reporting Services subscriptions and schedules, and manage reports and data sources.

·         Use of report server content types with standard SharePoint features that include: document management, collaboration, security, and deployment.

·         A Reporting Services Report Viewer Web Part you can add to any page or dashboard on a SharePoint site and customize its appearance.

·         Control access to report server content through SharePoint permission levels and roles. You can also use SharePoint forms authentication to support access over internet connections.

·         A delivery extension that you can use with Reporting Services subscriptions to deliver reports to SharePoint libraries.

·         Publish reports from Report Designer to a SharePoint library.

·         A Simple Object Access Protocol (SOAP) endpoint to manage report server content in SharePoint integrated mode.

To install the Reporting Services Add-in, the computer must meet the following software requirements in addition to the software and hardware requirements of the SharePoint product you integrate with:

·         One of the following SharePoint products:

1.  SharePoint Server 2013

2.  SharePoint Foundation 2010

3.  SharePoint Server 2010

4.  The SQL Server 2014 Add-in is not supported on earlier versions of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server2007.

·         The add-in is 64-bit only, which is a requirement of SharePoint products and technologies.

·         Microsoft Windows Installer 3.0 or newer.

·         Note: Not all Reporting Services features are supported in all combinations of:

·         The version of the Reporting Services report server.

·         The version of the Reporting Services add-in for SharePoint products.

·         The version of SharePoint.

For more information, see the following:

·         Supported Combinations of SharePoint and Reporting Services Components (http://go.microsoft.com/fwlink/p/?LinkId=301850).

·         Features Supported by the Editions of SQL Server (http://go.microsoft.com/fwlink/p/?LinkId=301851).

To install the Reporting Services Add-in for SharePoint products, you must be an administrator on the computer and a member of the SharePoint Farm Administrators group. In a SharePoint farm deployment, the add-in must be installed on each web front-end server (WFE).

The add-in can be installed using one of the following methods.

·         The installation wizard: To install the add-in from the SQL Server installation wizard, choose Reporting Services Add-in for SharePoint Products on the wizard Feature Selection page.

·         Web download: Download the add-in file, RsSharepoint.msi. The add-in supports both a graphical user interface and command-line installation. For more information on downloading the add-in, see the following:

·         The Microsoft Download Center: Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint (http://go.microsoft.com/fwlink/p/?LinkId=524504).

·         Where to find the Reporting Services add-in for SharePoint Products (http://go.microsoft.com/fwlink/p/?LinkId=301852).

For more information, see Install or Uninstall the Reporting Services add-in for SharePoint Products (http://go.microsoft.com/fwlink/p/?LinkId=301853).

Upgrade

The exact steps that you take to install and configure the Reporting Services Add-in vary depending on your requirements and the order that you install the different technologies.

Note: The add-in can be installed before installing a SharePoint product or after SharePoint installation. The advantage of installing the add-in before the SharePoint product is that as new servers are added to the farm, the Reporting Services Add-in is configured and activated by the SharePoint farm.

Existing SharePoint farm

Read the Release Notes for the Latest Product Information