Data Cogs Information Technology
posts - 137, comments - 144, trackbacks - 42

Sunday, March 13, 2011

Sharepoint Access Services Reports Fail With Error

I was playing around with Access Services today.  This allows you to “upsize” an Access Web Database to Sharepoint.  The tables become Sharepoint Lists and the reports become Reporting Services reports.  Sounds like it has potential, eh?  Anyway I found the steps required to set this all up quite painful!  Eventually I got through in through.

 

The last hurdle was getting Reporting Services to display the report.  I got this error when I tried to open the report in SharePoint:

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

 I think I installed Report Services before Sharepoint, but according to this article it is easier if you do things the other way around:

http://technet.microsoft.com/en-us/library/ee662542.aspx

Here is the text from the article on what I had to do:

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.

 

posted @ 12:51 PM | Feedback (0)