Applications Systems

Office 365 and Google as an SMTP Relay for DPA

This page describes steps to successfully use Office 365 and Google as an SMTP relay host.

First published date

11/12/2018 9:07 PM

Last published date

6/6/2019 9:34 PM

Overview

In order to be able to use Office 365 or Google as an SMTP relay host, additional properties need to be added. The same goes for when this is hosted on the Azure platform with 2-factor authentication.

Product section

Database Performance Analyzer

Resolution

Go to Options -> Administration (tab) -> Configure Mail Server.
In the Additional Properties box, add:
- mail.smtp.starttls.enable=true
- mail.smtp.auth=true
Deselect Secure SMTP, and use port 587.

Notes:

The 'From' and 'User' must match exactly in order to authenticate.
Special characters like '%', '#' and ':' in the password break authentication.
Google might require setting less secure apps: https://myaccount.google.com/lesssecureapps (© 2018 Google, available at https://support.google.com, obtained on December 13, 2018)

Note for Azure with 2 Factor Authentication

If you are using Azure with 2 Factor Authentication you will need to generate an API password:

Untick the "secure smtp"
host: smtp.office365.com
port: 587
user: serviceaccount@YOURDOMAIN.com
password: APIPassword
Additional properties: mail.smtp.starttls.enable=true
mail.smtp.auth=true

Note that API password must be created via this link

(you'll need to log in as the service account and authenticate normally via 2FA)
https://account.activedirectory.windowsazure.com/AppPasswords.aspx (© 2019 Microsoft Corporation, available at https://windowsazure.com, obtained on January 15, 2019)

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.