none
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2013-04-30T16:36:52). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Client does not

    Question


  • Interesting db mail issue. If i click send test mail from sql mgmt studio, it works fine, but when i execute a SP to send a mail, it fails. One thing I noticed is that the "LastModified" column in the mail log shows the domain account when a test mail was sent from mgmt studio, but show "sa" when the SP was used to send mail. 

    This is from SQL 2012, did not see this in sql 2008, looks like 2008 always used the service account.  any ideas ?

    Get this error:

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2013-04-30T16:36:52). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Client does not

    Thanks.


    Ranga

    Tuesday, April 30, 2013 9:02 PM

Answers

All replies

  • That message came from the SMTP server, not DBMail.  This is not a DBMail issue.

    The message indicates the recipient email address does not exist.  Check your email address.

    Tuesday, April 30, 2013 9:08 PM
  • Hi Ranga,

    I also use SQL Server 2012. I send a test email through SQL Server Management and the last modified By “sa”.

    If you used stored procedure to send a test email. Please use the command below:

    EXEC msdb.dbo.sp_send_dbmail
        @profile_name = 'Adventure Works Administrator',
        @recipients = 'danw@Adventure-Works.com',
        @body = 'The stored procedure finished successfully.',
        @subject = 'Automated Success Message' ;

    I can both send test email through SQL Server Management Studio and SP. Make sure you have the right profile. Since you could send test mail via SQL Server Management Studio, please try again to send it via SP.

    Thanks.

    If you have any feedback on our support, please click here.


    Maggie Luo
    TechNet Community Support

    Wednesday, May 01, 2013 2:06 AM
  • As Tom mentioned, these are errors from your SMTP server, and you need to talk to your SMTP people about this. For instance, googling for below gave me several hits:

    SMTP 5.7.1


    Tibor Karaszi, SQL Server MVP | web | blog

    Wednesday, May 01, 2013 9:16 AM
  • Ok, issue resolved. I used another smtp server that was used with sql 2008 in my sql 2012 server and everything started working fine, so, yes, it is is a smtp server issue. 

    Ranga

    Wednesday, May 01, 2013 3:31 PM