Saturday, January 25, 2020

Data Driven Subscription Email Setup Notes

I wanted to deliver data-driven subscriptions via email. Here's how I used my Office 365 account for the smtp server:

Server Address: smtp.office365.com
Port Number: 587

The Report Server Configuration Manager's E-mail settings doesn't allow you to enter the STMP port number. I had to open up the rsreportserver.config file and enter it. I'm using SSRS 2019 and I found the rsreportserver.config file in the folder C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.

Find the <Extension Name="Report Server Email" section and set <SMTPServerPort>587</SMTPServerPort>

No comments:

Post a Comment