mirde
asked on
SQL Server Sendmail Task failing with "User unknown"
Trying to send to an individual user using the SSIS Sendmail task works OK.
Trying to send to a distribution group fails with the following:
Any idea?
I have tried different distribution groups, same effect. Strange that it works for individual users, but not distribution groups?
Trying to send to a distribution group fails with the following:
SSIS package "Package2.dtsx" starting.
[b]Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.1.1 User unknown".[/b]
Task failed: Send Mail Task
Warning: 0x80019002 at Package2: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package2.dtsx" finished: Failure.
Any idea?
I have tried different distribution groups, same effect. Strange that it works for individual users, but not distribution groups?
ASKER
I verified that part as well, I am giving it the full SMTP email (domedist@domain.com), and that is where it is failing. The Exchange server should be able to take that and dsitribute to the members of "somedist@domain.com",
I know how Outlook works, and I am definitely not just entering in the name and expecting it to be resolve to an email which is why I am stumped. It works fine when sending from Outlook as well.
What throws me off is that, users@domain.com work, but distributions@domain.com do not seem to be.
Maybe I am missing something, going to try a few other DLs that have been here for a long time.
I know how Outlook works, and I am definitely not just entering in the name and expecting it to be resolve to an email which is why I am stumped. It works fine when sending from Outlook as well.
What throws me off is that, users@domain.com work, but distributions@domain.com do not seem to be.
Maybe I am missing something, going to try a few other DLs that have been here for a long time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Our Exchange Administrator figured out the issue and adjusted back-end settings on the mail server; flow now works.
Check to get the address for your group and email it to that address - that should do what you need.