0

I need to schedule a SSRS report to be sent on daily basis. So, I created a data driven subscription. It's showing the status as "Done: 1 processed of 1 total; 0 errors." Also in the ReportServerDB, there are corresponding report entries in Subscriptions table. But still mails are not getting delivered. Please let me know what steps am I missing?

Anshul
  • 13
  • 5
  • You probably didn't miss any steps, at least from the subscription perspective. Talk to your email admin, see if there is anything going on there. – R. Richards Jan 19 '17 at 12:31
  • Has any subscription email ever been delivered before? – SS_DBA Jan 19 '17 at 12:47
  • No @WEI_DBA. I'm subscribing it for the first time. – Anshul Jan 19 '17 at 12:52
  • In the Reporting Services Configuration Manager on the SSRS server, did you specify the E-mail Settings properly? – SS_DBA Jan 19 '17 at 12:55
  • Actually, @R.Richards, I tried to ping the smtp server but it's timed out. Is this the cause of the problem? – Anshul Jan 19 '17 at 12:57
  • @WEI_DBA, Yes, I think so. I specified my email Id and SMTP server in the settings just for testing. Could you please tell me if we could specify our email or is there some Admin email for this purpose? – Anshul Jan 19 '17 at 13:00
  • Just as long as that email account has permissions to send email from the smtp server. – SS_DBA Jan 19 '17 at 13:03
  • Thanks @WEI_DBA for the information. – Anshul Jan 19 '17 at 13:05
  • @Anshul, that could be an issue. But, pings my not be allowed to the server, or it just doesn't respond to a ping. You really need to make sure email can be sent via that server. Like, WEI_DBA mentions, permissions should be checked. A more likely culprit in this situation. – R. Richards Jan 19 '17 at 13:09
  • @R.Richards, thanks for the information. – Anshul Jan 19 '17 at 13:18
  • Another possibility that I have encountered - the report was sent but was rejected by a mail server because the report was too large (>10M). – Hannover Fist Jan 20 '17 at 00:09
  • Actually, file size is < 100 KB. But I don't know if this is a issue because of firewall or some other thing? – Anshul Jan 20 '17 at 12:57

0 Answers0