Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums

none
Email is not going to group email id from Database mail

 > 

    Question

  • Question
    Sign In to Vote
    0
    Sign In to Vote

    I configured a database mail account in 2008 R2. When I tried to send an test email from database mail to group email id it's not working. But the email is being sent to my personal email id.

    Can anyone please help me what's the issue is?

    Friday, August 12, 2011 4:53 PM
    |
    |

All Replies

  • Question
    Sign In to Vote
    0
    Sign In to Vote

    Hi

    For Group Account you have to Give the complete smtp address.. on your outlook goto the properties of your group account and click the e-mail address tab

    User the SMTP: [email protected]

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
    Friday, August 12, 2011 5:05 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

    I'm giving the complete smtp address only. But no luck.

    Just tried sending an email to another group email id. It worked. Couldn't able to figure out what's the issue is.
    Friday, August 12, 2011 5:09 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

     

    check the status of message sent..

    USE msdb ;
GO

-- Show the subject, the time that the mail item row was last
-- modified, and the log information.
-- Join sysmail_faileditems to sysmail_event_log 
-- on the mailitem_id column.
-- In the WHERE clause list items where danw was in the recipients,
-- copy_recipients, or blind_copy_recipients.
-- These are the items that would have been sent
-- to danw.

SELECT items.subject,
  items.last_mod_date
  ,l.description FROM dbo.sysmail_faileditems as items
INNER JOIN dbo.sysmail_event_log AS l
  ON items.mailitem_id = l.mailitem_id
WHERE items.recipients LIKE '%danw%' 
  OR items.copy_recipients LIKE '%danw%' 
  OR items.blind_copy_recipients LIKE '%danw%'
GO
    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
    Friday, August 12, 2011 5:18 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

    No records from the above query. I tried with the following query

    SELECT

    * FROM msdb.dbo.sysmail_allitems  

    WHERE mailitem_id = <the mailitem_id from the previous step> ;

    and the status is showing as Sent.

     But didn't receive the email.

    Friday, August 12, 2011 6:55 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote
    Check on sysmail_event_log
    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
    Friday, August 12, 2011 7:12 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote
    How to check overthere?
    Friday, August 12, 2011 7:43 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

     

    It is an View you can check the message for each mail., Please check the below link for more detail

    http://msdn.microsoft.com/en-us/library/ms178014.aspx

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
    Friday, August 12, 2011 8:01 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

    It's inserting NULL vlaue for mailitem_id as follows. Also it's not showing anything specific for a particular log.

    1 information 2011-08-12 09:42:52.247 DatabaseMail process is started 3492 NULL NULL 2011-08-12 09:42:52.247 xyz
    2 information 2011-08-12 09:52:52.860 DatabaseMail process is shutting down 3492 NULL NULL 2011-08-12 09:52:52.860 xyz
    3 information 2011-08-12 10:33:03.373 DatabaseMail process is started 3380 NULL NULL 2011-08-12 10:33:03.373 xyz

     


    Friday, August 12, 2011 8:22 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

     

    Can you please cross check the permissions rights on MSDB Database.

    Configuration component has two sub components. One is the Database Mail account, which contains information such as the SMTP server login, Email account, Login and password for SMTP mail.

    The Second sub component is Database Mail Profile. Mail profile can be Public, meaning members of DatabaseMailUserRole in MSDB database can send email.)

    you need to create account both in your SQL Server and MSDB database and grant it DatabaseMailUserRole public role before your configuration will work.  So go to the Security section under management in Management Studio and the new security section within MSDB to create the account with the right permissions.  Hope this helps. got this information from one of the asp forum.

     

     

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
    Friday, August 12, 2011 8:55 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

     Hello Nag Pal ,

               I'm getting this same kind of issue . All the profiles are working fine . Its just one group id that's not working but I can send email to that group through oputlook but sp_send_dbmail wont send any emails. 'sysmail_mailitems' and 'sysmail_log' are all showing messages email sent sucessfully. There is no Error messages anywhere but no one is receiving emailo for this one particular group.

    Would appreciate you're sugesstion

    Regards,

    Wednesday, March 14, 2012 2:42 PM
    |
    |
  • Question
    Sign In to Vote
    0
    Sign In to Vote

    Im having the same issue.  Exchange 2010 Universal distribution group with two members does not work but both members work if i use individual email addresses.

    Did you  get any more info?

    -scott

     

    scott

    Tuesday, January 15, 2013 12:51 PM
    |
    |