question

user-252 (yahoo) avatar image
user-252 (yahoo) asked

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.

ssissql-serversmtp
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Frank Bazan avatar image
Frank Bazan answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sourav avatar image
Sourav answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.