Server Fault is a question and answer site for system and network administrators. 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'm reasonably new to SQL Server Reporting Services and Report Manager, and completely new to SSRS's Subscriptions. We're running SSRS 2008.

Out of the box it seems that a user with the Browser role can create a Subscription to a report and schedule it to run at any time they choose.

As an admin I have setup a schedule called "Overnight reports" and have it run every night from 1am.

I would like it so that when a regular user creates their Subscription they can only use one of my shared schedules so that their subscription will only run overnight.

Is this possible?



share|improve this question

No SSRS does not support this level of granularity with its security model.

I entered this connect feature request awhile back, please upvote it if you think it would be useful:

share|improve this answer

You can create the report so it generates from a snapshot - under execution options "Render this report from a report execution snapshot"

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.