SQL Server Database Mail failing to send emails with error Sender address rejected: Access denied

Question

The environment is a 2 node 2008 SQL Cluster. The first node was running fine but after failover to the second node Database Mail no longer can send emails. I am using Basic authentication.

The full error message is: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 0 (2012年04月10日T15:26:56). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 : Sender address rejected: Access denied). )

This appears to be a SMTP issue but I have validated it is not by writing a vbscript with CDO using the same credentials as Database Mail configuration and the emails go through fine on the same box.

I have recreated the Database Mail account on the second node just to make sure the credentials are correct but that didn't fix the problem.

Does anyone know how to get this working again?

• Thomas Stringer: Sounds like SMTP credentials have changed. Have you verified this?
• user8014: Yes, I verified the credentials have not changed.

Answer 1

Perhaps the IP of your second node is not allowed to relay.

• user8014: I was thinking the same thing at first but the smtp server I am connecting to is at Rackspace and they don't have any IP limitations that I know of. Also doesn't the fact that I can send email with CDO from the second node prove that the problem is not with the SMTP server?
• Eric Higgins: Can you confirm w your Exchange admin that both nodes' public IPs are allowed to relay? Can you fail back to the other node and see if it still works there?
• user8014: Creating maintenance window tonight to patch cluster and do failover.
• Eric Higgins: Great, let us know how it goes.
• user8014: After patching and failover testing node 1 works and node 2 does not. Our email is provided by Rackspace (Pop3, no exchange) so I am connecting to their smtp server directly in my config. I used telnet to test smtp auth and sending message and it works from both nodes. It seems like node 2 is not passing the credentials properly.