I Have Configure Gmail In Sql Dbmail. But I Am Not Able To Send The Mails.

Question

0.00/5 (No votes)

See more:

am getting below error massage

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2015-10-18T00:42:18). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. pk2sm27875226pbb.21 - gsmtp).
)

Posted 21-Oct-15 5:20am

Member 12076614

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2015-10-21T05:36:00

Solution 1

When you configure the mail account, you need to tick the "This server requires a secure connection (SSL)" option.

How to configure SQL Server Database Mail to send email using your Windows Live Mail Account or your GMail Account | MSDN Blogs[^]

Posted 21-Oct-15 5:36am

Richard Deeming

Comments

Member 12076614 21-Oct-15 12:14pm

Hi follow error am getting my mail.. Can pls help me out

Sign-in attempt prevented
Hi Chowdari,
Someone just tried to sign in to your Google Account chowdari.ld@gmail.com from an app that doesn't meet modern security standards.
Details:
Wednesday, October 21, 2015 9:20 PM (India Standard Time)
Telangana, India*
We strongly recommend that you use a secure app, like Gmail, to access your account. All apps made by Google meet these security standards. Using a less secure app, on the other hand, could leave your account vulnerable. Learn more.

Google stopped this sign-in attempt, but you should review your recently used devices:

REVIEW YOUR DEVICES NOW
Best,
The Google Accounts team
*The location is approximate and determined by the IP address it was coming from.
This email can't receive replies. For more information, visit the Google Accounts Help Center

Richard Deeming 21-Oct-15 12:17pm

You can configure the setting in GMail:
https://www.google.com/settings/security/lesssecureapps[^]

Otherwise, you'll have to create an app-specific password for SQL to use:
https://support.google.com/accounts/answer/185833?hl=en[^]