question

AvinashRama-5201 avatar image
0 Votes"
AvinashRama-5201 asked Isabellaz-1451 edited

How to resolve Sending Mail failure from SSRS using Office365?

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi All, im using SSRS with SQL 2017. I have Email setup on SSRS that connects to O365 successfully on one server, however on another server i used the same configurations and im getting this error: "Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream."
and have no idea how to resolve it.

0 Votes 0 ·

1 Answer

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Isabellaz-1451 edited

Hi @AvinashRama-5201

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.