Let me describe what problem I am having.

I have a shared datasource to a list, the list contains infopath documents, the documents are entered by our sales guys.Each document has individual permission in order to seperate our sales regions. (West cannot see East and vice versa)

the sql report retrieves the data by region for the managers. The managers Windows Credentials get passed from SSRS to SharePoint. This results in only retrieving the appropriate documents (No Filters are needed due to the permissions)

This worked in 3.1, after upgrading to 3.3 I get the following message

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

I found an intermediary solution by passing my own credentials and filtering on the manager in the report. I would like to go back to the original design.

any help would be appreciated.

Rolf

Hi Marien,

I forced an IISreset this morning, but it didn't  help.

we are running MOSS 2007 / sql server 2005 / Standalone SSRS on the same box.

I'll attach the Report Server log file from this morning, after I tested the report, with windows integrated security and with passing admin credentials.

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Eastern Standard Time</TimeZone>
  <Path>d:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServer__12_02_2009_08_29_43.log</Path>
  <SystemName>KIIN042</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
  <OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!9!12/2/2009-08:29:43:: i INFO: Reporting Web Server started
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!9!12/2/2009-08:29:43:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!resourceutilities!9!12/2/2009-08:29:43:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!9!12/2/2009-08:29:43:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!9!12/2/2009-08:29:43:: i INFO: Running on 2 physical processors, 8 logical processors
w3wp!runningjobs!9!12/2/2009-08:29:43:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
w3wp!runningjobs!9!12/2/2009-08:29:43:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!9!12/2/2009-08:29:43:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!9!12/2/2009-08:29:43:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!library!9!12/02/2009-08:29:44:: Call to GetPermissionsAction(/Sales/Region Weekly Report/Region Weekly Report).
w3wp!library!9!12/02/2009-08:29:44:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!9!12/02/2009-08:29:44:: Call to GetSystemPropertiesAction().
w3wp!library!9!12/02/2009-08:29:44:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Region Weekly Report, PathBased).
w3wp!library!e!12/02/2009-08:29:45:: Call to GetSystemPermissionsAction().
w3wp!library!e!12/02/2009-08:29:45:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Region Weekly Report, PathBased).
w3wp!library!d!12/02/2009-08:29:45:: Call to ListEventsAction().
w3wp!library!f!12/02/2009-08:29:46:: Call to GetSystemPropertiesAction().
w3wp!library!d!12/02/2009-08:29:48:: i INFO: Call to RenderFirst( '/Sales/Region Weekly Report/Region Weekly Report' )
w3wp!library!d!12/02/2009-08:29:52:: Using folder d:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\RSTempFiles for temporary files.
w3wp!webserver!d!12/02/2009-08:29:52:: i INFO: Processed report. Report='/Sales/Region Weekly Report/Region Weekly Report', Stream=''
w3wp!library!9!12/02/2009-08:31:01:: Call to GetPermissionsAction(/Sales/Region Weekly Report).
w3wp!library!9!12/02/2009-08:31:01:: Call to GetPropertiesAction(/Sales/Region Weekly Report, PathBased).
w3wp!library!9!12/02/2009-08:31:01:: Call to GetSystemPermissionsAction().
w3wp!library!9!12/02/2009-08:31:01:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!9!12/02/2009-08:31:01:: Call to GetSystemPropertiesAction().
w3wp!library!9!12/02/2009-08:31:01:: Call to GetSystemPropertiesAction().
w3wp!library!c!12/02/2009-08:31:19:: Call to GetPermissionsAction(/Sales/Region Weekly Report).
w3wp!library!c!12/02/2009-08:31:19:: Call to GetPropertiesAction(/Sales/Region Weekly Report, PathBased).
w3wp!library!c!12/02/2009-08:31:19:: Call to GetSystemPermissionsAction().
w3wp!library!f!12/02/2009-08:31:19:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!f!12/02/2009-08:31:19:: Call to GetSystemPropertiesAction().
w3wp!library!c!12/02/2009-08:31:22:: Call to GetPermissionsAction(/Sales/Region Weekly Report/SharePoint.Sales.WeeklySalesReport (Enesys)).
w3wp!library!c!12/02/2009-08:31:22:: Call to GetSystemPermissionsAction().
w3wp!library!e!12/02/2009-08:31:23:: Call to GetDataSourceContentsAction(/Sales/Region Weekly Report/SharePoint.Sales.WeeklySalesReport (Enesys)).
w3wp!library!e!12/02/2009-08:31:23:: Call to GetPropertiesAction(/Sales/Region Weekly Report/SharePoint.Sales.WeeklySalesReport (Enesys), PathBased).
w3wp!library!c!12/02/2009-08:31:23:: Call to ListChildrenAction(/, False).
w3wp!library!9!12/02/2009-08:31:23:: Call to ListChildrenAction(/Sales, False).
w3wp!library!c!12/02/2009-08:31:23:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!c!12/02/2009-08:31:23:: Call to ListChildrenAction(/, False).
w3wp!library!c!12/02/2009-08:31:23:: Call to ListChildrenAction(/Sales, False).
w3wp!library!e!12/02/2009-08:31:23:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!e!12/02/2009-08:31:23:: Call to GetSystemPropertiesAction().
w3wp!library!a!12/02/2009-08:31:27:: Call to GetPermissionsAction(/Sales/Region Weekly Report/SharePoint.Sales.WeeklySalesReport (Enesys)).
w3wp!library!c!12/02/2009-08:31:27:: Call to GetSystemPermissionsAction().
w3wp!library!d!12/02/2009-08:31:27:: Call to GetSystemPropertiesAction().
w3wp!library!1!12/02/2009-08:31:34:: Call to GetPermissionsAction(/Sales/Region Weekly Report/TEST).
w3wp!library!1!12/02/2009-08:31:34:: Call to GetSystemPropertiesAction().
w3wp!library!d!12/02/2009-08:31:34:: Call to GetPropertiesAction(/Sales/Region Weekly Report/TEST, PathBased).
w3wp!library!d!12/02/2009-08:31:34:: Call to GetSystemPermissionsAction().
w3wp!library!d!12/02/2009-08:31:34:: Call to GetPropertiesAction(/Sales/Region Weekly Report/TEST, PathBased).
w3wp!library!c!12/02/2009-08:31:34:: Call to GetSystemPropertiesAction().
w3wp!library!f!12/02/2009-08:31:35:: i INFO: Call to RenderFirst( '/Sales/Region Weekly Report/TEST' )
w3wp!processing!f!12/2/2009-08:31:40:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied 
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at System.Management.ManagementObjectSearcher.Initialize()
   at System.Management.ManagementObjectSearcher.Get()
   at #2o.#4o.#6s()
   at #2o.#3o.#jt()
   at #2o.#3o.#Uk()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.ValidateLicense()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.Open()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
   --- End of inner exception stack trace ---
