Resolving “Source: CDO.Message.1 Description: The transport failed to connect to the server” error while sending email using CDOSYS

While sending email using CDOSYS in SQL Server, you may receive an error as below:

(1 row(s) affected)

(1 row(s) affected)

  Source: CDO.Message.1

  Description: The transport failed to connect to the server.

(1 row(s) affected)

Resolution:

This message informs you that host server could not connect to SMTP server. Hence please take below steps to fix this issue:

1. Find the SMTP server name used in the procedure. It will be in the below line with in the SP (assuming you are using Microsoft supplied procedure)

EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', '[SMTP SERVER NAME]'  

Make sure that you can not use the supplied SMTP server name using below command in command prompt:

      telnet [SMTP SERVER NAME] 25

It should throw an error complaing SMTP connection could not be established.

[Note: Typically SMTP Server uses Port 25 for telnet hence we are trying to establish a connection with port 25 in this example. Replace 25 with correct value if your SMTP server is customized to use another value]

2. Replace SMTP Server name with correct server/IP in the actual procedure and recompile it. This step should resolve the issue.