February 5, 2014 at 10:44 am
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.
February 6, 2014 at 5:15 am
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
February 6, 2014 at 6:02 am
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.
February 6, 2014 at 6:42 am
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
February 11, 2014 at 7:01 am
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