Welcome to a new infra post… Yes, I’m not a system engineer and neither I wish to be it, but until it comes to press Next, Next, Next, Accept, End… I’m a very expert!!!
Well, in this post I’ll describe how to configure SQL Server 2014 Database Mail in order to send mail message using the Office365 default SMTP Server.
Two years ago I wrote a nice post where I describe how to send mail using this SMTP thanks to the .Net SMTPClient class… Have a look at that…
http://zsvipullo.blogspot.it/2015/01/send-e-mail-message-using-office365.html
Now, I’ll apply this know how to configure Sql Server Database Mail.
From Sql Server Management Studio, connect to your SQL server and choose, under the Management node, Database Mail.
and follow the instructions shown by the screenshot below.
Click on Add Button: you must insert the following paramenter, using an email address with send mail permission for the Office 365 SMTP.
And now let test this configuration...
And here the result...
Good job infra man!!!