locked
sp_send_mail cannot send e-mail to alias account RRS feed

  • Question

  • I have a big problem after Migrate SQL Server 2000 to SQL Server 2008 R2

     

    in SQL Mail Section

     

    i was enable Database Mail XPs in sp_configure

    and  test send e-mail with sp_send_mail to user account (username@domainname.com) 

    user can receive mail but i test send e-mail to alias account (uname) i cannot receive mail from sql server

    Question ?

    Can i used sp_send_mail send e-mail to alias account ?

    How to configure database mail to send mail to alias account ?

    thank for help

    tbsql

     

    Wednesday, September 29, 2010 5:47 PM

Answers

  • Hi,

    I think we could not use the store procedure sp_send_dbmail send email to an alias account, because the parameter @recipient must be the normal format of email address like username@domainname.com.

    But this idea is excellent and you could connect Microsoft at https://connect.microsoft.com/ to feedback, your feedback will promote our product and our service.

    Please feel free to ask if you have any questions.

    Thanks,
    Weilin Qiao

     

    • Marked as answer by Jerry Nee Monday, October 11, 2010 2:46 AM
    Friday, October 1, 2010 11:22 AM

All replies

  • uname is not an alias, an alias is something like uname@domainname.com

    aliases always comes in the form of email address. Before sending from sql server troubleshoot first using standard mail client


    With kind regards
    Krystian Zieja
    http://www.projectnenvision.com
    Follow me on twitter
    My Blog
    Wednesday, September 29, 2010 6:08 PM
  • You could do that if you are running Exchange as your mail server and teh account is in your Active Directory - eg send an email to uname, exchange will then see it is not a valid email and look it up. If they have an account on your exchange server then it will email them. If not the mail will fail
    http://lqqsql.wordpress.com
    Friday, October 1, 2010 11:02 AM
  • Hi,

    I think we could not use the store procedure sp_send_dbmail send email to an alias account, because the parameter @recipient must be the normal format of email address like username@domainname.com.

    But this idea is excellent and you could connect Microsoft at https://connect.microsoft.com/ to feedback, your feedback will promote our product and our service.

    Please feel free to ask if you have any questions.

    Thanks,
    Weilin Qiao

     

    • Marked as answer by Jerry Nee Monday, October 11, 2010 2:46 AM
    Friday, October 1, 2010 11:22 AM