How to configure SQL Database mail (or any other application) to send emails using Office 365 (Exchange Online): A walk through and options




What I have come to understand is that with Office365 email routing the configuration settings for email relay are,


Port Number:    587

Authentication:                Basic (An email address and password)

We can set this up on each individual server that needs to send out emails or we can configure a single outbound email relay server.

Option 1

An example below email config for SQL servers other applications would be similar along with related network and firewall settings.



Option 2

Alternatively. We can setup an internal relay server to which every server can send email and from that server we can forward to office365 with above credentials.

Additionally, the Exchange settings in Office365 can be set for inbound connection permissions to specify which servers can relay.

Both approaches have their pros and cons which need to be discussed.





IT professional with wider interest in technology

Tagged with: ,
Posted in email, SQL Server, Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: