Hi all, I have a situation where I have set up a DDS for email delivery, the sql data source behind is pretty complex but all works fine in testing etc.
I set the DDS up to run and it appears to run fine, I get the "x processed of x, 0 errors" on the subscription page of the report and the logs seem to reflect that there were no errors also.
This issue is the emails are just not getting to me, I've double checked I've got the address correct etc.
Where do I start looking to see what's happened? I'm pretty sure it's going to be the client's mail server not playing nicely but I just need a few ideas so I can point their IT team off in the right direction
asked Apr 23, 2012 at 11:29 AM in Default
The following are possible: If your attached email is too large, then your exchange server (for example) will block it. Same, if there are lots of email addresses in the 'to' or 'cc' field etc.
Hope that helps.
If it gets through, then it will help you to determine if the issue is at the sql end, or the mail end.
answered Apr 23, 2012 at 12:42 PM
Can you(they) successfully send an email using TSQL?
Just some ideas.
answered Apr 23, 2012 at 12:31 PM
Thanks for the input guys, turns out the ssrs service was set up to use an email account as the sender that didn't exist. The mail server didn't like this as sent them off into the electronic abyss instead of the intended recipient
answered Apr 26, 2012 at 11:05 AM