SQl DBmail problem

Question

SQl DBmail problem

vs.satheesh

SSCrazy

Points: 2392
More actions
August 10, 2015 at 10:48 am

#303259

HI All
I have configured Sqlserver DBmail in using Gmail,yahoo SMTP server.But I cant able send a mail.I got a following error in msdb.dbo.sysmail_event_log table.
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2015-08-10T21:53:54). 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.1 Authentication required). )"
Please help .How to solve this problem.
by
v.s.satheesh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287024 More actions · Answer 1

vs.satheesh (8/10/2015)
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2015-08-10T21:53:54). 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.1 Authentication required). )"

The problem is given in the response from the server. You need to authenticate to the SMTP server. This is in the database mail account configuration.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

vs.satheesh SSCrazy Points: 2392 More actions · Answer 2

Still I am not able to send a mail.Please give me s solution.

Ed Wagner SSC Guru Points: 287024 More actions · Answer 3

Did you configure the authentication in the settings for the account?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Lowell SSC Guru Points: 323504 More actions · Answer 4

you have to fill out the authentication settings of your mail profile; google, yahoo, virtually every external mail server requires the AUTH command to send username and password, so that they cannot be used to send spam and viagra sales notifications.

even your email server on the LAN will reject you, unless the server IP sending mail is on a whitelist.

at my job,, they put all servers on a whitelist, but normal desktop/laptop/workstations are not on that list, and cannot send SMTP to our servers,for example.

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!