w3wp!processing!f!12/2/2009-08:31:40:: e ERROR: Data source 'SharePoint.Sales.WeeklySalesReport (Enesys)': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied
w3wp!processing!f!12/2/2009-08:31:40:: e ERROR: An exception has occurred in data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied
w3wp!processing!f!12/2/2009-08:31:40:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!f!12/2/2009-08:31:40:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied 
   --- End of inner exception stack trace ---
w3wp!webserver!f!12/02/2009-08:31:40:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied
w3wp!library!f!12/02/2009-08:31:42:: Call to GetPermissionsAction(/Sales/Region Weekly Report).
w3wp!library!d!12/02/2009-08:31:42:: Call to GetPropertiesAction(/Sales/Region Weekly Report, PathBased).
w3wp!library!d!12/02/2009-08:31:42:: Call to GetSystemPermissionsAction().
w3wp!library!d!12/02/2009-08:31:42:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!d!12/02/2009-08:31:42:: Call to GetSystemPropertiesAction().
w3wp!library!f!12/02/2009-08:31:45:: Call to GetPermissionsAction(/Sales/Region Weekly Report/Call Report).
w3wp!library!f!12/02/2009-08:31:45:: Call to GetSystemPropertiesAction().
w3wp!library!f!12/02/2009-08:31:45:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!f!12/02/2009-08:31:45:: Call to GetSystemPermissionsAction().
w3wp!library!d!12/02/2009-08:31:45:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!b!12/02/2009-08:31:45:: Call to GetSystemPropertiesAction().
w3wp!processing!b!12/2/2009-08:31:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied 
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at System.Management.ManagementObjectSearcher.Initialize()
   at System.Management.ManagementObjectSearcher.Get()
   at #2o.#4o.#6s()
   at #2o.#3o.#jt()
   at #2o.#3o.#Uk()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.ValidateLicense()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.Open()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
   --- End of inner exception stack trace ---
w3wp!processing!b!12/2/2009-08:31:50:: e ERROR: Data source 'SharePoint.Sales.WeeklySalesReport (Enesys)': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied
w3wp!processing!b!12/2/2009-08:31:50:: e ERROR: An exception has occurred in data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied
w3wp!processing!b!12/2/2009-08:31:50:: i INFO: Merge abort handler called. Aborting data sources ...
w3wp!processing!b!12/2/2009-08:31:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SharePoint.Sales.WeeklySalesReport (Enesys)'. ---> System.Management.ManagementException: Access denied 
   --- End of inner exception stack trace ---
