Last Post 27 Jul 2007 01:58 PM by trans53. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Jul 2007 01:58 PM

Hi guys, i am not sure if i am missing something:

Created new report and added datasourse, but when i try to run report i got the following message:

Cannot impersonate user for data source 'TestDataSource'. (rsErrorImpersonatingUser)
Logon failed. (rsLogonFailed).

Here how iam trying to connect:

1. created stored procedure
2. created db role.
3. GRANT EXEC on stored procedure to the role.
4. used existing windows user account (this user account used by different reports) and added user to the role.

What else should i check?

Acceptable Use Policy