Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.
share|improve this question

migrated from Oct 5 '12 at 12:35

This question came from our site for professional and enthusiast programmers.

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 or This isn't a programming issue, it's a server permissions issue. Good luck! – David 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 posting your answer, you agree to the privacy policy and terms of service.