01/19/2012 01:44:07

The most up-to-date version of this file is available online at the Microsoft Download Center on the SQL Server 2012 Reporting Services Add-in Readme for SharePoint 2010 page.

Contents

Copyright Notice

The information provided in this document is provided “as-is”. Information and views expressed in this document, including URL and other Internet Web site 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. ©2012 Microsoft.  All rights reserved.Access, Microsoft SharePoint are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.

Background

The Microsoft SQL Server 2012  Reporting Services, add-in for SharePoint Products is a Web download that integrates Reporting Services report server with a deployment of Microsoft  SharePoint 2010 products ®. The Reporting Services Add-in provides the following functionality:

  • Interactive data exploration and visualization with Microsoft Microsoft SQL Server 2012.

  • 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.

  • 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.

  • A delivery extension that you can use in subscriptions to deliver reports to SharePoint libraries.

  • Publish reports and models from Report Designer and Model Designer to a SharePoint library.

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

[Top]

What’s New in This Release

SharePoint integration has been re-architected to greatly improve the SharePoint IT administrator experience, the end user experience, and supportability. The new architecture is implemented as a SharePoint 2010 shared service. The Shared service architecture allows Reporting Services to leverage many of the IT features of SharePoint products. The following is a list of some of the benefits from this release:

  • Configuration of Reporting Services with SharePoint is now completely through SharePoint Central Administration using management pages for Reporting Services service applications or using Reporting Services SharePoint mode PowerShell cmdlets.

  • Leverage SharePoint scale-out functionality for Reporting Services Service Applications.

  • The new Reporting Services shared service is hosted in SharePoint Shared Service Application pool.

  • The new Reporting Services service applications support Claims based authentication.

  • SharePoint cross-farm support for viewing reports.

  • Support for SharePoint backup and recovery and end-to-end SharePoint ULS logging.

  • Power View, a feature of Microsoft SQL Server 2012 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.

  • Reporting Services data alerting is a data-driven alerting solution that informs you about changes in report data that are of interest to you at a relevant time. The following summarizes the key areas of data alerting:

    • Define and save alert definitions—User views a report, creates rules that identify interesting data values, defines recurrence patterns for sending the alert, and specifies the recipients of the alert message.

    • Run alert definitions—Alerting service runs alert definitions at a scheduled time, retrieves report data, and triggers alerts based on rules in alert definition.

    • Deliver alerts to recipients—Alerting service creates an alert instance and sends email messages to recipients.

