Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Cannot impersonate user

Author  Topic  Jack_Oh Starting Member 7 Posts Posted - 2010-03-15 : 12:30:12 I have a user that is getting an error when they try to run a report. see below ERROR MESSAGE: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source "MyDataSource". (rsErrorImpersonatingUser) Log on failed. (rsLogonFailed) Data Source Settings: I have the Credentials supplied by the user running the report option selected. As well as Use as Windows credentials when connecting to the datasource. QUESTION: I was wondering does the user have to have privileges to the Database in order to run a report that is using a datasource connected to a Database. Thanks for any help or suggestions Ronald Rex