Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Services and Access Services Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 7:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 14, 2014 11:10 AM
Points: 1, Visits: 29
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
Post #1477047
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse