Goal
You need your users to be able to create Subscriptions to SSRS reports in Report Manager. They need to enter a list of email addresses in the to fields separated by ;. You have just upgraded from 2005 SSRS to 2008. This functionality goes away by default.
Environment
SSRS 2008 R2, IIS 7.0.
Issue
Default behavior out of box is that users with browser rights can setup subscriptions, but they To box is greyed out. Also the To field is set to your windows user id. It will then paste on your @company.com based on your Active Directory. Users want to be able to send to maybe their yahoo account or other users. Maybe multiple users just like in 2005.
In 2008 The user has a greyed out To: field as in the image below.
Resolution
You just need to change a setting in the RSReportServer.config file. To find this file Navigate to the ReportServer Folder for SQL Server. Under it will be the config file. Inside the file search for the SendEmailtoUserAlias Entry. Change True to False in that Tag. You may have to do an iisreset but I have never had to. That’s it. Nice and simple.
Conclusion
SSRS has default settings that do not allow users to enter emails in subscriptions free text as it did in 2005. You have to change a config file to get it to do that.
