Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DATA Base mail configuration using GMAIL - Giving error Expand / Collapse
Author
Message
Posted Sunday, March 23, 2014 8:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 30, 2016 1:54 AM
Points: 100, Visits: 405
Hi All,

I was trying to do Database mail configuration from gmail.

But I cant send Text mail. Its failing with below error.

I have used

SMTP server name: smtp.gmail.com Port number: 587

Please help me :




Error,18,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2014-03-22T20:12:00). 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.5.1 Authentication Required. Learn more at).
),6108,4,,3/22/2014 8:12:00 PM,sa


Thanks for your help in advance

Post #1553820
Posted Monday, March 24, 2014 12:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
Can you try 'ssl://smtp.gmail.com', and port '465'

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1553870
Posted Monday, March 24, 2014 5:21 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:05 AM
Points: 848, Visits: 3,327
How are you authenticating?
Post #1553966
Posted Monday, March 24, 2014 5:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 14,557, Visits: 38,451
you can't use anonymous authentication, sounds like you left the SMTP authentication section blank.
587 is for non-SSL i thought.
it should look like this:



Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1553984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse