Sunday, February 19, 2012

Database mail - send test email

i've got a brand new server and just installed SQL 2005.

when i try to send a test email, i get the following error message:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2006-11-23T11:49:34). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it). )

I have checked all items from troubleshoot and eveything is ok...any help ?

thanks

Are you properly connecting to smtp server?|||

So clearly everything is not OK, but what troubleshooting have you done?

The message says it cannot connect to the server, so he probably is not connecting to the smtp server.

From the machine hosting the package, are there any firewalls in between? Do they allow you access? Can you telnet to port 25 of the SMTP server from the machine running the SSIS package? Remember SSIS is not server side, so that is the machine that hosts the DTEXEC/BIDS process.

No comments:

Post a Comment