Last post Feb 10, 2017 05:51 AM by Chris Zhao
Feb 09, 2017 11:31 AM|neellotus07|LINK
I configured "Database Mail" through Sql Management Studio at SQL - 2005 to send emails But when i am trying to send test mail through "Database Mail" mail is not receiving at corresponding email address so i troubleshoot and found unsent status in sysmail_allitems
for all mail and i checked my mail server is okay.
And i also tried login through SA and local domain user but mail status is unsent. I also assigned "DatabaseMailUserRolerole" role to local domain user but status is same. And i also run below queries to check where i am doing wrong but not getting solution
so pls help me to solve same issue:-
select * from msdb.dbo.sysmail_sentitems
select * from msdb.dbo.sysmail_faileditems
result is blank of above two queries
select * from msdb.dbo.sysmail_allitems
above sql query showing unsent status of all emails.
please help me to solve the issue thanxxx..
Feb 09, 2017 01:46 PM|kaushalparik27|LINK
You may use below query to get detail on error description, on what exactly error is being faced in sending by database mail:
USE msdb ;
,l.description FROM dbo.sysmail_faileditems as items
INNER JOIN dbo.sysmail_event_log AS l
ON items.mailitem_id = l.mailitem_id
Feb 09, 2017 03:13 PM|PatriceSc|LINK
https://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx (Troubleshooting Database Mails: General steps) to see if you can spot something.
Start perhaps directly with EXEC msdb.dbo.sysmail_help_status_sp?
Feb 10, 2017 05:51 AM|Chris Zhao|LINK
From Troubleshooting Database Mail: Mail queued, not delivered
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.