locked
Gmail SMTP server configuration in SSIS Send Mail Task RRS feed

  • 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?

    Tuesday, May 14, 2013 5:40 PM

Answers

  • 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

    • Proposed as answer by Mike Yin Friday, May 17, 2013 9:38 AM
    • Marked as answer by Mike Yin Tuesday, May 21, 2013 2:53 AM
    Tuesday, May 14, 2013 8:31 PM
  • AFAIK, GMAIL does not implement/support SMTP communications, so you simply cannot do that.

    Arthur My Blog

    • Proposed as answer by Mike Yin Friday, May 17, 2013 9:38 AM
    • Marked as answer by Mike Yin Tuesday, May 21, 2013 2:53 AM
    Tuesday, May 14, 2013 5:44 PM
  • 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/

    • Marked as answer by Revathy Menon Thursday, May 23, 2013 3:37 AM
    Wednesday, May 15, 2013 3:54 AM

All replies

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

    Arthur My Blog

    • Proposed as answer by Mike Yin Friday, May 17, 2013 9:38 AM
    • Marked as answer by Mike Yin Tuesday, May 21, 2013 2:53 AM
    Tuesday, May 14, 2013 5:44 PM
  • what about yahoo?
    Tuesday, May 14, 2013 6:13 PM
  • 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

    • Proposed as answer by Mike Yin Friday, May 17, 2013 9:38 AM
    • Marked as answer by Mike Yin Tuesday, May 21, 2013 2:53 AM
    Tuesday, May 14, 2013 8:31 PM
  • 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/

    • Marked as answer by Revathy Menon Thursday, May 23, 2013 3:37 AM
    Wednesday, May 15, 2013 3:54 AM