I'm trying to send database mail over SSL/TLS-encrypted SMTP. It works when sending plain text email, but fails when I enable SSL/TLS.
The database mail log shows the following error message:
Date 6/02/2019 11:07:09 AM Log Database Mail (Database Mail Log) Log ID 11 Process ID 9476 Mail Item ID 6 Last Modified 6/02/2019 11:07:09 AM Last Modified By sa Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2019-02-06T11:07:09). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.). )
How can I find out more information about why SQL Server doesn't like the certificate?