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.
Office 365 Database Emails with SSMS 2019
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.
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
2 answers
Sort by: Most helpful
-
Olaf Helper 42,846 Reputation points
2021-03-18T10:04:30.147+00:00 -
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