SSIS SMTP Connection Manager

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.


[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.

more ▼

asked Oct 22, 2009 at 01:51 PM in Default

avatar image

user-252 (yahoo)
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Oct 23, 2009 at 09:38 AM

avatar image

Frank Bazan
51 2 3

(comments are locked)
10|1200 characters needed characters left

Im not sure that smtp.google.com allows relaying..

one quick way to check is from the server try ..

  • Start | Run
  • cmd
  • type telnet smtp.google.com 25

I get a failure. But not unusual if they are blocking direct smtp connections.

more ▼

answered Oct 22, 2009 at 02:56 PM

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 25, 2009 at 02:05 PM

avatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 22, 2009 at 01:51 PM

Seen: 16124 times

Last Updated: Oct 23, 2009 at 05:34 AM

Copyright 2018 Redgate Software. Privacy Policy