O365 not able to work with SQL Server Database Mail

%3CLINGO-SUB%20id%3D%22lingo-sub-1211111%22%20slang%3D%22en-US%22%3EO365%20not%20able%20to%20work%20with%20SQL%20Server%20Database%20Mail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1211111%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20have%20a%20Win%20Server%202003%2C%20running%20SQL%20Server%202005.%20I%20wanted%20to%20configure%20email%20sending%20in%20SQL%20Server%20(Database%20Mail)%20using%20O365%20with%20the%20following%20parameter%3A%3C%2FP%3E%3CP%3E-%20smtp.office365.com%20%2F%20587%3CBR%20%2F%3E-%20basic%20authentication%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EI%20can%20ping%20to%20smtp.office365.com%20and%20telnet%20to%20port%20587%2C%20but%26nbsp%3B%3C%2FFONT%3EI%20hit%20the%20error%20while%20sending%20the%20mail%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CEM%3EMessage%3C%2FEM%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CEM%3EThe%20mail%20could%20not%20be%20sent%20to%20the%20recipients%20because%20of%20the%20mail%20server%20failure.%20(Sending%20Mail%20using%20Account%201%20(2020-03-05T10%3A31%3A22).%20Exception%20Message%3A%20Cannot%20send%20mails%20to%20mail%20server.%20(Failure%20sending%20mail.).%3C%2FEM%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CEM%3E)%3C%2FEM%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EI%20tried%20with%20another%20SMTP%20host%20(without%20SSL)%2C%20have%20no%20problem%20sending%20email%20.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EAny%20idea%20where%20went%20wrong%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1211111%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1231393%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20not%20able%20to%20work%20with%20SQL%20Server%20Database%20Mail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1231393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F573218%22%20target%3D%22_blank%22%3E%40cllee%3C%2FA%3E%26nbsp%3BSTARTTLS%20-%20on%20%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi,


I have a Win Server 2003, running SQL Server 2005. I wanted to configure email sending in SQL Server (Database Mail) using O365 with the following parameter:

- smtp.office365.com / 587
- basic authentication

 

I can ping to smtp.office365.com and telnet to port 587, but I hit the error while sending the mail:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2020-03-05T10:31:22). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
)

 

I tried with another SMTP host (without SSL), have no problem sending email .

 

Any idea where went wrong?

Thanks.

2 Replies
Highlighted

@cllee STARTTLS - on ??

Highlighted

@ankit shukla 
Where do i enabled STARTTLS? I don't see such option available.