I have created one SSRS text report. I have built and deployed it successfully. I am also able to view it from the report manager succesfully. I am a local admin on windows server but not on SQL Server.
I am trying to schedule a report to run on a daily basis. When I go to Data sources to store my windows id credentials, it's not allowing me to do so throwing below error.
The permissions granted to user 'app\abcid' are insufficient for performing this operation. (rsAccessDenied)
Things I have tried :-
- Added my windows domain id to report manager and given all roles that are there still no success.
- Added server to the trusted sites in the IE, still no success.