SQL Mail Configuration Errors

Download PDF

You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message.

Date 8/xxxxxx03 AM
Log Database Mail (Database Mail Log)
Log ID 40
Process ID 56316
Mail Item ID 14
Last Modified 8/ xxxxx 03 AM
Last Modified By sa
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2xxxxxx:03). Exception Message: Cannot send mails to mail server. (Service not available, closing transmission channel. The server response was: 4.3.2 Service not available).
)

There can be a number of reasons for this failure, mostly it is saying that the connection could not be established. The mail server configuration was set up to use port 25.

Many networks, and ISPs will block port 25 to reduce the amount of spam, and often times port 587 is kept open as an alternative mail port.

If you are seeing this message, you can try switching form port 25 to port 587 to see if it fixes the problem. It worked for me.

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*