5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

microsoft-office-365smtpsql-server-2012stored-procedures

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2014-06-10T15:28:48). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender).

This same stored proc is working in production on another server fine. The only change is that this instance of the working stored proc is SQL Server 2008 R2.

Judging from the error this is a SMTP error, am I correct?
All users I am using to send and receive the mail are in the same O365 domain and have {SendAs} access rights and NT Authority\Self Trustees in O365.

I can telnet office 365 over the specified port (587) fine and even stranger is I can send email using the 'Send Test E-Mail' feature in DB Mail fine using the same Office 365 profile that is specified in the stored proc.

Any help would be appreciated.

Screenshot of database mail settings enter image description here

Best Answer

To fix this issue I have installed a SMTP server locally on the same server as the SQL Server instance. I configured DB mail to localhost then set the Office 365 settings in the SMTP server ensuring that TLs encryption and the correct port is stated.

This seemed to fix the issue for me.

Related Solutions

Linux – How to correct Postfix’ ‘Relay Access Denied’

TLS just enables encryption on the smtp session and doesn't directly affect whether or not Postfix will be allowed to relay a message.

The relaying denied message occurs because the smtpd_recipient_restrictions rules was not matched. One of those conditions must be fulfilled to allow the message to go through:

smtpd_recipient_restrictions =
    permit_sasl_authenticated
    check_recipient_access hash:/etc/postfix/filtered_domains
    permit_mynetworks
    reject_unauth_destination

To explain those rules:

permit_sasl_authenticated

permits authenticated senders through SASL. This will be necessary to authenticate users outside of your network which are normally blocked.

check_recipient_access

This will cause postfix to look in /etc/postfix/filtered_domains for rules based on the recipient address. (Judging by the file name on the file name, it is probably just blocking specific domains... Check to see if gmail.com is listed in there?)

permit_mynetworks

This will permit hosts by IP address that match IP ranges specified in $mynetworks. In the main.cf you posted, $mynetworks was set to 127.0.0.1, so it will only relay emails generated by the server itself.

Based on that configuration, your mail client will need to use SMTP Authentication before being allowed to relay messages. I'm not sure what database SASL is using. That is specified in /usr/lib/sasl2/smtpd.conf Presumably it also uses the same database as your virtual mailboxes, so you should be able enable SMTP authentication in your mail client and be all set.

Smtp server cannot send mail to exchange server

A couple reasons why this happens that I've seen

You're authenticating with an account but using a return address that the account does not have permissions to send as
You're sending anonymously and the server does not accept anonymous mail

If it is supposed to accept anonymous mail as you say, then remove the authentication parameters from the Java mailer.

Related Topic