- Define your SQL Email Configuration
- Write “smtp.office365.com” as server name
- Port should be 587 if not told otherwise
- Basic authentication with email and password is better
- SSL check box is a MUST
But if you still have problem on sending email:
ADD TLS 1.2 KEYS TO YOUR REGISTERY (requires restart)
- Below is the content for a simple executable registry file that I put together that will make the 2 new settings and the settings already shown on the thread above (i.e. this makes all of the necessary Registry settings*):
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319]
“SchUseStrongCrypto”=dword:00000001 - [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319]
“SchUseStrongCrypto”=dword:00000001 - [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]
- [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]
“DisabledByDefault”=dword:00000000
“Enabled”=dword:00000001 - [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server]
“DisabledByDefault”=dword:00000000
“Enabled”=dword:00000001
Note 1: SQL needs to be restarted for these settings to take affect but it is better to restart Windows since the new settings will affect .NET 4.x generally. - Note 2: In SQL, the SSL-checkbox must be ticked in the mail profile to use TLS1.2.
Still Have Problem on sending?
No responses yet