Link to home
Start Free TrialLog in
Avatar of Dan
DanFlag for United States of America

asked on

database mail not working in sql 2016

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.
ASKER CERTIFIED SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dan

ASKER

Thanks,!that solved it.....