x

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.

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.

more ▼

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

user-252 (yahoo) gravatar image

user-252 (yahoo)
1 1 1 1

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

3 answers: sort newest

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

Frank Bazan gravatar image

Frank Bazan
51 2

(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

Sourav gravatar image

Sourav
1

(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

sp_lock gravatar image

sp_lock
9.2k 25 28 31

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x939
x344
x4

asked: Oct 22, 2009 at 01:51 PM

Seen: 12016 times

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