Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBMail fails to send email to Group Account Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 10:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 8:50 AM
Points: 66, Visits: 592
We've installed database mail for two SQL Server 2008 instances. We have job notifications failures and database alerts going out to a group email account. Installation is fine.

We now installed database mail on a few more 2008 instances - test emails will not send the same group account. Individual accounts test fine. I tried stopping and starting dbmail - no difference. What am I missing?

When I test send to the group account via outlook - there are no issues. The group
account is not the issue.

Mail Log: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2013-03-14T11:04:21).
Exception Message: Cannot send mails to mail server. (A recipient must be specified.).)

It almost sounds that DBMail install failed except that it will send to indiviual user emails. Does the group account need permission for each SQL Server instance?

Any comments / URLs would be appreciated...thanks.
Post #1431124
Posted Thursday, March 14, 2013 11:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:34 PM
Points: 12,903, Visits: 32,144
sp_send_dbmail can only send to an address that conforms to an actual email address format, ie mygroup@mydomain.com; you cannot send to just "MyGroup"

a group account is handled special by an exchange server; it is optional to expose the group to external resources outside of the domain, so you have to get the mail admin to map mygroup@mydomain.com; to your group; when the exchange mail server receives the email, it will process it and duplicate the email out to each of the real members of the group.
get with your Exchange admin to create that or to make sure you know the mapped email for it.

it's optional specifically because it would be too easy to get spam from outside world with a staff@mycompany.com going out to everyone, for example.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1431171
Posted Thursday, March 14, 2013 1:50 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 8:50 AM
Points: 66, Visits: 592
Lowell,
Thanks for responding. I should have clarified that in my posting - the email account has the full domain. And the mapping you mentioned was done. I did some more digging and at least for now I have an intermin solution.

I changed the SMTP authentication from anonymous to Basic, entered the credentials for the account, bounced the SQL agent and sent a test email to the group account. It worked. I do need to speak with our exchange administrator because anonymous does work for one of our 2008 instances.

You were spot on with your comments about the group account requirements.

Thank you for responding.
Post #1431233
Posted Thursday, March 14, 2013 1:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:34 PM
Points: 12,903, Visits: 32,144
jralston88 (3/14/2013)
Lowell,
Thanks for responding. I should have clarified that in my posting - the email account has the full domain. And the mapping you mentioned was done. I did some more digging and at least for now I have an intermin solution.

I changed the SMTP authentication from anonymous to Basic, entered the credentials for the account, bounced the SQL agent and sent a test email to the group account. It worked. I do need to speak with our exchange administrator because anonymous does work for one of our 2008 instances.

You were spot on with your comments about the group account requirements.

Thank you for responding.


ahh yes anonymous authentication is usually only allowed for machines on the same LAN as the exchange server, or machines/ip addresses that have been explicitly put on a white list of allowed servers; ;
like you identified, that should be a quick fix for your mail admin. I missed that when i read your post, sorry, i would have mentioned that possibility too.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1431238
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse