After a certain update installed on my Microsoft SQL server 2017 my database mailing no longer works. I installed the latest CU 5 for sql server 2017 as this was suggested to resolve the issue online. After installing the update the databse mailing still didn't work. However I noticed that before I did the update the emails will go out if I manually open the databasemail.exe now I was receiving a dot net 4 not installed error message
I have also tried changing the content of databasemail.exe.config file to:
The mails in the q is then send out but once I close it or it closes after 5 seconds closes by itself, and try sending a mail from sql without manually opening databasemail.exe they just stay in the q. The mail log also only shows service started and service ended, wish I believe happens when I manually open the databasemail.exe.