0

I am bit confused sending e-mail via SQL Server 2008 Management Studio. I tried all remedies discussed in most threads, but unfortunately still having the issues. Can someone help me to resolve the matter? Much appreciated!

I am getting following error, when trying to send e-mail via SSMS

The mail could not be sent to recipient because of the mail server failure...(SMTP server requires a secure connection or the client was not authenticated. The server response was 5.7.0. Must issue a STARTTLScommand first

I checked my GMail user name and password, and properly defined profile and account, port used 587.

SMTP E-mail setup done at IIS (Windows 7 PC)

Kindly advise, how can I overcome the e-mail sending issue using SSMS?

TT.
  • 15,774
  • 6
  • 47
  • 88
programlover
  • 11
  • 2
    Did you see the top comment here? https://www.mssqltips.com/sqlservertip/2578/setup-sql-server-database-mail-to-use-a-gmail-hotmail-yahoo-or-aol-account/ – Martin Smith Sep 16 '17 at 16:41
  • 1
    you can find some of the useful information here as well : https://stackoverflow.com/questions/41998085/unable-to-send-email-from-sql-server – Anura Adhikari Sep 17 '17 at 02:37

1 Answers1

0

It's better to share the configuration which you have set for database mail, but anyways:

  1. STARTTLS means the Gmail server is asking for authentication, and xp_smtp_sendmail does not provide ways for getting authenticated with Gmail or Yahoo.
  2. Check these links ... link and link as I guess you have something wrong in your configuration there.
Ahmed Negm
  • 865
  • 1
  • 11
  • 30