configuring smtp connection on dts in VS2005

configuring smtp connection on dts in VS2005

• Daveskis

  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

  
  

• Jonhwang

  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

   

  
  
  

• Brandon R

  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

  
  

• Saravana kumar

  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
  
  
  
  

• shock56

   

  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

  
  
• configuring smtp connection on dts in VS2005