July 13, 2010 at 10:30 am
After confirming all settings, and testing it seems the send mail task simply will not allow a group account with members. I'm trying to confirm this is a limitation and all research is not really saying anything about this topic. Also did not see any notes here after many searches.
Example; SSIS control flow takes various steps and when all complete successfully a send mail task informs users job is done and data is available for use. The send mail task has the SMTP connection, the from-account, subject, and body text. When the to-account is a single name (or list with ; between) the mail works fine. When the to-account is an smtp entry for a group account with members the mail does not work. Both tests in SSIS show no errors.
DBMAIL test mail also works for a single account, list with ; between but nothing for a group account.
Can anybody confirm this please?
July 13, 2010 at 12:37 pm
please use fully qualified name , means, use group name with domain too, like ABCGRP@domain.com instead ABCGRP.
We are using so many group emails , no issues, if you are using fully qualified address then some thing else is the problem.
July 13, 2010 at 12:54 pm
Thank you for that idea.
The individual accounts are (for example using mine) paul.morgan@mycompany.com. The group account is like projectteam@mycompany.com Also I've confirmed the group email account has this as one of the smtp entries.
July 22, 2010 at 7:02 am
We have confirmed that using DBMAIL send mail task for testing that mail works for the sending account to a name, or a list of names. The group account has a direct smtp entry like projecteam@mycompany.com. Mail sent to that smtp account also works. So DBMAIL send test mail is working under all cases other than an smtp address that is a group account. Many sources confirm this should work. Any clues on where to look for the block would be appreciated. We are at SP2; perhaps something fixed by Microsoft after that? We are really stumped over here! Thanks.
July 22, 2010 at 1:24 pm
SOLUTION FOUND: I pressed our exchange admin to check the smtp authentication settings on this particular sender. It was set to force authentication; but the smtp mail is only relayed. After turning that off the group account mail accepts and delivers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply