After a few hours of struggling, I found that (for now) the only method of sending e-mails from your SQL Server Instance (inside a Windows Azure Virtual Machine / Environment) is to setup a SMTP-service in IIS 6.0 (Yes I know, but SQL Server doesn’t support the use of ‘TLS encryption‘). Mohamed M Malek posted a step-by-step blogpost which will provide you a grant tour on how to set this up, click here.
I’ve tested this solution in a Windows Azure VM:
– Windows Server 2012 Datacenter Edition (from the Virtual Machine Catalog in Windows Azure)
– SQL Server 2012 Express Edition
Yes the Express Edition of SQL Server does indeed supports sending mails by using sp_send_dbmail(). More info on how to set that up: click here
Do not fill in any username or password details in Account:
LocalHost will serve as an SMTP-server for the Account:
-> Don’t forget to stop and start the SMTP-service!
The Office 365 version I’m currently using is the ‘Office 365 for professionals and small businesses‘.