Getting Error message when using Subscription in SSRS 2008
Hi, Below error message i am getting while trying susbcription. "Failure sending mail: At least one of the From or Sender fields is required, and neither was found. Mail will not be resent." Although i have set email addresess for from and to properly in reporting service configuration and subscription.I am using remote SMTP here. Could anyone help me out here.
August 27th, 2012 12:52am

Make sure whether you specify an alias instead of a full e-mail address for the sender of the e-mail subscriptions . When the report server tries to deliver a report as a part of the e-mail subscriptions, you receive this error message. For details please click the link http://support.microsoft.com/default.aspx/kb/945601 Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/ Blog : MS SQL Development and Optimization Blog : Large scale of database and cleansing
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2012 1:02am

Hi Amboo87, Thanks for your posting. According to the RSreportserver.config file you posted, it seems that the sender e-mail address is not a full e-mail address indeed. The email address format should be like email-acount@<HostName>. Based on your config file, you can try the email-account@Webmail.nagarro.com or Webmail@nagarro.com. If the issue persists, please feel free to let me know. Regards, Mike YinMike Yin TechNet Community Support
August 30th, 2012 9:28am

Thanks for the reply, I had tried by giving full email adress and allias as well but it doesnot work.Below is the email configuration which i am using.Could you please help me what setting wrong i am providing here. <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>72.35.23.194</SMTPServer> <SMTPServerPort>25</SMTPServerPort> <SMTPAccountName> </SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> </SMTPServerPickupDirectory> <SMTPUseSSL> </SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate>0</SMTPAuthenticate> <From>Webmail.nagarro.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats> </PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>nagarro.com</DefaultHostName> <PermittedHosts>nagarro.com</PermittedHosts> </RSEmailDPConfiguration> </Configuration> </Extension>
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2012 4:10am

Hi Amboo87, Thanks for your posting. According to the RSreportserver.config file you posted, it seems that the sender e-mail address is not a full e-mail address indeed. The email address format should be like email-acount@<HostName>. Based on your config file, you can try the email-account@Webmail.nagarro.com or Webmail@nagarro.com. If the issue persists, please feel free to let me know. Regards, Mike YinMike Yin TechNet Community Support
August 31st, 2012 9:37am

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

Other recent topics Other recent topics