Allowing multiple different SQL Servers in Azure to send email to my mailbox using the SMTP relay provided by Microsoft Exchange Online Protection?

Question

I have multiple SQL servers deployed and running in Azure spread across multiple regions globally.

I need to allow each of those SQL servers to send email alerts, however, using the DNS MX record listed under the https://admin.microsoft.com/Adminportal/Home?#/Domains/Details/MyCustomDomain.com like mydomain-com.mail.protection.outlook.com is not working.

Do I need to assign public IP address to each of the SQL Servers so I can use the steps defined in Option 3: Configure a connector to send mail using Microsoft 365 or Office 365 SMTP relay https://learn.microsoft.com/en-us/exchange/mail-flow-best-practices/how-to-set-up-a-multifunction-device-or-application-to-send-email-using-microsoft-365-or-office-365#option-3-configure-a-connector-to-send-mail-using-microsoft-365-or-office-365-smtp-relay ?

By listing the Public IP address under the https://admin.exchange.microsoft.com/#/connectors ?

Any help and suggestions would be greatly appreciated.

Answer 1

Hi @EnterpriseArchitect ,

Do I need to assign public IP address to each of the SQL Servers so I can use the steps defined in Option 3: Configure a connector to send mail using Microsoft 365 or Office 365 SMTP relay ? By listing the Public IP address under the https://admin.exchange.microsoft.com/#/connectors ?

Based on my understanding, yes, static unshared IP address is required to be assigned to each of the Servers. For more details, you can go through the requirements and configuration steps in the document you mentioned above.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.