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 Error: [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.
(comments are locked)
|
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.
(comments are locked)
|
Im not sure that smtp.google.com allows relaying.. one quick way to check is from the server try ..
I get a failure. But not unusual if they are blocking direct smtp connections.
(comments are locked)
|
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.
(comments are locked)
|