Database mail alert fails for group account

Question

Post reply

Database mail alert fails for group account

jralston88

SSCommitted

Points: 1931
More actions
February 5, 2014 at 10:44 am

#283279

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.

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

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

SrcName Default port Points: 1440 More actions · Answer 1

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

HanShi SSC-Dedicated Points: 33506 More actions · Answer 2

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’! **

Lowell SSC Guru Points: 323504 More actions · Answer 3

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!

jralston88 SSCommitted Points: 1931 More actions · Answer 4

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