sqlsql-serverdatabase-mail

SQL Database Mail Not Working - But I can send email on same server using VBscript CDO

I have searched everywhere (it feels) for a solution and / or guidance. My last resort is to ask. I have SQL Server 2016 running on a Windows Server. Database mail is not working. I have setup the profile and have submitted a test email by right clicking on the Database Mail node in the SSMS left window.

The email is in an 'unsent' status when I query SQL using SELECT * FROM msdb.dbo.sysmail_allitems;

I created a VBscript file to send an email using CDO - using the same email server values (host name, port, email from, user name, password, etc). The CDO script successfully sends the email.

I'm not sure where to go to troubleshoot SQL.

There is no data being written to SELECT * FROM msdb.dbo.sysmail_event_log;

Admittedly I am not very good with the SQL configuration - I just need to get it setup. I'm trying to determine why the status is just staying in 'unsent'. Is there an action I can do to force a send? Is there some message or log somewhere I can look at to see why it isn't move forward?

EDIT: I have put the same credentials into sql reporting services configuration 'email settings' - and I am able to create subscriptions and successfully send emails. And that confuses me because I see that SSRS Subscriptions require access to the SQL agent and creates a scheduled job.

So what is different about my database mail account in SQL then the one I created in SSRS? ( I understand that I am not posting pictures but that those wizards have personal info so I don't know the value in posting screenshots for data values I can't share ).

Any help is appreciated. Thanks

Solution

  • This issue is resolved. Thank you @AlwaysLearning. I had to update the server by installing .Net Framework 3.5. Then - following your guidance I ultimately found my problem was with the SSL check box and port 465. I was able to send email using port 25 with no SSL, and also to send TLS on port 587. But SSL and port 465 are still causing problems.

    For me however, that is not my main concern. That problem has been passed to someone else in the chain to work on. I am able to use Database Mail.