July 29, 2024 at 12:03 pm
HI ALL,
Database Mail (Database Mail Log) getting failed when configure a db mail, how to fix this to send the db mail success
using server name as email smtp.office365.com and port 587
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-07-29T11:48:14). 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.57 Client not authenticated to send mail. Error: 535 5.7.139 Authentication unsuccessful, SmtpClientAuthentication is disabled for the Tenant. Visit https://aka.ms/smtp_auth_disabled for more information. [PN3PEPF00000182.INDPRD01.PROD.OUTLOOK.COM 2024-07-29T11:48:14.798Z 08DCAE28C68BCA9D]).
)
Thanks
Naga.Rohitkumar
July 29, 2024 at 1:09 pm
You need to authenticate with O365.
Use basic authentication and give it the email address and password needed to login to that mailbox you wish to send mail as.
July 30, 2024 at 4:33 am
Dear Ant-Green
Use basic authentication and give it the email address and password needed to login to that mailbox you wish to send mail as. -- it already there but still getting same error
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-07-30T04:31:35). 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.57 Client not authenticated to send mail. [PN3PEPF00000189.INDPRD01.PROD.OUTLOOK.COM 2024-07-30T04:31:35.678Z 08DCB04CA4538199]).
Thanks
Naga.Rohitkumar
July 30, 2024 at 6:32 am
Speak with your O365 admins then to see why it is saying you are unauthenticated.
Make sure you have SSL enabled.
Make sure you have TLS enabled.
July 30, 2024 at 7:06 am
As you posted in the 2019 forum area also this shouldn't apply to you, but incase you're on SQL2016 or below, you may need to add the registry keys at the end of this document also.
July 30, 2024 at 7:12 am
Dear Ant-green
Yes it is a 2019 rtm version
DatabaseMail process is shutting down is getting in the log , attached dbmail log as well please suggest i need to fix it generate mail to get html reports
Thanks
Naga.Rohitkumar
July 30, 2024 at 7:31 am
Go speak with your mail admins and work out where it is failing.
Your error is you’re not authenticating properly or you’re not using a secure connection.
Go work with your mail admins to ensure you can connect securely from the SQL host to O365’s SMTP server.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply