locked
SMTP connection manager error RRS feed

  • Question

  • Hi I am getting an error with my SMTP connection manager.

    The progress message when the package is executed is,

    [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.  System.Net.WebException: Unable to connect to the remote server  System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 198.1.1.1

    I am definitely using the correct SMPT address. Is there any other setting which I have to configure? 


    Mr Shaw

    Thursday, November 20, 2014 4:55 PM

Answers

All replies

  • Can you check if exchange server setting is correct?

    Please Mark This As Answer if it solved your issue
    Please Mark This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Thursday, November 20, 2014 5:51 PM
  • Yes the exchange server is correct. 

    Is there something which I need to get enabled on the exchange server for things to work?


    Mr Shaw

    Thursday, November 20, 2014 6:00 PM
  • Hello,

    You need to configure relay in exchange server to allow sql server send email.

    http://technet.microsoft.com/en-us/library/dd277329.aspx

    • Marked as answer by Mr Shaw Thursday, November 20, 2014 6:12 PM
    Thursday, November 20, 2014 6:11 PM
  • brilliant.. i will test this tomorrow morning.

    Mr Shaw

    Thursday, November 20, 2014 6:13 PM
  • You may have an issue with the firewall. Try to disable the server firewall and see if it helps.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Friday, November 21, 2014 3:03 AM