• Adam Thurgar

Database Mail and Outlook 365


Whilst setting up a server, we had to configure database mail. Usually a straight forward exercise but it ended up being a lot more trouble than I had anticipated.

This was because mail was being handled through Office 365.

Firstly the server needs to be the mail.protection.outlook.com MX endpoint.

Then you need to go to the Office 365 delist portal and put in the SQL Servers IP address.

Then we had a Relay Access Denied error which meant that an Office 365 connector needed to be created.

Not as easy as it used to be with an on premise or ISP mail server.


4 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t