Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
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
add comment

migrated from stackoverflow.com Oct 5 '12 at 12:35

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.