I have created a data driven subscription to send a report to 3 internal email addresses via an SMTP server. It is a very simple dummy report that works fine when run manually. It also works perfectly when I choose to deliver it to a file folder rather than by email. The error that I get is
The transport failed to connect to the server.
I changed the options to not include the report only send the link and that worked for 1 email address. It sent it to myself but did not get delivered to the other addresses.
I tested the smtp connection by using telnet to send an email. So the two issues I need to resolve are
1. Why is it only sending it to myself and not the other internal email addresses?
2. Why is it not sending anything if I include the report as an attachment?