Lately I had been working on an assignment sending emails using SQL Server’s Database Mail. The only issue that I was having was that mails weren’t being sent out despite me double and triple checking the email profile, the SMTP settings and all the rest. This went on until it was time for lunch, when a colleague suggested the anti-virus program that we use. We use McAfee VirusScan Enterprise, and that was exactly what was giving me the problem. Apparently VirusScan prevents mass mailing worms from sending mail.
SQL Server Database Mail a mass mailing worm? Well looks like you can turn it into one!
Just uncheck the ‘Block’ for preventing mass mailing worms from sending mail under the Anti-virus Standard Protection category, and all shall work well.