SSRS 2008 R2 data source authentication issue
Hello, End-users with Browser permissions for the necessary SSRS folders and reports are getting "The permissions denied to user [Windows user] are insufficient for performing this operation (rsAccessDenied) even though the data source for the report is configured to use 'credentials stored securely in the report server' and 'Use as Windows credentials when connecting to the data source' is checked. Users who are members of the local admin machine hosting the Report Manager site don't get the error. But users with full control permissions to the SSRS directories, including the config files, do get the error. Obviously, the solution shouldn't entail giving end-users local admin or even full control permissions to the SQL Server SSRS folders. Moreover, the error only occurs when using Windows credentials but not when using only a database credential, i.e. non Windows credentials. This workaround doesn't work for me since I'm also using a data source connection to SSAS, which doesn't appear to use database logins - only Windows credentials that are added to roles. Please advise. Thanks, Ben Lezin
January 22nd, 2011 8:11pm

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

Other recent topics Other recent topics