Microsoft To End Basic Authentication in Exchange

Question

Hi Experts, I am a DBA and I was told by my manager to check if the SQL server has any effect when Microsoft ends basic authentication and came across below 2 which are close to the SQL server

1. "Authenticated SMTP – Used by POP and IMAP client’s to send email messages"
2. "Reporting Web Services – Used to retrieve report data in Exchange Online"

Db mail uses smtprelay.mydomain.com in my SQL servers and wondering if this has any effect with Microsoft ends basic authentication
can you please provide some suggestions or links where I can read and make sure nothing is going to break in SQL SERVERS?
Thanks in advance

Answer 1

Hi anonymous user,

SQL server DB Mail using below authentications.

Windows Authentication using Database Engine service credentials
Connection is made to the SMTP server using the credentials configured for the SQL Server Database Engine service.

Basic Authentication
Specify the user name and password required by the SMTP server.

Anonymous authentication
Mail is sent to the SMTP server without login credentials. Use this option when the SMTP server does not require authentication.

If the basic authentication is end of supported in Exchange, then we can also use the other two authentications to configure SQL DB mail.

Refer to MS document Configure Database Mail.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.