w3wp!library!b!12/02/2009-08:32:06:: Call to GetPermissionsAction(/Sales/Region Weekly Report/SharePoint.Sales.WeeklySalesReport (Enesys)).
w3wp!library!c!12/02/2009-08:32:06:: Call to GetSystemPermissionsAction().
w3wp!library!c!12/02/2009-08:32:06:: Call to GetSystemPropertiesAction().
w3wp!library!a!12/02/2009-08:32:09:: Call to GetPermissionsAction(/Sales/Region Weekly Report).
w3wp!library!c!12/02/2009-08:32:09:: Call to GetPropertiesAction(/Sales/Region Weekly Report, PathBased).
w3wp!library!c!12/02/2009-08:32:09:: Call to GetSystemPermissionsAction().
w3wp!library!c!12/02/2009-08:32:09:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!d!12/02/2009-08:32:09:: Call to GetSystemPropertiesAction().
w3wp!library!1!12/02/2009-08:32:10:: Call to GetPermissionsAction(/Sales/Region Weekly Report/Call Report).
w3wp!library!1!12/02/2009-08:32:10:: Call to GetSystemPropertiesAction().
w3wp!library!c!12/02/2009-08:32:10:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!c!12/02/2009-08:32:10:: Call to GetSystemPermissionsAction().
w3wp!library!d!12/02/2009-08:32:10:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!a!12/02/2009-08:32:10:: Call to GetSystemPropertiesAction().
w3wp!library!f!12/02/2009-08:32:18:: Call to GetPermissionsAction(/Sales/Region Weekly Report/Call Report).
w3wp!library!a!12/02/2009-08:32:18:: Call to GetSystemPropertiesAction().
w3wp!library!a!12/02/2009-08:32:18:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!a!12/02/2009-08:32:18:: Call to GetSystemPermissionsAction().
w3wp!library!a!12/02/2009-08:32:18:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Call Report, PathBased).
w3wp!library!a!12/02/2009-08:32:18:: Call to GetSystemPropertiesAction().
w3wp!library!a!12/02/2009-08:32:22:: i INFO: Call to RenderFirst( '/Sales/Region Weekly Report/Call Report' )
w3wp!webserver!a!12/02/2009-08:32:35:: i INFO: Processed report. Report='/Sales/Region Weekly Report/Call Report', Stream=''

 

Frederic, (sorry about the long post, you can remove it later, or move the pictures to your server)

I decided to start from scratch, new shared datasource,new report, new sharepoint list. The user has read rights to the list.

The report runs as admin, but not as the user, following are some pics related to the report + log

DataSource using windows credentials

Report Datasource

how the report supposed to look

screenshot of the user looking at the image library (Smith Mark

screenshot of the errormessage after running report.

 

sql server report log for the report

w3wp!library!e!12/03/2009-10:53:43:: Call to GetPermissionsAction(/Sales/Region Weekly Report).
w3wp!library!e!12/03/2009-10:53:43:: Call to GetPropertiesAction(/Sales/Region Weekly Report, PathBased).
w3wp!library!e!12/03/2009-10:53:43:: Call to GetSystemPermissionsAction().
w3wp!library!b!12/03/2009-10:53:43:: Call to ListChildrenAction(/Sales/Region Weekly Report, False).
w3wp!library!d!12/03/2009-10:53:43:: Call to GetSystemPropertiesAction().
w3wp!library!e!12/03/2009-10:53:45:: Call to GetPermissionsAction(/Sales/Region Weekly Report/Images).
w3wp!library!e!12/03/2009-10:53:45:: Call to GetSystemPropertiesAction().
w3wp!library!b!12/03/2009-10:53:45:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Images, PathBased).
w3wp!library!b!12/03/2009-10:53:45:: Call to GetSystemPermissionsAction().
w3wp!library!b!12/03/2009-10:53:45:: Call to GetPropertiesAction(/Sales/Region Weekly Report/Images, PathBased).
w3wp!library!b!12/03/2009-10:53:45:: Call to GetSystemPropertiesAction().
w3wp!library!b!12/03/2009-10:53:45:: i INFO: Call to RenderFirst( '/Sales/Region Weekly Report/Images' )
w3wp!processing!b!12/3/2009-10:53:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'. ---> System.Management.ManagementException: Access denied
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at System.Management.ManagementObjectSearcher.Initialize()
   at System.Management.ManagementObjectSearcher.Get()
   at #2o.#4o.#6s()
   at #2o.#3o.#jt()
   at #2o.#3o.#Uk()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.ValidateLicense()
   at Enesys.ReportingServices.Ersde.ErsdeConnection.Open()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
   --- End of inner exception stack trace ---
w3wp!processing!b!12/3/2009-10:53:50:: e ERROR: Data source 'ImageDataSource': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'. ---> System.Management.ManagementException: Access denied
w3wp!processing!b!12/3/2009-10:53:50:: e ERROR: An exception has occurred in data source 'ImageDataSource'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'. ---> System.Management.ManagementException: Access denied
w3wp!processing!b!12/3/2009-10:53:50:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!b!12/3/2009-10:53:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'. ---> System.Management.ManagementException: Access denied
   --- End of inner exception stack trace ---
w3wp!webserver!b!12/03/2009-10:53:50:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ImageDataSource'. ---> System.Management.ManagementException: Access denied

Here is a side note: not related to this post.

I was playing with the query designer, and happened to name my list the same as my query. give it a try.

When the list is defined as a sharepoint list you can use the query see pic below

Then if you rename the list the query will not work anymore, I don't know if this is how it supposed to work or not.

 

 

 

Hi Rolf,

Version 3.3.18 that is now available for download should fix the authentication problem when using "WIS".

Regards,

---

Frederic LATOUR
ENESYS