SSRS - Subscription Errors

First - I'm new to reporting services.

I work in a large corporation and was just given a folder in which to publish reports.   I do not have access to modify any reporting services attributes on the server - has to go through the DBA.

I'm trying to create a distribution list for a report.

When I go to create a subscription, the section titled "Delivery options (E-Mail)" is grayed out.  So I can't edit.   Ultimately, I want the report to go to multiple users.  But I get the following error trying to send it to me:

"Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent."

How do i fix?  How would I send to multiple users?  Do I need to tell the DBA enable anything?
rickAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
you need to make sure you enter the email correctly like:

rptuser1@mail.com

To enter multiple email addresses use the ";" in between the email addresses like:

rptuser1@mail.com;rptuser2@mail.com;rptuser3@mail.com;rptuser4@mail.com

One note though with SSRS Subscriptions: every single email from that multiple subscribers list must be valid otherwise NO subscription is sent and I found this the hard way so my advise is to ask for email groups to be created - just think - people come/leave companies every day so you would constantly need to upgrade subscriptions which is a HUGE pain if you have many reports/subscriptions.

On the Delivery option greyed out - In BOL, Managing Subscriptions then How to: "Subscribe to a Report (Report Manager)" which leads to "Configuring a Report Server for E-Mail Delivery"  you can find:
http://msdn.microsoft.com/en-us/library/ms159155.aspx -- Configuration Options for Setting the To: Field in a Message
<<
Configuration Options for Setting the To: Field in a Message

User-defined subscriptions that are created according to the permissions granted by the Manage individual subscriptions task contain a pre-set user name that is based on the domain user account. When the user creates the subscription, the recipient name in the To: field is self-addressed using the domain user account of the person creating the subscription.

If you are using an SMTP server or forwarder that uses e-mail accounts that are different from the domain user account, the report delivery will fail when the SMTP server tries to deliver the report to that user.

To workaround this issue, you can modify configuration settings that allow users to enter a name in the To: field:

Open RSReportServer.config with a text editor.
Set SendEmailToUserAlias to False.
Set DefaultHostName to the Domain Name System (DNS) name or IP address of the SMTP server or forwarder.
Save the file.
Restart SSRS Service
>>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.