Multiple emails triggered by SSRS

Adam 1 Reputation point
2021-04-22T03:10:55.13+00:00

I started to see the below error message in my ReportServerService log file after we switched over to a new SMTP relay. Multiple subscription emails get delivered to the recipients ( a total of 4 email every 15 min). There are times that only one email is triggered, but most of the time there are multiple email. At this point I have no idea what's causing this issue.

emailextension!WindowsService_0!1f2c!04/21/2021-22:51:14:: e ERROR: Error sending email. Exception: System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

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,813 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-04-22T06:44:23.297+00:00

    Hi @Adam-2272 ，
    This issue is related to connection to SMTP server so check if the report server is being blocked on the SMTP server. Couple of checks you can perform are:

    Check if there is any communication problem between report server and SMTP server .
    Ensure that report server has been added to the SMTP Relay.
    Follow below steps for this on SMTP server machine:

    • In Computer Management, drill down to the IIS branch.
    • Select the Default SMTP Virtual Server.
    • Right click Default SMTP Virtual server and select Properties
    • On the General tab, change IP address to 'All Unassigned'.

    Note: It is necessary to stop, and then start the SMTP service to ensure the changes take effect.

    This seems to be more about SMTP connection issues, I am not sure if the above information can help you.

    Best Regards，
    Joy

    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.