Database Mail not sending Emails
-
Some Users are receiving Emails and some not, below is the Error message from event log. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-11-11T06:09:35). Exception Message: Cannot send mails to mail server. (The operation has timed out.)." What could be the problem? How to sort this?
-
Some Users are receiving Emails and some not, below is the Error message from event log. "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2014-11-11T06:09:35). Exception Message: Cannot send mails to mail server. (The operation has timed out.)." What could be the problem? How to sort this?
Your SQL box timed out sending the mail to your mail server. You need to increase the timeout. Depending on which version of SQL you have, you might need to install a Cumulative Update in order to change the timeout: https://support.microsoft.com/kb/968834[^] You should then be able to use the
sysmail_update_account_spstored procedure[^] to increase the timeout.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
