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?