Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 29, 2015 12:12 AM
Points: 95, Visits: 339
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: Friday, July 3, 2015 12:49 AM
Points: 2,793, Visits: 2,162
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 11, 2015 5:46 AM
Points: 529, Visits: 1,946
How are you authenticating?
Post #1553966
Posted Monday, March 24, 2014 5:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:49 PM
Points: 13,571, Visits: 34,549
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1553984
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse