SS 2005 Standard 64bit
I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:
1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with
"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."
I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.
2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 firstname.lastname@example.org: Sender address rejected: Access denied)."
You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.
But for starters, try this link: