11/22/2013 16:18:41
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=301736).
Copyright Notice
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.
Background
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.
Requirements and Supported Combinations
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:
SharePoint Server 2013
SharePoint Foundation 2010
SharePoint Server 2010
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
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=301736).
Where to find the Reporting Services add-in for SharePoint Products (http://go.microsoft.com/fwlink/p/?LinkId=301852).
Note If you use the /q switch for a silent command-line installation, the end-user license agreement is not displayed. Regardless of the installation method, the use of this software is governed by a license agreement and you are responsible for complying with the license agreement.
For more information, see Install or Uninstall the Reporting Services add-in for SharePoint Products (http://go.microsoft.com/fwlink/p/?LinkId=301853).
Upgrade
If you have an existing installation of the Reporting Services Add-in, you can upgrade to the current version. Setup removes the older version of the add-in and then the new version is installed.
The Reporting Services Add-in is not instance-aware. You can only have one instance of the add-in on a computer.
Installation Order
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
To install and configure Reporting Services on an existing SharePoint farm, do the following step-by-step procedures in this order:
Install the SharePoint add-in on all web front-end (WFE) computers.
Install SQL Server 2014 Reporting Services.
Create at least one Reporting Services service application and configure service application association.
Add Reporting Services content types to your document library.
Verify SQL Server Agent is running and provisioned. For more information, see Provision Subscriptions and Alerts for SSRS Service Applications (http://go.microsoft.com/fwlink/p/?LinkId=302099).
Configure e-mail settings for your service application.
For reports with data external to the SharePoint farm and requiring Windows Integrated credentials, ensure the SharePoint Claims to Windows Token shared service (C2WTS) is configured to allow access to the external data sources. For more information on C2WTS, see Claims to Windows Token Service (C2WTS) (http://go.microsoft.com/fwlink/p/?LinkId=302100).
Installation and Configuration Assistance
Type | Link |
|---|---|
Reporting Services SharePoint Mode | Installing Reporting Services SharePoint Mode Report Server for Power View and Data Alerting(http://go.microsoft.com/fwlink/p/?LinkId=301855). |
SharePoint 2013 | Install Reporting Services SharePoint Mode for SharePoint 2013 (http://go.microsoft.com/fwlink/p/?LinkId=302101). |
SharePoint 2013 | Install Reporting Services SharePoint Mode as a Single Server Farm (http://go.microsoft.com/fwlink/p/?LinkId=302102). |
SharePoint 2010 | Install Reporting Services SharePoint Mode for SharePoint 2010 (http://go.microsoft.com/fwlink/p/?LinkId=302137). |
Community | For community support, go to the forum at, SQL Server Reporting Services, Power View (http://go.microsoft.com/fwlink/p/?LinkId=301854). |
Troubleshooting | For the most recent troubleshooting information, see the following TechNet wiki article Troubleshoot SQL Server Reporting Services (SSRS) in SharePoint Integrated Mode (http://go.microsoft.com/fwlink/p/?LinkId=207239). |
Read the Release Notes for the Latest Product Information
The Release Notes provide supplemental information about product behaviors that apply to this release or that are not documented in this release of SQL Server Books Online. You can find Release Notes on the Release Notes Page (http://go.microsoft.com/fwlink/p/?LinkId=296445).