Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Subscription and Delivery Availability

SQL Server 2005

Subscription and delivery features are available by default (e-mail delivery requires configuration before it can be used). The default delivery extensions include report server e-mail and file share delivery. Unless you create or install custom delivery extensions, these are the only distribution methods available to subscriptions. All delivery extensions installed on a report server are available to any user who has the capability of creating a subscription to a given report.

Subscription features are available to users through two tasks:

  • The "Manage individual subscriptions" task allows users to create, modify, and delete subscriptions for a specific report. Role assignments that include this task allow a user to manage only those subscriptions that he or she creates.
  • The "Manage all subscriptions" task allows users to access and modify all subscriptions. This task is required to create data-driven subscriptions.

Depending on how you use roles, you can provide subscription functionality to selected groups of users by enabling or disabling subscription tasks for different roles.

To prevent users from creating subscriptions, clear the "Manage individual subscriptions" task from the role. When you remove this task, the Subscription pages are not available. In Report Manager, the My Subscriptions page appears to be empty (it cannot be deleted), even if it previously contained subscriptions. Removing subscription-related tasks prevents users from creating and modifying subscriptions, but does not delete existing subscriptions. Existing subscriptions will continue to execute until you delete them. For more information about deleting subscriptions, see Creating, Modifying, and Deleting Subscriptions.

Delivery extensions are configured in the RSReportServer configuration file. To remove a delivery extension, you can edit the configuration file. To limit e-mail distribution, you can set configuration options that restrict delivery to certain mail server hosts. For more information, see Configuring a Report Server for E-Mail Delivery.

After you remove a delivery extension, it is no longer available in Report Manager or Management Studio. Removing a delivery extension can result in inactive subscriptions. Be sure to delete the subscriptions or configure them to use a different delivery extension.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.