problem with Database mail:All mails have Unsent status

Question

We have setup Database Mail on SQL SERVER 2008 R2 (RTM).Since yesterday,Database Mail stopped working. I did the following checking and seems everything is ok

1-Database Mail is enabled

2-mails are being sent by sysadmin account

3- Database Mail is started

4-I checked and mail server is accessible from SQL host(using ping ,telnet ServerName 25)

When I checked the msdb.dbo.sysmail_Allitems,All emails had unsent status.

I would appreciate if someone help me on this.

Thanks

---

A.G

Answer 1

Hi Mourmansk,

After you configured the database Mail, please right click the “database mail” and click “send test e-mail” if it is not be sent, please click “view database mail log”, post the error message you received.

A status of unsent indicates that the Database Mail external program has not yet processed the e-mail message. The Database Mail external program may have fallen behind in processing messages; the rate at which the external program processes messages depends on network conditions, the retry time-out, the volume of messages, and the capacity of the SMTP server. If the problem persists, consider using more than one profile to distribute messages among more than one SMTP server.

For more information about troubleshooting unsent issue, please see:
http://msdn.microsoft.com/en-us/library/ms190630(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 2

Check the Database Mail logs & sahre the error message your are getting.

---

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