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:
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