Not able to send alert email to a group mail account using database mail

  • I have a problem while setting up alerts using database mail feature.

    I am able to send emails to an individual id like myname@hotmail.com

    But I am not able to send the same email to a group email name used by my team like groupname@hotmail.com

    Is there any reason for this and is there a way to correct this

    Please suggest

    M&M

  • You may need restart sqlagent to activate the first alert !

    for the rest: It does not know a individual address from a group address

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Yes I did. The alerts are working fine only for individual ids

    But I surprised it doesn't work for group email.

    M&M

  • is it your dbmail failing (error info ?)

    or is it your mailserver holding back the mails because of some anti spam measures ?

    Check with your mail admins.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • is it a Email Group name like "All Company"?

    or an email list like "sqldba@company.com" that actually consists of multiple emails

    There shouldn't be a difference between Individual@company.com vs Group@company.com as far as Database Mail is concerned

    It simply relays the message to the SMTP server, and that's considered a success

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • It is an email list like "sqldba@company.com" that actually consists of multiple emails.

    Do you think the SMTP server might be the reason for this error.

    It is just not able to identify this group email.

    M&M

  • If you can afford to send a test email to "sqldba@company.com" in Outlook or whatever email program, do that. That's the best way

    If that works, SQL Database Mail should work (did Database Mail show success?)

    If not, talk to the IT Administrator?

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • You are right. I contacted the IT administrator, and he was able to give me the right SMTP server.

    That worked.

    Thanks for the help.

    M&M

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply