Gmail SMTP server configuration in SSIS Send Mail Task

Question

Hi,

    I have SQL server 2008 in my system, I want to send a mail to my gmail ID on every  week, along with a excel attachment. For this, for SMTP server  for gmail, i tried smtp.gmail.com but it failed with 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".

can u guys pls help me?

Answer 1

AFAIK, GMAIL does not implement/support SMTP communications, so you simply cannot do that.

---

Arthur My Blog

Answer 2

what about yahoo?

Answer 3

The SMTP server settings for Yahoo! Mail Plus accounts are:

• Yahoo! Mail SMTP server address: plus.smtp.mail.yahoo.com
• Yahoo! Mail SMTP user name: Your Yahoo! Mail user name
• Yahoo! Mail SMTP password: Your Yahoo! Mail password
• Yahoo! Mail SMTP port: 465
• Yahoo! Mail SMTP TLS/SSL required: yes

(Updated January 2012)

So because it requires TLS/SSL it must not work in SSIS.

Thing is, in a corporate environment you should not use public email providers.

---

Arthur My Blog

Answer 4

Check the commercial COZYROC Send Mail Task, which is part of the SSIS+ library. It does support gmail SMTP.

---

SSIS Tasks Components Scripts Services | http://www.cozyroc.com/