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