Database Mail stopped working

Question

Post reply

Database Mail stopped working

efeesh

Valued Member

Points: 72
More actions
October 30, 2013 at 4:00 am

#278647

Hi
We have an installation of SQL Server 2008 R2 using a Exchange 2007 mail server for database mail.
The database mail just stopped working yesterday
we have tried stopping and starting the service, recreating the profile, recreating the accounts, checked smtp relay.
The queue says Inactive and this does not want to change?
Please help

Viewing 5 posts - 1 through 4 (of 4 total)

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Execute following command:

select * from msdb..sysmail_faileditems

This table contain single row for each failed items.

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Find another link in addition to the above. This is perfect way to do step by step troubleshoot of database mail:

http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

dan-572483 SSCoach Points: 15870 More actions · Answer 3

I've seen errors like this when there are anti-virus or anti-spam settings in place on the local server or email server. Ask your OS, AV and email server people if security settings have changed.

efeesh Valued Member Points: 72 More actions · Answer 4

Thank you for your replies. It turned out to be a Service Broker issue