July 2, 2011 at 7:33 pm
I have configured DB mail to send job failure mails. For a week or so, we havent received any mails even though there were failures. When chked the log, it had the below error logged.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2. Exception Message: Cannot send mails to mail server. (Failure sending mail.).
The same smtp is working in another server (both sql is in same location and network).
Error "Failure sending mail" is strange. Any thoughts on how to resove this?
July 3, 2011 at 9:30 am
Check with the team that manages the SMTP server - see if they are using any filtering to allow only defined servers to send mail. Also, validate any credentials you need to use to login to the SMTP server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 3, 2011 at 12:06 pm
Jeffrey Williams-493691 (7/3/2011)
Check with the team that manages the SMTP server - see if they are using any filtering to allow only defined servers to send mail. Also, validate any credentials you need to use to login to the SMTP server.
IMO Jeffery is spot on !
Other information you should prepare for:
- what's your sqlserver ipaddress.
- what smtp address are you using in your dbmail config
- what port number are you supplying
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 5, 2011 at 6:35 pm
answers:
1. Our SMTP server does not require authentication
2. Using Port 25 and it is open
3. SQL server added to the SMTP
It was working fine till recently. And what is strange is that one of the SQL server mail is working fine with the same settings. This issue is for a bunch of other SQL servers.
July 6, 2011 at 12:19 am
did you change service accounts passwords ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 6, 2011 at 8:45 am
Another culprit may be your antivirus software. In our environment, we use McAfee and we have to make an AV exception on the SQL servers that use Database Mail to allow the executable (sqlserver.exe I think.. it's been a while) to send email.
July 6, 2011 at 8:59 am
Have you configured the Mail Session on the Agent? You'll also need to restart the Agent in order for the changes to take effect.
July 6, 2011 at 9:23 am
A problem I have had when configuring DBMail is not setting a default mail profile in the SQL Server Agent(> Properties > Alert System > Enable Mail Profile)
Bodsda
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply