How to resolve Sending Mail failure from SSRS using Office365?

Avinash Rama 1 Reputation point
2021-10-28T14:22:37.89+00:00

library!WindowsService_2!2a9c!10/28/2021-15:54:49:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_2!2a9c!10/28/2021-15:54:50:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream.
at System.Net.Mail.SmtpConnection.ConnectAndHandshakeAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpTransport.EndGetConnection(IAsyncResult result)
at System.Net.Mail.SmtpClient.ConnectCallback(IAsyncResult result)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(TimeSpan timeout)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
---> (Inner Exception #0) System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream.
at System.Net.Mail.SmtpConnection.ConnectAndHandshakeAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpTransport.EndGetConnection(IAsyncResult result)
at System.Net.Mail.SmtpClient.ConnectCallback(IAsyncResult result)
--- End of inner exception stack trace ---<---
. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_2!2a9c!10/28/2021-15:54:50:: e ERROR: Error occurred processing subscription 655f228a-60db-47a8-8e48-da5c64588bde: Failure sending mail: One or more errors occurred.
library!ReportServer_0-3!14c8!10/28/2021-15:55:02:: i INFO: Call to GetItemTypeAction(/Discovery/Discovery Recon Report). User: DPRESIT\Avinash.Rama.
library!ReportServer_0-3!14c8!10/28/2021-15:55:02:: i INFO: Call to GetReportParametersAction(/Discovery/Discovery Recon Report). User: DPRESIT\Avinash.Rama.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2021-10-29T02:14:44.337+00:00

    Hi @Avinash Rama ，

    It seems that the TLS secure protocol caused the error .
    I refer to this thread：https://stackoverflow.com/questions/69724359/ssrs-server-system-io-ioexception-authentication-failed-because-the-remote-part

    Best Regards,
    Isabella

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.