Email subscription Reported as Successful but not arriving in recipients inbox.
I have a report that is sent via email to a list of recipients. When I look at the subscription in 'My Subscriptions' the value in the Status column states that the message was 'sent successfully', however the email does not appear in the inboxes of any of the intended recipents. The report renders OK via the browser and only takes a few seconds to process. The subscription exports the report as an Excel file. The excel file is approx 8MB in size but this is still below the attachment size limit for internal emails within my organisation. The subscription is tied to a shared schedule. Other reports that are tied to the shared schedule are shown as successful in 'My Subscriptions' and also appear in the inboxes of recipients. All email address are correct. I forgot to mention, the report was successfully received by all recipients until very recently and the report has not been modified since this time. Has anyone come across this problem before. Thanks Mike
January 24th, 2007 5:36am

The Reporting Services e-mail delivery extension considers "sent successfully" to be "I handed it off to some SMTP forwarder". What happens to the e-mail after that is outside the scope of RS. You need to investigate within the e-mail system. As a diagnostic, you might try delivering to an SMTP pickup folder temporarily to convince yourself that the Report Server is generating the e-mails. Find the rsReportServer.config file, change the "SendUsing" element to 1, specify some SMTPServerPickupDirectory, and try the delivery. If you get .EML files created in the specified folder, RS has done it's part of the delivery. Make sure you set SendUsing back to 2 or <blank> after you've done your test. Here's a sample of the config file section you need to modify: <RSEmailDPConfiguration><SMTPServer></SMTPServer><SMTPServerPort></SMTPServerPort><SMTPAccountName></SMTPAccountName><SMTPConnectionTimeout></SMTPConnectionTimeout><SMTPServerPickupDirectory>D:\Email</SMTPServerPickupDirectory><SMTPUseSSL></SMTPUseSSL><SendUsing>1</SendUsing><SMTPAuthenticate></SMTPAuthenticate><From>_awtest@Microsoft.Com</From><EmbeddedRenderFormats><RenderingExtension>MHTML</RenderingExtension></EmbeddedRenderFormats><PrivilegedUserRenderFormats></PrivilegedUserRenderFormats><ExcludedRenderFormats><RenderingExtension>HTMLOWC</RenderingExtension><RenderingExtension>NULL</RenderingExtension><RenderingExtension>RGDI</RenderingExtension></ExcludedRenderFormats><SendEmailToUserAlias>True</SendEmailToUserAlias><DefaultHostName></DefaultHostName><PermittedHosts></PermittedHosts></RSEmailDPConfiguration>
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2007 7:44pm

I made it, and my application create de e-mail at the 'D:\Email', I am almost sure that my problem is with my stmp server but I didn't find anything that can help me. I don't know how can I install the IIS to access a smtp remote like smtp.terra.com.br
August 26th, 2008 1:20pm

Have you checked the SSRS log files to see if there are any error messages that could help you find the issue? They are usually in a similar directory to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles.
Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2012 12:34pm

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

Other recent topics Other recent topics