Access Services Report in SharePoint Site shows error for data extension ‘ADS’

  • [アーティクル]

Symptoms

You browse to an Access Report on a  SharePoint 2010 or SharePoint 2013 site that is configured with the SQL Reporting Services SharePoint mode, and you see the following error message:

“An error has occurred during report processing. (rsProcessingAborted)  An attempt has been made to use a data extension ‘ADS’ that is either not registered for this report server or is not supported in this edition of Reporting Services.”

Applies to

  • SQL Server Reporting Services (SSRS) 2012 | 2014
  • SharePoint Server 2013 | 2010

Cause

Reporting Services is not correctly configured for the "ADS" data extension.  A SharePoint environment that includes Microsoft Access Services reports and Reporting Services in SharePoint mode requires the the Reporting Services data extension "ADS".

Resolution

NOTE:  The following steps assume you ave already installed and configured Reporting Services in SharePoint mode, including the Reporting Services add-in for SharePoint products. See the More information section for links to installation topics.

The Reporting Services service applications need to be configured to use the "ADS" data extension. 

1

Open the PowerShell ISE with administrative privileges on the SharePoint application server that is running Reporting Services in SharePoint mode.

2

Run the following command to load the SharePoint Snap-in

Add-PSSnapin Microsoft.SharePoint.PowerShell

3

Run the following commands to loop through all SSRS service applications, and add the ADS data extension

 

$apps = Get-SPRSServiceApplication
foreach ($app in $apps)
{
New-SPRSExtension -identity $app -ExtensionType “Data” -name "ADS" -TypeName "Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"
}

4

Run the following commands to loop through each SSRS service application and list the current data extensions. The output should include the "ADS" extension.

 

$apps = Get-SPRSServiceApplication
foreach ($app in $apps)
{
Write-host -ForegroundColor "yellow" Service App Name $app.Name
Get-SPRSExtension -identity $app -ExtensionType “Data” | select name,extensiontype | Format-Table -AutoSize
}

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

The Access Report will now correctly render in the SharePoint Site.

More information

If you run Access Services for SharePoint Server with an SSRS report server in SharePoint mode, the 'ADS' Reporting Services data extension is required and the report server needs to be configured to use the extension. The report is created in the Microsoft Access client and then published to a SharePoint Site using the Access Services.

For more information on using Access Services with Reporting Services, see the following:

For more information on installing reporting services, see

See Also