SSRS subscription fails with Protocol violation

Roland Goldsack 1 Reputation point
2021-12-16T14:33:14.513+00:00

We have SSRS reports with multiple subscriptions - recently we have been having some of the subscription fail with protocol violation when running as scheduled. If we manually rerun the subscriptions they work.

The log file shows the following error:

notification!WindowsService_4!1d04!12/16/2021-02:00:15:: i INFO: Handling subscription 19ff974f-f006-4e61-9e85-fcbeacb934bb to report BIXXXXX Tender Report, owner: DDDD\XXXXXXXXXX, delivery extension: Report Server Email.
library!WindowsService_4!1d04!12/16/2021-02:00:15:: i INFO: RenderForNewSession('/Reports/UAT/BIXXXXX Tender Report')
library!WindowsService_4!1424!12/16/2021-02:00:15:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
library!WindowsService_4!38d4!12/16/2021-02:00:15:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
library!WindowsService_4!1424!12/16/2021-02:00:15:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
library!WindowsService_4!38d4!12/16/2021-02:00:15:: i INFO: Initializing StoredParametersThreshold to '1500' characters as specified in Server system properties.
library!WindowsService_4!1424!12/16/2021-02:00:15:: i INFO: Initializing StoredParametersThreshold to '1500' characters as specified in Server system properties.
emailextension!WindowsService_4!38d4!12/16/2021-02:00:17:: 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)

Nothing has changed with our SMTP or Report server.

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.
3,065 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,636 Reputation points
    2021-12-17T06:31:18.203+00:00

    Hi @Roland Goldsack
    This error message looks like an error occurred when the subscription request was delivered to the SMTP server. The reason for the error may be related to the authentication mechanism. What normally happens is that the server offers a number of authetication options, and the client choses which one it is going to use. The behaviour from there should be determined by the protocol chosen.
    You could enable logging for System.Net.Mail. Then view the log file. This will show you exactly what is happening during the SMTP layer. For more information. plase refer to: How do I create a log file of the SMTP session?

    At the same time, please check whether there are related error messages in the Event viewer which will help to troubleshoot.

    Best Regartds,
    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.

    0 comments No comments

  2. Andreas Hermansen 1 Reputation point
    2022-01-19T10:38:16.303+00:00

    Hi - any solutions to this error?

    br Andreas

    0 comments No comments

  3. Roland Goldsack 1 Reputation point
    2022-01-19T12:35:31.967+00:00

    Hello,

    Sorry for delay.

    It was a TLS mismatch and we had to implement the registry settings on our SSRS servers which corrected he issues.

    The changes were from the following link:
    https://learn.microsoft.com/en-us/answers/questions/184492/sql-server-2016-database-mail-cannot-send-email-sm.html

    Hope it helps others resolve the issues.


Your answer

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