database mail problem

Question

Post reply

database mail problem

ckanow

SSC Enthusiast

Points: 160
More actions
November 18, 2010 at 7:43 am

#388260

I am on 2008 R2, and I can not get database mail to work. The account used to sent the test messages is a network domain admin account and has been added to databasemailuserrole on the msdb. sysmail_allitems logs the test mail msgs as sent, so does the smtp server log, however, none of the emails got delivered. I have sent an email from the account using another mail client with the same subject, and it did get delivered, so can't be a spam filter gone wrong somewhere. I have absolutely no idea what could be going wrong or what else to try, am I missing something glaringly obvious or has anybody got any ideas?

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

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

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 1

go the error log and select database mail....let us know what the error is

ckanow SSC Enthusiast Points: 160 More actions · Answer 2

there is no error on the log, it just informs me that the database mail process started and then that it is shutting down again

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 3

sound like it is getting queued as well?

select * from

dbo.sysmail_mailitems

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 4

after rereading your original post and it is starting and stopping it sounds like the mail client is set up correctly

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 5

Yes that is what the mail does it starts then when no emails to fire shutdowns when a mail is sent it will restart up. Nothing to worry about.

ckanow SSC Enthusiast Points: 160 More actions · Answer 6

I know, there's nothing wrong with my SQl. I have tracked down the problem. In the smtp server message queues, I had assumed that because my mail wasn't sitting in any of them that it means they were sent, but using message tracking, I found out that the emails don't get passed on from the categoriser. So I have passed this issue on to he who-presides-over-the-exchange server. But thank you for your help.