Reporting Services and Access Services

  • Hi, our environment is SharePoint 2010, with SQL Reporting Services in integrated mode. We have been using this environment for over a year and now are incorporating Access Services. I have the services setup and running, am able to retrieve query information. I am trying to setup the SQL Reporting but receive an error. I have added the ADS config changes to both the rsreportserver.config and the rssrvpolicy.config per the Technet site of:

    http://technet.microsoft.com/library/ee662542.aspx

    I still am receiving an error when I try to run a report from my Access Web site indicating: ERROR: An exception has occurred in data source 'ADS'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.DataExtensionNotFoundException

    : 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 don't know what I could be missing as all other SSRS reports in our enviornment work. But once I insert the statements into the rsreportserver.config and the rssrvpolicy.config regarding the ADS they stop working and I have to backout my changes.

    Any suggestions would be welcome. Thank you, Julie

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply