Microsoft To End Basic Authentication in Exchange

Anonymous
2021-03-18T10:57:41.59+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,324 questions
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2021-03-19T02:59:12.86+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful