DataBase Mail Error

Question

DataBase Mail Error

darshan28

Ten Centuries

Points: 1021
More actions
August 25, 2008 at 1:31 pm

#211503

Hi All,
i have try to send mail using DataBase Mail from SQL2k5 but it return the following error
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-08-25T15:09:25). 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. 13sm8177774wrl.19). )
Details about What i did ?
First i have configure database mail to send mail .provided my gmail-id (xyz@gmail.com) and sever as
'smtp.gmail.com' then basic authentication provided xyz@gmail.com and password of my gmail account.
so plz help me in this regards.

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Did you check the "This server requires a secure connection (SSL)" box? It sounds like that is what it is after.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

darshan28 Ten Centuries Points: 1021 More actions · Answer 2

Hi all

Resending With Details Information With Code i used

1-First i have Configure database mail ,Created a profile to send mail using gmail account the things i provided are my gmailid(xyz@gmail.com),plus server(smtp.gmail.com)then selected basic authentication and provided with userid i.e. xyz@gmail.com and password.

2-Then executed following codes

sp_CONFIGURE 'show advanced', 1

GO

RECONFIGURE

GO

sp_CONFIGURE 'Database Mail XPs', 1

GO

RECONFIGURE

GO

USE msdb

GO

EXEC sp_send_dbmail @profile_name='Priyadarshan',

@recipients='xyz@gmail.com',

@subject='Test message',

@body='This is the body of the test message.

Congrates Database Mail Received By you Successfully.'

SELECT *

FROM sysmail_mailitems

GO

SELECT *

FROM sysmail_log

GO

3-After executing this code i get following error.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-08-25T15:09:25). 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. 13sm8177774wrl.19). )

So plz help me ...............

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

When you set up your database mail profile and account did you set it up to use SSL? See my first post.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

darshan28 Ten Centuries Points: 1021 More actions · Answer 4

Hi Jack,

After checking "This server requires a secure connection (SSL)" box its started working now i can

send mail.

Thanks a lots

deepthimp Valued Member Points: 55 More actions · Answer 5

Hi jack

After checking the checkbox it worked perfectly for me !thanks