January 22, 2010 at 6:17 am
Hi,
While sending mail using Send mail task I am getting following error.
[Send Mail Task] Error: An error occurred with the following error message: "Transaction failed. The server response was: <abcdf@test.com>: Relay access denied".
I am able to send mail using Database mail tool, means settings are working fine but may be I am missing something in SSIS.
Please let me know if I am missing something.
Thanks,
January 22, 2010 at 7:24 am
Hi,
Are you using the same email address at both locations? That might be a reason (if not).
-- Erik http://blog.rollback.hu
January 22, 2010 at 8:11 am
I'm not sure what your mail server is, but Exchange has a property you can set to allow for relaying.
January 23, 2010 at 1:22 am
Is there any other settings required to be done in exchange server, since using sp_send_dbmail I am able to send messages...
I tried both options (Same/different To & Recipeint list)
Thanks,
January 25, 2010 at 10:05 am
Are you able to able to send out email locally within your network? The error message you pasted had a reference to abcdf@test.com. I still believe it's a mail server issue. Is it possible to check with your mail server admin to see how they handle relaying of mail. Most companies will usually lock this down to prevent spam thereby forcing you to use some sort of authentication before the mail server will relay your mail.
January 26, 2010 at 10:47 pm
I am able to send mail using other services of SQL Server(Using DB Mail), but using SSIS-Send Mail task I am not able to do so.
Thanks,
January 26, 2010 at 10:57 pm
JD is probably right. Send Mail task looks depends on Mail relay. Database mail probably doesnt depend on mail relay. Thats all I can think of.
Talk to your exchange administrator and he/she should know what to do.
January 27, 2010 at 10:25 am
Relaying can be controlled by IP address. Are both of your processes using the same IP?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply