SQL 2012 Database Mail Error 5.7.1

Question

I'm using SQL Server 2012 and trying to setup Database Mail but the error I get every time I try to send a mail is:

Date  7/27/2012 2:34:27 PM
Log  Database Mail (Database Mail Log)

Log ID  73
Process ID  6792
Mail Item ID 29
Last Modified 7/27/2012 2:34:27 PM
Last Modified By sa

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2012-07-27T14:34:27). 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).
)

I've followed the online MSDN information on how to setup Database Mail and I'm using the same SMTP server and configuration that works on my SQL 2008 system but I want to get it working through my 2012 server.

Tell me what else you'd need to know to help.

Schlieper

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 1

Add the ip address to the SMTP relay, it is the issue when you Physical IP is not having access over SMTP relay.

If its working fine for SLQ 2008 & not for SQL 2012 then may a case that some changes also happen on SMTP relay that is not is your knowledge.

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 2

Hello,

I suppose that you know this issue :

http://blogs.msdn.com/b/psssql/archive/2011/04/21/ms11-028-may-cause-issues-with-sql-exchange-and-powershell.aspx

Have a nice day

PS : i think that the important part of the error message is "Client does not have permissions to send as this sender".

Please, could you have a look at  ?

http://social.msdn.microsoft.com/Search/en-US?query=Client%20does%20not%20have%20permissions%20to%20send%20as%20this%20sender&ac=8

and especially :

http://social.msdn.microsoft.com/Forums/eu/tfssetup/thread/1cd6ba54-9f1b-4bf3-8b45-c7e661066aa8

But i am far to be a specialist of Database Mail ( even if i am using SMO to send e-mails at the end of several tasks as SQL Server backups/restores )

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.