If I run a SSRS Server on-prem can I deliver reports over the Internet to the external users to whatever emails they might have? Each user should be getting a personal version of the report.
Thanks
If I run a SSRS Server on-prem can I deliver reports over the Internet to the external users to whatever emails they might have? Each user should be getting a personal version of the report.
Thanks
Hi @markgoldin-3750,
Of course you can.
SQL Server Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups.
To distribute a report by e-mail, you 1) configure the report server for e-mail delivery and 2) define either a standard subscription or a data-driven subscription.
The report server connects with an e-mail server through a standard connection. It does not use communication that has been encrypted using Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL).
The e-mail server must be a remote or local Simple Mail Transport Protocol (SMTP) server on the same network as the report server.
More details you may refer:
e-mail-delivery-in-reporting-services
create-and-manage-subscriptions-for-native-mode-report-servers
create-modify-and-delete-data-driven-subscriptions
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
What if I need to send a report to multiple users at once and each copy should have data specific for an email recipient. Can that be done?
If you mean that e-mail a report to multiple users and the report data for each user is specific different at once, it seems couldn't be done temporarily, we need to create multiple subscriptions to meet your need.
7 people are following this question.