Can't send e-mail through Database Mail SQL 2005

Question

I have tried a million times to configure our databasemail. I have followed the instructions in the forum, using both the Databasemail Wizard and doing it directly. Every single parameter looks fine.

So far, the Test mail gets sent without a problem, but when trying to send e-mails through the stored procedures is failing almost consistently. Sometimes the e-mail is sent, but sometimes it fails.

I'd understand if it always failed or if the test mail wasn't sent, but if only some are sent just doesn't make sense.

Is this a bug? 

Any ideas?

Answer 1

Share the error messages you are getting when DBmail failed to send mail

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 2

Hi JM Torres,

Follow these steps to check the status of e-mail messages sent with database mail and find the error message:

1. Select from the sysmail_allitems table, specifying the messages of interest by mailitem_id or sent_status.

2. To check the status returned from the external program for the e-mail messages, join sysmail_allitems to sysmail_event_log view on the mailitem_id column, as shown in the following section.

By default, the external program does not log information about messages that were successfully sent. To log all messages, set the logging level to verbose using the Configure System Parameters page of the Database Mail Configuration Wizard.

Since your SQL Server version is 2005, in Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you may receive the following error message when you send an e-mail by using Database Mail, to fix this problem, please also refer to this kb article:
http://support.microsoft.com/kb/968834/en-us

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.