DBMail - cannot send mail using sp_send_dbmail

[wltenney]

I am trying to set up dbmail on SQL 2005. I have created a profile and account which uses smtp on an exchange server. All works fine when I use the Send Test E-mail in SQL Management Studio. However, if I attempt to send an email using sp_send_dbmail, the message is not sent. The SQL log reports that the email was successfully sent and the message appears in the sentitems table, but the recipient does not receive the email (same recipient in both cases).

I'm wondering what to check next. It appears that dbmail thinks that it has successfully sent the message so the problem is probably at the smtp server, but Test e-mail and sp_send_dbmail are both using the same e-mail account and recipient.

 

[mrdenny]

If SQL is saying that the email was sent then something on the Exchange server is stopping the email from being sent. Check the Exchange logs for the dead email. You may need to ask this in the Exchange forums.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog