By Garth Jones
One of the most important things that you can do to make your Manager or security team happy is to setup a rule to automatically email them status reports. This will allow them to see reports about patch management or compliance settings, for example, on a regular basis.
Using Office 365, however, presented a unique challenge because SQL Server Reporting Services (SSRS) requires a Simple Mail Transfer Protocol (SMTP) connection to the email server. And, in order to use a SMTP connection, Office 365 required the authentication of a user’s account and you couldn’t authenticate an account with SSRS.
All of that changed with the release of SQL Server 2016 SSRS. Now you can add a username and password to connect to your SMTP server settings.
Start by opening Reporting Services Configuration Manager and connecting to your SSRS server.
On the E-mail Settings node, change the Authentication mode to Username and password (Basic).
Once the authentication mode is changed you can then configure the username and password. Don’t forget to check Apply.
Your final screen will look similar to the one below.
With that you can now email reports/dashboards to anyone!