How to fix this error from SSRS log file while trying to send a report====ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: Transaction failed. The server response was: Acces

Question

Several Reports are on the the SSRS subscription, and neither of them sent out due to this error on the log file==ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: Transaction failed. The server response was: Access denied: Amazon SES no longer supports TLS 1.0 and TLS 1.1 connections. You must update your client to use TLS version 1.2 or above. To learn more and to update your client, see https://go.aws/3AUlVSb. For further assistance, contact AWS support

Answer 1

You need your SSIS packages to support TLS 1.2. See

https://techcommunity.microsoft.com/t5/sql-server-support-blog/tls-issue-with-ssis-package-while-accessing-odata-source-like/ba-p/319077

You success may depend on your Sqlserver version. Also the o/s must have any required service packs to enable TLS 1.2

Answer 2

Hi @IT HELPDESK

Based on your error message, this appears to be an Amazon SES issue. Amazon SES will soon stop supporting TLS 1.0 and TLS 1.1 in its SMTP interface. I found this link for you: https://aws.amazon.com/blogs/security/tls-1-2-required-for-aws-endpoints/.

For more information, please seek help on the relevant platform.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya