Mail queued, not delivered

Question

Mail queued, not delivered

Aspet Golestanian Namagerdi

SSCarpal Tunnel

Points: 4444
More actions
November 28, 2012 at 5:44 pm

#267509

Hi Everyone,
We have SQL SERVER 2008 R2,that it's Database Mail has stopped working.When I checked the sysmail_event_log,I found the following row:"The mail queue was started by login [UserName]." and there is not any other row."Sysmail_faileditems" shows all the test emails that I have tried have failed(They have status : failed).I checked the Service Broker is enabled (by running query Select is_broker_enabled from sys.databases where name ='msdb' )."View Database mail log" does not show any error.
Is there any other thing that I have to check?
Thanks
Aspet

Viewing 13 posts - 1 through 12 (of 12 total)

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

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 1

How have you configured your default mail profile? Verify that you have the proper server name, port number, and most importantly for these types of issues...what is your needed method of SMTP authentication? In most cases (if using exchange or a similar email server), you should choose "Anonymous authentication"

Please post back the configuration from your default mail profile for Database Mail. Thanks!

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 2

It used to work and all of sudden stoped working.I also chnaged the SMTP authentication to "Anonoumous authentication" and didnt help.

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 3

Anything unusual showing up in the windows event viewer under application or system? I've had an issue in the last where a dependent library (dell) bombed and had to restart the entire server in order to correct the issue (a last resort of course)

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 4

Aspet Golestanian Namagerdi

SSCarpal Tunnel

Points: 4444

November 28, 2012 at 6:35 pm

#1563532

No,There is not any specific event in Windows log.

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 5

Sorry to ask a redundant question but can you confirm that NO mail has been sent? Or has some gone out? Do you know if anything has changed with your exchange server settings abity to relay mail? Again, asking the obvious, have you tried restarting it? exec msdb..sysmail_stop_sp

exec msdb..sysmail_start_sp

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 6

No email has been sent and yes I have restarted multiple times.

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 7

Can you restart the server? In all honesty if you've not changed anything on the SQL Server (or no one else has either) and a full restart doesn't correct the issue, I would lean all the way towards the Mail Server being the issue.

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 8

This is production server and I can not restart it.Will restarting SQL SERER Agent help?

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 9

I don't think so, but you can try. In my case, I had to restart the entire server

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Lowell SSC Guru Points: 323506 More actions · Answer 10

for the individual emails, do they all have the same error message?

maybe something changed outside of your control, like a firewall blocking port 25 traffic, a DNS error or something else? password change of the account used for sending email?

those are just guesses, but the actual error should help:

SELECT

err.[description],

fail.*

FROM [msdb].[dbo].[sysmail_event_log] err

inner join [msdb].[dbo].[sysmail_faileditems] fail

ON err.mailitem_id = fail.mailitem_id

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 11

When you say the mail is in queue but has not been received, means it has left the server, but is blocked at the receiving end.

Check if the firewall team has stopped the port 25 or your company has stopped incoming port.

Try telnet <ip> 25. If works fine, then try sending a test mail to your personal email (gmail, yahoo etc) and see if it works else what is the error you are getting.

Pavan.

Aspet Golestanian Namagerdi SSCarpal Tunnel Points: 4444 More actions · Answer 12

There is no row in sysmail_faileditems, and the status of all email in sysmail_allitems is unsent.