• pat-261672 (11/4/2011)


    Hi,

    i have setup the database mail fine and can send database mail. But from SSRS subcription on SQL 2008 sp1. but it sends out failing messge:

    Failure sending mail: The server rejected the sender address. The server response was: 550 5.7.1 Client does not have permissions to send as this sender Mail will not be resent.

    i have proper email address as well as have set following in config file:

    SMTPAuthenticate to 2.

    Set SendEmailToUserAlias to False.

    Set DefaultHostName to the Domain Name System (DNS) name or IP address of the SMTP server or forwarder.

    <SendUsing>2</SendUsing>

    please help urgent!!

    Thanks

    The error is saying "you tried to send an email through me, but You are not authorized to send as the person you told me is the sender". How is database mail set to authenticate? You need to dicuss this with the adminsitrator of the mail server you are sending through and the account you are authenticating as needs to be allowed to send as the sender you are specifying in the configuration.