Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS Email Subscription having Issue. Expand / Collapse
Posted Monday, January 14, 2013 11:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 25, 2016 9:53 PM
Points: 240, Visits: 964
Hi All,
I am using SQL Server 2012 Reporting Service. I have 5 Reports those need to deliver on email with the attachment as excel. But I'm facing issue some time report delivered some time not. I check the status of email delivery in Report server manager and status showing error:

“Failure sending mail: Service not available, closing transmission channel. The server response was: Unexpected failure, please try later”

I unable to understand how to troubleshoot this error. I cross check SMTP server it fine. I'm facing this issue after upgrading from SSRS 2008 to 2012. Earlier the same SMTP used and I never face such kind of issue. Please suggest how to troubleshoot it.

Post #1407035
Posted Monday, March 18, 2013 10:59 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:16 PM
Points: 988, Visits: 1,923
You may need to coordinate with your IT group. Sometimes the Exchange server ( I assume it is Exchange) may have rules that do not accept messages from unknown domains or even user within your domain. So if in the email task the From field has a non-existing user, your email transmission could be rejected or just ignored.

If this is okay you may need to check permissions for the account the task runs under.

How to post forum questions to get the best help
Post #1432271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse