Hi
Getting the error when user trying to connect
The permission granted to user '' are insufficiant for performing this operation (rsAccessDenied) when adding new users trying to connect to the reports. Other accounts with same access still working ok.
Have checked
Site Settings as System User
Folder Settings as Browse
Report Security as Browse
Dataset Security as Browse
Datasource Security as Browse
Stack trace is
library!ReportServer_0-1!1f0c!10/31/2013-14:51:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'SWUK\33693WR'
are insufficient for performing this operation.;
processing!ReportServer_0-1!1f0c!10/31/2013-14:51:25:: e ERROR: An exception has occurred in data set 'ParameterData_UseLeadMOU'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'SWUK\33693WR'
are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSServiceDataProvider.CheckAccess(Byte[] securityDescriptor, ItemType itemType, ReportOperation operation, String catalogPath)
at Microsoft.ReportingServices.Library.SharedDataExecutionInstance.Execute(DataSetInfo dataSet, String targetChunkNameInReportSnapshot, ParameterInfoCollection dataSetParameterValues, ReportProcessingContext originalProcessingContext, Boolean originalRequestNeedsDataChunk,
IRowConsumer originalRequest)
at Microsoft.ReportingServices.Library.SharedDataSetExecution.Process(DataSetInfo sharedDataSet, String targetChunkNameInReportSnapshot, Boolean originalRequestNeedsDataChunk, IRowConsumer originalRequest, ParameterInfoCollection dataSetParameterValues,
ReportProcessingContext originalProcessingContext)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.GetSharedDataSetChunkAndProcess(Boolean processAsIRowConsumer, DataSetInfo dataSetInfo, ParameterInfoCollection datasetParameterCollection)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQueryAndProcessAsIRowConsumer(Boolean processAsIRowConsumer)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)
processing!ReportServer_0-1!1f0c!10/31/2013-14:51:25:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!ReportServer_0-1!1f0c!10/31/2013-14:51:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report
processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'SWUK\33693WR' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSServiceDataProvider.CheckAccess(Byte[] securityDescriptor, ItemType itemType, ReportOperation operation, String catalogPath)
at Microsoft.ReportingServices.Library.SharedDataExecutionInstance.Execute(DataSetInfo dataSet, String targetChunkNameInReportSnapshot, ParameterInfoCollection dataSetParameterValues, ReportProcessingContext originalProcessingContext, Boolean originalRequestNeedsDataChunk,
IRowConsumer originalRequest)
at Microsoft.ReportingServices.Library.SharedDataSetExecution.Process(DataSetInfo sharedDataSet, String targetChunkNameInReportSnapshot, Boolean originalRequestNeedsDataChunk, IRowConsumer originalRequest, ParameterInfoCollection dataSetParameterValues,
ReportProcessingContext originalProcessingContext)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.GetSharedDataSetChunkAndProcess(Boolean processAsIRowConsumer, DataSetInfo dataSetInfo, ParameterInfoCollection datasetParameterCollection)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQueryAndProcessAsIRowConsumer(Boolean processAsIRowConsumer)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.Process()
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)
Also with the data source are using credentials stored securely stored in report manager, but everytime the report is rebuilt / updated the settings go how do U make them permanent.