Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2014-05-16 : 10:56:27
|
| Hi,I am trying to send mail from ssis package. When I debug package it return error:[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 xx.xx.xx.xx:25.Pleae help.Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2014-05-16 : 13:34:32
|
| Solution:McaFee was blocking outgoing email. 1. Right click on Mcafee at bottom of your screen.2. Select manage features.3. Select Virus scan enterprise.4. Double click access protection.5. Select anti-virus Standard Protection.6. Double click Prevent mass mailing worms from sending mail.7. In process to exclude - add DtExec.exe, DtExecUI.exeThat will resolve your issue. |
 |
|
|
|
|
|
Send Mail Task Failed - SSIS