Database mail alert fails for group account

  • This is a new SQL Server 2008 R2 standard edition 64 bit environment. I've been down this path before. I'm attempting to configure database mail to send an alert to a group account. Before testing the alert I wanted to test sending an email to a group account. There is no issue sending an email to an single individual account. Bouncing the SQL Server Agent did not help.

    Viewing the database mail log shows the databasemail process is started. All email accounts have the full domain name reference. SMTP Basic authentication is being used. I've matched configuation setting used on other servers.

    Any ideas on what to review? URLs / comments are encouraged - thanks.

  • check this sql statement.

    select * from sysmail_mailitems

    go

    select * from sysmail_log

    go

    select * from sysmail_sentitems

    go

    select * from sysmail_allitems

    go

    select * from sysmail_event_log

    if there isn't any problem, maybe there is problem with group email configuration.

    Look first what informations will give you these statement

  • On some occasions I've encountered mail problems. Most of these times some errors were reported in the SQL Agent log.

    The solution for this issue was to change from database-mail to SQLmail and back to database-mail again in the "Alert system" section of the SQL Agent properties. You need to apply each change with [OK] and sometimes restart the SQL Agent to get the desired effect.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • group accounts via SMTP have to be explicitly opened by your exchange administrator, i believe; it's to avoid things like spammers sending to staff@microsoft.com anf getting viagra information to 80K employees

    we usually create an alias for a group ; so what you think might be Dev@mydomain.com has an smtp of dev8789961@mydomain.com in order to be used by anything outside of exchange connections.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks Guys,

    Sometimes you miss the obvious, I did. Everything was configured properly. Try my personal account and test mail works. Try the group account and it fails. Reviewing the group account showed me something, it was not a distribution list. When I realized that, I wanted to jump out the window. I work on the first floor.

    Thank you all for responding...

Viewing 5 posts - 1 through 4 (of 4 total)

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