I am new to SMTP connection manager in SSIS. I was trying to send email with my Gmail account, I am getting error while executing the
[Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at ".
What I find from above is that I am not authenticated, but when I find in Send Mail properties, there is no option to provide password. Just From & To fields are there.
I've used smtp.gmail.com as my SMTP server.
I am curious if any one know what the problem is or any URLs where I can find the solution for this problem.
I think part of your issue is that in gmail you need to use SSL over port 465 (I think).
See http://mail.google.com/support/bin/answer.py?hl=en&answer=13287 for gmail connection settings.
Other issue you're having is as the previous poster states, gmail won't allow unauthenticated users to send mail, so you would either need an smtp server that allows message relay, or if you have to send via gmail, you will need to write a script component using the system.net.mail namespace.
SSIS does not support basic authentication. It only supports Windows and Anonymous authentication. Google mail needs basic authentication. So you cannot configure SMTP Connection Manager in SSIS with an external SMTP server like Gmail, Yahoo etc.
answered Nov 25, 2009 at 02:05 PM