cannot receive the db mail

Question

I have profile set in my sql server. Test connection is succesful, why can't I received the mail?

Answer 1

check the database logs for more details. May be you are missing smtp relay access for sql server physical IP.

---

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

Answer 2

Hi Li,

Please first check the status of e-mail message sent with database mail.

Use:

SELECT *
FROM sysmail_mailitems
GO
SELECT *
FROM sysmail_log
GO

You will see the description for the failed sent. You can troubleshoot the problem by searching the description.

Here are some references about troubleshooting the database mail:

http://msdn.microsoft.com/en-us/library/ms187540(v=sql.105).aspx

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/24/configuring-database-mail-failing-with-error-no-credential-change-is-not-a-parameter-for-procedure-sysmail-update-account-sp-microsoft-sql-server-error-8145.aspx

http://msdn.microsoft.com/en-us/library/ms190630(v=sql.105).aspx

---

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

Answer 3

Thanks very much Iric, I found the problem by using your code.

Solved by this link http://social.technet.microsoft.com/Forums/zh-CN/sqltools/thread/840375d8-be5e-4104-a43f-85c387c6ce69