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.

Issue :-

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 :-

  1. Added my windows domain id to report manager and given all roles that are there still no success.
  2. Added server to the trusted sites in the IE, still no success.
  • While this is a good question, it's not a good fit for this site. I'm going to vote to close this to try to migrate it to DBA.StackExchange.com or ServerFault.com This isn't a programming issue, it's a server permissions issue. Good luck! – David Stratton Oct 5 '12 at 2:27
  • This seems contradicting because the report runs ok on the report manager (which requires a data source) but you can't set up a data source for a subscription (you should be able to use the same data source that worked before). When you originally ran the report on the report manager, was that locally on the server? Are you able to run the report in the report manager remotely? – dev_etter Oct 9 '12 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy