I have 2 sql servers, old and new. They are external servers, not on my LAN, but there's an always on VPN, so they behave like they are on my LAN.
With my old server, I can use the feature "database mail" to send a test email.
On my new server, that doesn't work, and I even am using the exact same configuration.
Any ideas why? Is there a way to check the detailed logs, as I don't think sql is sending the emails.
1. checked the msdb database, table sysmail_log, and nothing there with errors, no entries there.
2. I checked my corporporate firewall and it's configured correctly as far as I can tell.
3. I checked my exchange server (hosted internally), and it's configured to allow my external sql servers to send emails.
4. I checked https://www.wormly.com/test-smtp-server
and did a test from the server and that worked fine.
What else can I try to get the "database mail" feature to work, as I need my sql to start ending emails.