• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 43
  • Last Modified:

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?
0
rick
Asked:
rick
1 Solution
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now