The permission granted to user '' are insufficiant for performing this operation (rsAccessDenied)

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.

October 31st, 2013 11:59am

Hi Clive,

From your description, you grant access permission to all the users, then the users can access to Report Manager successfully except one user, right? In this case, the issue can be related to the user's settings on his computer to Internet Explorer. Please try the mesures on the user side.

  • Run Internet Explorer as Administrator.
  • Add the Report Manager URL to trusted site on IE.
  • Remove the User Account Control (UAC) if possible.

If the issuer persists, you can try to create a group, add all users to this group, and then grant access permission to this group.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.

Free Windows Admin Tool Kit Click here and download it now
October 31st, 2013 11:07pm

Hi

Thanks for the information but its against our security policy for users to run IE under administator accounts or with elevated security.

The strange thing is it works for me and 2 others and yet new people added it is not working for.

Will look at putting them into an AD group.

November 1st, 2013 4:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics