The following could save you a great deal of time and effort.

It took considerable time and effort to discover that there are 2 essential, additional settings which are required to get this working which are not well known nor well documented, by Microsoft or on the web generally. TLS1.2 is the only version of TLS considered secure now (March 2019). The details is from this link (see the FAQ section) I have enabled TLS 1.2 by adding registry as shown below So how can we enable SSL and uses TLS 1.2 for db mail? Exception Message: Cannot send mails to mailīut if we turn off this SSL, there is no problem for db mail sent out. The mail could not be sent to the recipients because of the The error message in db mail log is as follows: We CANNOT send db mail (no matter whether our SMTP authentication is Windows Authentication, Basic authentication or Anonymous Authentication).

The issue is whenever we turn on SSL use msdbĮxec dbo.sysmail_update_account_sp = 1 We have the DB mail configuration as shown here. 4 (X64)ĭeveloper Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor) Our SQL Server version is: select SQL Server 2016 (SP1-CU7-GDR) (KB4057119). Our mail server is Exchange Server 2010, our SQL Server 2016 (Developer and Enterprise editions) boxes have OS of Windows Server 2016 Standard editions. Hopefully someone in our community has experienced the same issue and already found a solution.Īs per our company policy, we want database mail to be able to send emails over port 25 with TLS 1.2 enabled and with TLS 1.0 & TLS 1.1 disabled. I have been puzzled by this issue for almost 1 week.

App to test tls 1.2 .net 3.5