[Top]

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 2010 product you integrate with:

  • Microsoft Windows Installer 3.0 or newer.

  • SharePoint Foundation 2010 or SharePoint Server 2010. The Microsoft SQL Server 2012 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 2010 products and technologies.

  • Note

    Not all Reporting Services features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. The recommended and most complete combination is to use Microsoft SharePoint Server 2010 Enterprise Edition, the Microsoft SQL Server 2012 Reporting Services add-in for SharePoint 2010 Products, and Microsoft SQL Server 2012 report server in SharePoint mode. For more information, see Features Supported by the Editions of SQL Server (http://technet.microsoft.com/library/cc645993(SQL.110).aspx) and Supported Combinations of SharePoint and Reporting Services Components.

[Top]

Domain user account requirements for SharePoint administration and services

A deployment of a SharePoint server uses a variety of accounts to run services and access front-end and back-end servers. If you specify domain accounts for your deployment, you should follow best practice recommendations and specify accounts that are used exclusively by the SharePoint Web application. Do not configure a service account to run under the domain user account of an actual person who will access the SharePoint site.

A domain account is required if:

  • The SharePoint site and the report server are on different computers.

  • The SharePoint site is hosted in an application pool that runs as a built-in account, such as NetworkService.

SharePoint 2010 products and technologies require domain accounts for service configuration like reporting services SharePoint integration. For more information about service account requirements and recommendations, see Initial deployment administrative and service accounts (SharePoint Server 2010) in the SharePoint product and technology documentation.

[Top]

Installing the add-in

To install the Reporting Services Add-in, 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 follows SharePoint pre-deployment standards and installs files in locations used by the SharePoint installation. Setup creates SharePoint 2010 folders under the following path and copies files to the folders:

%program files%\common files\Microsoft Shared\Web Server Extensions\14\

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

  • The installation wizard: New with Microsoft SQL Server 2012, the add-in can be installed by the SQL Server installation wizard. Choose Reporting Services Add-in for SharePoint Products on the Feature Selection page of the wizard.

  • Command line: The add-in file, rsSharepoint.msi can also be installed directly from the installation media or downloaded. The rsSharepoint.msi supports both a graphical user interface and a command line installation. You must run the .msi with administrator privileges by first opening a command prompt with elevated permissions, and then running the rsSharepoint.msi from the command line. For more information on downloading the add-in, see Where to find the Reporting Services add-in for SharePoint Products (http://technet.microsoft.com/library/gg426282(SQL.110).aspx).

     

    Note

    If you use the /q switch for a silent command line installation, the end-user license agreement will not be 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.

    To install the files but skip the custom action steps, run the .msi from the command line with the SKIPCA option:

    1. Open a command prompt with administrator permissions.

    2. Run msiexec -i rsSharePoint.msi SKIPCA=1.

For more information, see Install or Uninstall the Reporting Services Add-in for SharePoint (http://technet.microsoft.com/library/aa905871(SQL.110).aspx).

[Top]

Upgrade

If you have an existing installation of the Reporting Services Add-in, you can upgrade to the current version. Setup will remove the older version of the add-in and then the new version will be installed.

Note that the Reporting Services Add-in is not instance-aware. You can only have one instance of the add-in on a computer. You cannot different versions side-by-side.

[Top]

Installation Order

The exact steps that you take to install and configure the Reporting Services Add-in as part of a SharePoint server deployment may 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 prior to the SharePoint product or technology is that as new servers are added to the farm, the Reporting Services Add-in will be configured and activated by the SharePoint farm.

For more information, see the following:

[Top]

Existing SharePoint farm

To install and configure Reporting Services on an existing SharePoint farm, do the following step-by-step procedures in this order:

  1. Install the SharePoint add-in on all Web front-end (WFE) computers.

  2. Install Microsoft SQL Server 2012 Reporting Services and the Database engine.

  3. Create at least one Reporting Services service application and configure service application association.

  4. Add Reporting Services content types to your document library

  5. Verify SQL Server Agent is running and provisioned. For more information, see Provision Subscriptions and Alerts for SSRS Service Applications (http://technet.microsoft.com/library/hh231725(SQL.110).aspx).

  6. Configure e-mail settings for your service application.

  7. 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/?LinkId=231169).

Single Server Installation

To install and configure Reporting Services with SharePoint on a single computer, do the following step-by-step procedures in this order:

  1. Install Database Engine, Reporting Services, and the Reporting Services add-in for SharePoint. Verify that you have a valid installation before you install the SharePoint Product.

  2. Run the SharePoint 2010 Products Preparation tool.

  3. Install SharePoint Server 2010 or SharePoint foundation 2010.

  4. Run the SharePoint Products Configuration Wizard. Then open the SharePoint site to verify you have a valid installation.

  5. Run the SharePoint Farm Configuration wizard.

  6. Install and Start the Reporting Services Shared Service.

  7. Create at least one Reporting Services service application and configure service application association.

  8. Add Reporting Services content types to your document library.

  9. Verify SQL Server Agent is running and provisioned. For more information, see Provision Subscriptions and Alerts for SSRS Service Applications

  10. Configure e-mail for your service application.

  11. 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/?LinkId=231169).

Getting Help

For help with SQL Server technical issues not related to documentation, see Getting Assistance with SQL Server.

For the most recent release notes, see SQL Server 2012 Release Notes.

For the most recent troubleshooting information, see the following TechNet wiki article Troubleshooting (SSRS in SharePoint Integrated Mode.