< Blog

How to Subscribe to Configuration Manager Reports Using Office 365

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).

How to Subscribe to ConfigMgr Reports Using Office 365-Authentication

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.

How to Subscribe to ConfigMgr Reports Using Office 365-Email Settings

With that you can now email reports/dashboards to anyone!

For details on the subscription steps see my blog post, How to Set-up an Email Subscription in SSRS. If you have any questions, please feel free to contact me @GarthMJ.