Share via

SSRS SMTP Send mail issues

kccrga 116 Reputation points
2021-10-29T00:35:22.893+00:00

Please help on the below send mail issue which doesn't happen due to authentication or user not exist in active directory. The send mail issue is an adhoc issue and doesn't happen everyday.

. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_12!486c!10/29/2021-00:00:42:: e ERROR: Error occurred processing subscription : Failure sending mail: One or more errors occurred.
library!WindowsService_12!e18!10/29/2021-00:00:43:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
library!WindowsService_12!10d4!10/29/2021-00:00:43:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_12!10d4!10/29/2021-00:00:43:: 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 ---<---

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.

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2021-10-29T02:20:21.63+00:00

    Hi @kccrga

    For anyone experiencing the same issue. Our support partner investigated this and it appears to be due to service degradation with Microsoft Exchange Online. Microsoft logged the following incident:

    Title: Some users are intermittently unable to access their mailboxes through multiple connection methods when using TLS 1.0

    User Impact: Users may intermittently be unable to connect to Exchange Online through IMAP, SMTP, and POP3 while using TLS 1.0.

    More info: Users of the legacy Transport Layer Security (TLS) version 1.0 are experiencing intermittent failures when attempting to connect to Exchange Online from IMAP, SMTP, and POP3.

    Current status: Our monitoring indicates that the fix has been successful in mitigating impact in the section of infrastructure. We're now rolling out this fix to the rest of the impacted environment.

    Scope of impact: A small subset of users of TLS 1.0 are intermittently unable to connect to Exchange Online from IMAP, SMTP, and POP3.

    Root cause: A CAFE TLS configuration issue is preventing some users from connecting to the Exchange Online service through IMAP, SMTP, POP3.

    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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.