November 24, 2014 at 3:23 am
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.
November 24, 2014 at 3:50 am
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...
November 24, 2014 at 3:57 am
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]
November 24, 2014 at 4:01 am
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
November 24, 2014 at 4:18 am
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
November 24, 2014 at 4:24 am
I am using the full email address, like abc@gmail.com
November 24, 2014 at 4:27 am
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?
November 27, 2014 at 4:12 am
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.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply