Showing posts with label final. Show all posts
Showing posts with label final. Show all posts

Tuesday, 14 February 2012

configuring smtp connection on dts in VS2005

I'm trying to send mail through DTS Send Mail Task in the final release of VS 2005 however i'm getting this error "Mailbox unavailable.The server response was:5.7.1 Unable to relay for <email adress>.

I do not have exchange server installed. The smtp adress is correct. So what could be the problem?

I appreciate your help

Thanks

Network issues

Incorrect address

DNS failure

Authentication failure

etc...

The list of things that it COULD be are endless. Presumably you think that the problem exists somewhere in SSIS. Have you removed SSIS from the equation and see if it works then?

There isn't really enough information in your post to diagnise what the problem may be.

-Jamie

|||Christina,
The error message you are receiving indicates that the mail server you are trying to send mail through does not allow relaying. This is the usual setup for mail servers to cut down on spammers sending email through legitimate mail servers.
I would contact the administrator of the mail server you are trying to attach to and see if he can setup relaying for your SSIS box or email account.
Larry

|||

has anything changed in the configuration of the ssis send mail task? because in the beta version (before i moved to the final release) it was sending normally without any errors.

i can ask the smtp provider to allow relaying but that would be risky as you said.

thanks and happy new year

|||

i checked with the mail server administrator and relaying from the email address i'm using is allowed. so it's not an issue of relaying.

i also tested sending a test email from command prompt using smtp commands and it sent the mail normally. however from sql i still get the relaying error.

any clue?

thanks

|||

problem is solved. i used a different smtp server and unchecked the "use windows authentication" in the smtp connection manager. i thought it wouldn't matter since i didnt have exchange server. but it seems to have counted.

thanks to all

Christina