ReportServer Forum

AndyM

Member

Registered: 2018-05-31

emails with attachments fail to send

Hi,

I am trying the report scheduler.
If I save the report to team site and either schedule it or "execute now" it is successful and I receive an email advising the report has run.
If I amend the schedule to send the report as an attachment, it fails to send the email, reporting SMTPSendFailedException: 550 5.7.1 Client does not have permissions to send as this sender.

Is the system trying to send emails that have attachments as a different email user to the one used for emailing notifications?

Thanks
Andy

eduardo

Administrator

Registered: 2016-11-01

Website

Re: emails with attachments fail to send

Hi Andy,

we are looking into this and trying to reproduce the problem. Do you have some screenshots showing the problem? You can post them to http://imgbb.com and post the link here.

Regards,
Eduardo

AndyM

Member

Registered: 2018-05-31

Re: emails with attachments fail to send

Eduardo,

Many thanks for looking at this.  I have detailed the steps below and included links to screen shots.

Thanks
Andy

Create a schedule
https://ibb.co/gMw9m8

Set up schedule to save report to team space
https://ibb.co/c0K6Yo

Click “Execute Now” and we see that it is successful
https://ibb.co/m90PKT

And the following email is received
https://ibb.co/m29qto

Now….. Change the schedule to send the report as an attachment
https://ibb.co/hJSX68

Upon changing the schedule, the following email is successfully received advising the old schedule has been deleted.
https://ibb.co/fkuZKT

Click “Execute Now” and the job fails
https://ibb.co/j15wYo

Failure message shown below.
https://ibb.co/nhQVto

and no email is received.

<end>

GBrown

Member

Registered: 2018-07-25

Re: emails with attachments fail to send

I just tried to schedule a report and received the same error. Screen shots look identical.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: emails with attachments fail to send

Hi AndyM,

thanks for your screenshots. We tested and this is the expected behavior:
All notifications are sent using the sender specified in mail.cf. This sender is used in your screenshot https://ibb.co/m29qto. The sender is the one configured in mail.cf. This is a notification since you don't get any report in your email; you only get the notification that a report was created.

On the other side, when you configure your schedule to attach the report into the email, the sender used is the creator of the schedule.

You should configure your email server to accept the reportserver's users as senders in order for this to work.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: emails with attachments fail to send

Check this for configuration of exchange:
https://docs.microsoft.com/en-us/exchan … ermissions

"the Send As or Send on Behalf permissions"

Regards,
Eduardo

AndyM

Member

Registered: 2018-05-31

Re: emails with attachments fail to send

Thanks Eduardo, that explains it.

Our test box is not part of the domain and doesn't have a valid user id to send mails.
The notification emails work because we can specify the login credentials for the smtp server (within mail.cf)
Is there any way to specify the login credentials when sending an attachment ?

Thanks
Andy

eduardo

Administrator

Registered: 2016-11-01

Website

Re: emails with attachments fail to send

Hi AndyM,

when sending an attachment, ReportServer uses the credentials in mail.cf and puts the scheduling user as sender. There is currently no way to set login credentials per schedule job/ per scheduling configuration.

Regards,
Eduardo