Try to sending email not working with suscription in Reporting Services

Amin 1

Try to sending email not working with suscription in Reporting Services, the error is :

emailextension!WindowsService_29!475c!12/20/2021-07:00:08:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)
--- 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: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)<---
. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_29!475c!12/20/2021-07:00:08:: e ERROR: Error occurred processing subscription d218375a-a99f-4b7a-98e5-4bbcb6f4b6d2: Failure sending mail: One or more errors occurred.Mail will not be resent.

is any idea to solven the error?

Best regards

Chandrika Ramisetti 6 Reputation points

2022-01-04T08:34:18.837+00:00

Hii Mexman, is your issue resolved? If so kindly share us what you have done. We are also facing the similar issue
Ashish Sinha 1 Reputation point

2022-01-06T22:20:39.737+00:00

I had exactly the same error and it was too random. i.e. The SSRS was able to complete the timed subscription successfully and fail randomly with no further hints in the logs.
The only thing which was a suspect was the SMTP server itself. The error happened as we were using smtp.office365.com
The office365 smtp server was the real culprit because after reading some blogs I changed the SMTP server from office365 to AuthSMTP and it fixed the problem straightaway.

AuthSMTP is a SMTP relay service but you can use any other SMTP relay server depending on your need and usage.

Hope it helps other users!

13 answers

Joshua Pries 1 Reputation point

2022-01-05T16:44:31.207+00:00

Glad to hear others are at least having similar issues. Not sure if it helps much, but the below is from my log.
This happened today after completely uninstalling SSRS and reinstalling. Reuploaded all reports and recreated subscriptions.
Will try to use Gmail SMTP instead to see if there's any difference.

emailextension!WindowsService_1!1dfc!01/05/2022-07:30:08:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)
--- 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: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)<---
. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_1!1dfc!01/05/2022-07:30:08:: e ERROR: Error occurred processing subscription 7bd2de99-a658-41d6-a983-471bad6d1c34: Failure sending mail: One or more errors occurred.Mail will not be resent.
notification!WindowsService_1!1dfc!01/05/2022-07:30:08:: i INFO: Notification 649fbb60-77f2-4e81-bc1f-f92c815c59b9 completed. Success: False, Status: Failure sending mail: One or more errors occurred.Mail will not be resent., DeliveryExtension: Report Server Email, Report: Equipment Maintenance Visiblity, Attempt 0
library!WindowsService_1!232c!01/05/2022-07:33:29:: i INFO: Call to CleanBatch()
library!WindowsService_1!232c!01/05/2022-07:33:29:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions, 0 extended content cache.
library!WindowsService_1!232c!01/05/2022-07:33:29:: i INFO: Call to CleanBatch() ends
library!WindowsService_1!d28!01/05/2022-07:43:29:: i INFO: Call to CleanBatch()
Please sign in to rate this answer.
Ilan Myers-Prudhomme 1 Reputation point

2022-01-05T17:49:33.127+00:00

It could be that there are multiple factors that can contribute to this error. Duplicate send to email addresses and/or rapidity of sending emails. I never get the error when I'm sending just one email via a SSRS subscription and have been doing so for a while. It's just when I'm sending multiple emails with Office365. I am looking to test a different SMTP service next as well.

Ilan Myers-Prudhomme 1 Reputation point

2022-01-05T18:50:53.907+00:00

I just tested using gmail's (GSuite) SMTP server, and I was able to send all the subscription emails four times without any errors. I switched back to Office365 and on the second attempt 2/3 emails failed. So it does seem to be related to using Office365.

04147834 6 Reputation points

2022-01-05T18:53:05.077+00:00

I receive the error sending to one e-mail address, one distribution list, and multiple e-mail addresses listed individually.

GlockByte 161 Reputation points

2022-01-06T20:29:40.873+00:00

Mine fails sending to 1 recipient, however it's not always failing (it seems to be picky). Possibly related to TLS, I made some changes to the registry and IIS but can't restart until after work hours. I'll be back here if I find something.

Joshua Pries 1 Reputation point

2022-01-06T22:23:35.42+00:00

There are no duplicate emails in my subscriptions. Some are scheduled at the same time but like I said before I have 7 subscriptions total. Sending out 2 subscriptions at the same time I know is possible.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
04147834 6 Reputation points

2022-01-06T21:51:53.833+00:00

Personally, I had many false positives for fixes. I would make a change or reboot the server. A few reports would deliver by email then the error would return.
Please sign in to rate this answer.
Anonymous

2022-07-07T13:58:20.357+00:00

I tried all the possible fixes provide here, nothing is fixing the issue. I am keep getting the same error.
I tried over 3 servers - Can any one please assist.
emailextension!WindowsService_0!2a1c!07/07/2022-06:36:19:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)
--- 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: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)<---
. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_0!2a1c!07/07/2022-06:36:19:: e ERROR: Error occurred processing subscription bf044fc4-a25c-4206-83b6-0c26976950f7: Failure sending mail: One or more errors occurred.Mail will not be resent.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Ilan Myers-Prudhomme 1 Reputation point

2022-01-07T01:24:01.133+00:00

Ok, here is a solution to this issue that is definitely working for me now.

I setup a local SMTP server via IIS 6.0. I configured it as an SMTP relay to Office365 using the same login I was using for SSRS. Then I configured SSRS to use my new local SMTP. The email messages are still coming through Office365 using the authenticated email account I had originally setup, which I needed, and I have run it 10 times with no errors. I have actually installed the SMTP service on another server in our network, rather than installing it locally on the same server as SSRS, but it can be installed on either. I know this doesn't address the problem I was having connecting to SSRS directly to Office365, but it's working well now.

Here is the link I found to help me setup and configure the SMTP Relay:
https://devondba.blogspot.com/2014/07/configuring-application-to-email.html

Here is another link, though the first one was easier to follow:
https://support.datasharp.uk.com/portal/en-gb/kb/articles/how-to-configure-iis-for-relay-with-office-365
Please sign in to rate this answer.
Joshua Pries 1 Reputation point

2022-01-17T23:54:14.63+00:00

Relay seems to be working perfectly.
Thank you for the recommendation!
Microsoft needs to get it together...
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Try to sending email not working with suscription in Reporting Services

13 answers

Your answer