Office 365 Database Emails with SSMS 2019

Mucho85 1 Reputation point
2021-03-16T10:03:34.313+00:00

I have SSMS 2019 set up with an Office 365 account, which has its own full mailbox. The settings are shown in the screenshot, with the email address and username being the full email address.

78165-image.png

When I use the inbuilt Send Test E-Mail function, the mail fails to send and I get the following error.

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2021-03-15T17:20: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.57 Client not authenticated to send mail. [XXXXXXXXXXXXX.XXXXXXX.PROD.OUTLOOK.COM]).

SSMS is installed on a Windows Server 2019 VM in Azure, and is not joined to Azure AD. Does anyone have any ideas on what the issue may be?

I am also unable to send email through SQL Server Reporting Services

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,318 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points
    2021-03-18T10:04:30.147+00:00

    Seems your email configuration is correct.
    See How to set up a multifunction device or application to send email using Microsoft 365 or Office 365 for a step-by-step guide.

    0 comments No comments

  2. Borcard François 1 Reputation point
    2021-04-28T09:38:29.12+00:00

    Hello,

    I have the same problem. Any help would be appreciated

    0 comments No comments