Thanks but still i am not clear my question is i am administrator (member of sms admins group) i am unable to view report either from console or report (link) so by default should have access to report? if any settings need to change at database level i
have used domain account to install reporting service and service is up and running but administrator unable to access the report if any alternative way to fix this issue? after fixing this issue i want to create 2 group like report administrator and
report viewers
An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at this computer
i have tried access from console logged as administrator but still enable to access
First off, I never recommend access the report via the console too much overhead.
If the reports will not work from the web interface, they will never work in the console.
The error message that you posted above is clear. there is a permission issue with your SSRS execution account.