reporting services 2008 email subscriptions
We recently converted from RS2005 to RS2008. In RS2005 when our users subscribed to a report to be delivered by email, RS would automatically add the user name to the "To" field for report delivery. The user would be added with the format "joe.smith" but without the domain (i.e. "@mycompany.com" ). This worked fine and our users would get the reports emailed to them.In RS2008, RS is also defaulting the "To" withthe name portion of the email address "joe.smith" just like it did in RS2005. However, this does not work in RS2008. I get the following error "Failure sending mail: At least one recipient is required, but none were found. Mail will not be resent."Did we miss a configuration setting? Or is this a change in how RS operates?tia,-bruce
November 20th, 2009 11:52pm

Hi Bruce,For SSRS 2008,if you are distributing Reports within an intranet and you are using an SMTP gateway to a Microsoft Exchange server, type the e-mail alias.If delivery is to an external e-mail account, type the full e-mail address.Please check this http://msdn.microsoft.com/en-us/library/ms159155.aspxfor how toconfigure a report server for e-mail delivery, especially the part of "Configuration Options for Setting the To: Field in a Message".thanks,Jerry
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2009 9:25am

I have Reporting Services 2008 R2 and I'm getting this: Failure sending mail: At least one recipient is required, but none were found. Mail will not be resent. If i enter edgar@mycompany.com, then the email subscription goes fine. But if I enter edgar without the @domain then it fails. Any ideas? Server Details Windows 2008 64bit SSRS 2008 R2 64bit.
October 8th, 2010 6:34pm

When my users go to add a subscription, the TO field is defaulting to their network username, not their email alias. Many of them don't know any better and just click ok, then of course don't get any email. Is there anywhere in RSREPORTSERVER.CONFIG to make sure it's pulling info from the right place? Thanks :) Eric
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 12:42pm

yes. you have to edit the config file: 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. http://msdn.microsoft.com/en-us/library/ms159155.aspx
April 13th, 2011 12:46pm

Thanks for the reply Edgar. Yeah I had read that and was considering that route. So there is no way to have it default the alias instead of the domain account? No biggie if not, my users are certainly capable of typing their email addresses in...I hope ;-)
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 12:55pm

those instructions will autopopulate the email TO box with their user name (without the domain) so if user is domain\perez.prado then the TO box will say perez.prado then the email will be sent to perez.prado@yourDomain
April 13th, 2011 1:09pm

Right, that part I understand. In our situation, our email addresses are different from our domain user accounts, as in: Domain User Account: domain\jsmith Email address: joe.smith@domain.com and therefore the alias is joe.smith. When I set the SendEmailToUserAlias to True, it autopopulates with jsmith, not joe.smith. So really, what I'm wondering is, is there a way to get it to pull the actual email alias and not just pull the Domain User Account and then strip off the domain part.
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 2:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics