Email is not going to group email id from Database mail

Question

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?

Answer 1

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: [e-mail]

---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

Answer 2

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.

Answer 3

 

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 ::

Answer 4

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.

Answer 5

Check on sysmail_event_log

---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

Answer 6

How to check overthere?

Answer 7

 

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 ::

Answer 8

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

 

Answer 9

 

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 ::

Answer 10

 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,

Answer 11

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