Export (0) Print
Expand All
6 out of 17 rated this helpful - Rate this topic

Use Access Services with SQL Reporting Services: Installing SQL Server 2008 R2 Reporting Services Add-In (SharePoint Server 2010)

SharePoint 2010
 

Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2014-04-04

A prerequisite for running Access Services for SharePoint Server 2010 is the installation of Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint Technologies 2010 (SSRS). The SSRS add-in is available as a free download via the Web and provides a set of features that enable you to run Access Services reports in SharePoint.

importantImportant
While the SSRS Add-in can be installed either before or after SharePoint Server is deployed, it is strongly recommended that it be installed prior to installing SharePoint Server to avoid time consuming manual configuration on a server by server basis.
  • If you install SSRS before SharePoint Server:A deployment of Reporting Services integrates with a deployment of SharePoint at the farm level. No additional configuration or replication out to servers in the farm will be necessary. If you use the SharePoint prerequisite tool during SharePoint installation, the SSRS add-in will be automatically installed during that process.

  • If you install SSRS after installing SharePoint Server:If you choose to install SSRS after deploying SharePoint Server, the installation process will involved many more steps, especially if you have multiple web front end servers. If you have multiple SharePoint Web applications in a farm configuration, you must install the Reporting Services Add-in on each computer that has a front-end Web.

Connected vs. Local Mode:

There are two modes in running Reporting Services with SharePoint Server. There is the standard default mode referred to as the “Connected mode” and requires SharePoint Server, the SSRS add-in and the SQL Server 2008 R2 Report Server. The new mode is “Local mode”. It is a light-weight setup for Reporting Services to integrate with SharePoint Server. It only requires SharePoint Server and the SSRS Add-in.

importantImportant
Local mode means there is no Reporting Services server. You must install the add-in but it is not an actual Reporting Services server. With Local mode, users can view reports but will not have access to server side features, e.g., setting up ‘subscriptions’.
  • If you have multiple Web front-ends in your SharePoint farm, it is recommended that you set up using Connected Mode. To set up connected mode, you will need SQL Server 2008 R2 Report Server and the Reporting Services Add-in.

  • If you are running a SharePoint farm with only one Web front-end, you can set up Local Mode. You need Reporting Services Add-in.

noteNote
Installing the Reporting Services Add-in is one of many steps that are necessary for integrating a report server with an instance of a SharePoint product or technology. The order of steps for configuring the servers is important. For best results, be sure that you do them in order.

Installing Reporting Services Add-in before SharePoint installation (Recommended)
  1. Download the SSRS Add-in from http://go.microsoft.com/fwlink/p/?LinkID=164654&clcid=0x409.

  2. Run rsSharePoint.msi on the farm server on which you intend to start SharePoint installation.

  3. Install SharePoint Server.

  4. Enable the Session State for the farm by opening the SharePoint Management Shell. Enter the command [Enable-SPSessionStateService -DatabaseName "foo"] — The DatabaseName value is the database that will be created on the computer that is running SQL Server. Perform an IIS reset.

Installing the Reporting Services Add-in after SharePoint installation
  1. Install the SSRS Add-in according to the steps at http://go.microsoft.com/fwlink/p/?LinkID=164654&clcid=0x409

  2. Activate the SSRS feature according to the steps at http://msdn.microsoft.com/en-us/library/bb677366(SQL.105).aspx

To install the Reporting Services Add-in for Connected Mode
  1. Install the SSRS Add-in either before or after SharePoint Server installation according to the session above.

  2. Configure Report Server Integration in SharePoint Central Administrationhttp://msdn.microsoft.com/en-us/library/bb326213(SQL.105).aspx

  3. Modify the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file on the Reporting Services server. Under the <Data> node, under the <Extension> node, add the ADS data extension. For example:

    <Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/> -->

  4. Open the rssrvpolicy.config file on your RS server.

    noteNote

    For SharePoint 2010, the file is located at: "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\WebServices\Reporting"
    For SharePoint 2013, the file is located at: "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\WebServices\Reporting"
  5. In the rssrvpolicy.config file under the <NamedPermissionSets> node, add the following XML code:

    <PermissionSet class="NamedPermissionSet" version="1" Name="ReportExpressionsDefaultPermissionSet">
    <IPermission class="SecurityPermission" version="1" Flags="Execution" />
    <IPermission class="Microsoft.Office.Access.Server.Security.AccessServicesPermission, Microsoft.Office.Access.Server.Security, 
         Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" version="1.0" Flags="CalculationCallback" />
    </PermissionSet>
    
    
  6. In the rssrvpolicy.config file under the <CodeGroup>node, find the following line and change PermissionSetName from “Execution” to “ReportExpressionsDefaultPermissionSet”.

    <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Report_Expressions_Default_Permissions"
     Description="This code group grants default permissions for code in report expressions and Code element. ">
    
  7. Enable Remote Errors for Reporting Services by following the instructions at http://go.microsoft.com/fwlink/p/?LinkId=183457&clcid=0x409.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.