DB Mail is not sending mail

Question

Post reply

DB Mail is not sending mail

Knowledge Hunter

SSCrazy

Points: 2287
More actions
November 24, 2014 at 3:23 am

#301437

I have configured an SMTP server and a DB mail profile and account in another server.
Using Telnet command I can ping the SMTP server.
When I am sending test mail from the DB mail, the log is showing susucessfull tart and shut down of the process. But no mail is delivered.
There is no error in the log.
The state is showing 'RECEIVES_OCCURRING'.
Please assist.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

arrjay Hall of Fame Points: 3455 More actions · Answer 1

I know this may sound a little primitive but have you checked your junk mail, as this always seems to happen with me! 🙂

--------------------------------------------

Laughing in the face of contention...

sqlmunkee SSCommitted Points: 1949 More actions · Answer 2

How is your 'recipient' e-mail address supplied ? DB Mail requires a full address like 'My.Name@Company.com', not 'My Name'. It doesn't do address book lookups, just simple SMTP.

[font="Courier New"]sqlmunkee[/font]
[font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

HanShi SSC-Dedicated Points: 33507 More actions · Answer 3

Execute the code below and see what message is stated in the 'description' column.

SELECT

sysmail_allitems.mailitem_id

, sent_status

, recipients

, subject, body

, send_request_date

, send_request_user

, sent_date

, sysmail_allitems.last_mod_date

, sysmail_event_log.event_type

, sysmail_event_log.description

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN msdb.dbo.sysmail_event_log

ON sysmail_allitems.mailitem_id = sysmail_event_log.mailitem_id

where send_request_date > dateadd(dd, -7, getdate())

--and sent_status = 'failed'

order by

send_request_date desc

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Knowledge Hunter SSCrazy Points: 2287 More actions · Answer 4

The description is all NULL for all the entries.

The message status is showing as sent.

I have already checked the junk mails. It is not there

Knowledge Hunter SSCrazy Points: 2287 More actions · Answer 5

I am using the full email address, like abc@gmail.com

HanShi SSC-Dedicated Points: 33507 More actions · Answer 6

Knowledge Hunter (11/24/2014)
The description is all NULL for all the entries.
The message status is showing as sent.
I have already checked the junk mails. It is not there

Can you access the mailbox from the 'database mail' account? If so, are the messages present in the 'Sent items' folder?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Knowledge Hunter SSCrazy Points: 2287 More actions · Answer 7

The issue is sorted now.

The firewall for the exchange server was not allowing the mails to be delivered.

It is delivering mails to public mails like Yahoo and Gmail.