June 14, 2011 at 5:20 pm
I have SQL 2005 cluster (active/active/active) in which the Database mail only works on one of the nodes. The error msg I get on the other 2 is: "Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1. Exception Message: Could not connect to mail server. (No such host is known).
)"
Any Ideas?
Thanks in advance,
D
June 15, 2011 at 3:38 am
See KBA http://support.microsoft.com/kb/968834 for more information.
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
June 15, 2011 at 10:19 am
I'm not seeing how this KBA helps since I'm not getting a timeout issue. The error msg seems to be more related to the e-mail server denying access. At least that's my guess. Am I missing something in that article?
June 15, 2011 at 1:41 pm
It turned out to be a name resolution error with the smtp server. Fixed by changing to a fully qualified name for the smtp server. It doesn't explain why one node worked without the change and not the other 2, but it's fixed.
June 15, 2011 at 3:52 pm
I bet you that the DNS settings on one node do not match the other.. I've seen that cause what you are talking about. I've also seen organizations who have a firewall between the database servers and the mail server and if BOTH your machines weren't on the whitelist you could get inconsistent results from each node.
CEWII
June 16, 2011 at 10:34 am
Interesting. I'll have to check the config and see. Thanks for the info
June 16, 2011 at 10:38 am
In companies with a number of DNS domains I have seen this OFTEN, when they are setup they include 1 or 2 but there are say 5 total.
CEWII
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply