I had an issue setting up Database Mail today: I copied the details from a server that had Database Mail setup and running successfully. After spending an age confirming that the database was set up correctly, I queried the sysmail_event_log table to get the full error:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-08-11T17:20:13). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for firstname.lastname@example.org). )
Although it looks like that there is an issue with the account that we’re trying to send the message to, this is not actually the case: The Exchange Server requires a new Receiver Connector to be created so that the Exchange server can relay messages from the server. A 5.7.1 error usually indicates that there are issues with relaying through the Exchange server because the IP of the SQL Server box is not configured for SMTP relay. You need to contact your Exchange Admin to get a receive connector setup.