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

Installing Reporting Services Add-in before SharePoint installation (Recommended)

1. Download the SSRS Add-in from http://go.microsoft.com/fwlink/?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/?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. Modify the rssrvpolicy file on RS server.
   1. Add the following XML code in the file under the <NamedPermissionSets> node.
      
      
      <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>
      

   2. In 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. ">

5. Enable Remote Errors for Reporting Services by following the instructions at http://go.microsoft.com/fwlink/?LinkId=183457&clcid=0x409.
   
   
   This Article from Technet http://technet.microsoft.com/en-us/library/ee662542.aspx