Email trigger not working from SQL 2017,IIS

[AlMuhammad]

Hi,

We are trying to trigger email notification from SQL and IIS but the email trigger not working. Please find the details below

OS Windows Server 2016

SQL Server 2017

SMTP Server office 365

I have tried multiple ways like powershell,SQL DB mail and web application (IIS 10). But i'm getting the below errors.

SQL DB server error belo

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2018-11-30T22:01:26). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
)


Powershell Error

Send-MailMessage : The remote certificate is invalid according to the validation procedure.
At line:1 char:1
+ Send-MailMessage -To mohammeda@domain.com -from mohammeda@domain.com ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.Mail.SmtpClient:SmtpClient) [Send-MailM
tionException
+ FullyQualifiedErrorId : AuthenticationException,Microsoft.PowerShell.Commands.SendMailMessage



Regards

Mohammed Ali

Continue reading...