What’s the problem?
How to configure SQL Server Reporting Services 2005 to permit users to assign the delivery email address for their own subscriptions.
Why does SQL Server work this way?
When you subscribe to a report, the e-mail delivery settings you work with vary depending on whether your Role includes the “Manage individual subscriptions” task or the “Manage all subscriptions” task. See E-Mail Delivery in Reporting Services for further information.
By default, a Reporting Services user cannot modify the email delivery target for their own subscriptions. Now providing a user the ability to Manage All Subscriptions on a given Report Server is not really a practical solution.
How can I make it work my way?
As an alternative what you can do is modify the security settings of the Report Server to allow a user to specify the delivery email address for their own subscriptions.
This requires a configuration change to the Report Server Configuration File
Modify the value for the “SendEmailToUserAlias” XML Attribtue to be “false” in order to permit any email address to be specified.
See Configuring a Report Server for Email Delivery for detailed instructions.
If you are going to permit your Report Server users to be able to specifiy the delivery address for their subscriptions then it is wise in my opinon to also limit the Domains to which you permit delivery to, for example only trusted domains internal to the organisation. This can also be configured within the very same Report Server configuration file.
There you have it. Simple when you know how.