SSRS Data Driven Subscription Email Delivery is failing with : Status Code : MailBoxUnavailable : <EmailID> not authorized.

Question

We have setup SSRS 2016 on a new server. ReportServer Database has no change, it is pointing to old DB, only SSRS server has been upgraded.

We have 2 types of Data driven subscription in our application.

1. Sharepoint Upload (working fine)
2. Email Delivery - has following issues.
   This subscriptions has a sharepoint list data-source. The parameter To, CC, BCC come from a sharepoint list defined on our application. These subscriptions are failing with following error :

--*** When only TO parameter is passed and CC BCC are blank :
Failure Sending Mail. MailBoxUnavailable. The server response was <some e-mail Id.com > Not Authorized.

--*** When TO, CC, BCC all parameters are passed :
Error sending email to one or more recipient.
Error sending email to address : <some e-mail ID.com> SMTP StatusCode: MailBoxUnavailable
Error occured processing subscription <SubscriptionID> : Failure sending email. Unable to send to all recipient.

Anybody could please suggest what are we missing here.

our reportserver config file is set to No Authentication Mode.

<SMTPUseSSL> False </SMTPUseSSL>
<SendUsing> 2 </SendUsing>
<SMTPAuthenticate> 0 </SMTPAuthenticate>
<From> some authorized account </From>
<SendUserName></SendUserName>
<SendPassword></SendPassword>

Please let me know what are we missing here.

Answer 1

Hi @Anupriya Athalye ,
Make sure that the user in the <From><From> field is a user account that has permission to send mail from the SMTP server. Usually we will set it in the Sender Address of the configuration manager

You also need to set configuration options for the "To:" field in the email.
Set <SendEmailToUserAlias> to False.
Set <DefaultHostName> to the Domain Name System (DNS) name or IP address of the SMTP server or forwarder.

Note: If you are using an SMTP server or forwarder that uses a different email account than the domain user account, the report delivery will fail when the SMTP server attempts to deliver the report to that user.

For more information, please refer to: E-Mail Settings - Reporting Services Native mode (Configuration Manager).

Usually we can view detailed error information in LogFiles, please check the error log under the path file and share it here. If the error comes from the SMTP , there may be an error code specified.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.