Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3338
  • Last Modified:

Database Mail Can't Send Externally Through Exchange 2010

This is the logged error shown in SQL when I try to send a test message from Database Mail:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-04-26T19:57:59). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay).

This is the information from the receive connector I setup on the Exchange server:

Receive Connector:  SQL Connector
FQDN:  *servername*.domain.pvt
Use these local IP addresses:  "all available IPv4" Port 25
Receive mail from remote servers:  *IP address of SQL server
Authentication: Everything is checked except for "externally secured"
Permission Groups:  Everything is checked

Anything glaringly obvious I'm missing here?
Acosta Technology Services
Acosta Technology Services
  • 2
1 Solution
check your from address and make sure it is from @yourdomain.com
Acosta Technology ServicesAuthor Commented:
In SQL the E-mail Address and Reply-To address are both from our domain (resident on the Exchange server); the @username and @password fields are "NULL".
Sounds like either authentication issues or you need to setup a secure relay connector for that server

When I have had to deal with it  - relaying notifications from a SQL server, I was brought in when it wasnt working. I removed and started over using the maintenance wizard in SQL and it fixed it. I tried setting up the relay connector first so I have done the process but it wasnt necessary - i removed it

I dont know that your relaying sql notifications i am just giving you my experience with it.

heres an article on setting up the connector
Acosta Technology ServicesAuthor Commented:
The link you sent was perfect, I had to modify the permissions according to the article (in Exchange; SQL was good) and then the test mail immediately came through.

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now