#1 2022-05-30 10:30:47

Johann
Member
Registered: 2022-05-30

How to schedule reports via Email SMTP

I understand that in ReportServer 3.7, the "send email as an attachment" functionality is deprecated. Hence, I tried scheduling via email (SMTP) but am getting this error:

Default datasink could not be loaded.


I've tried reading the documentation here: https://reportserver.net/en/guides/conf … Scheduler/
and here: https://reportserver.net/en/guides/conf … -Datasinks

and so now I have:

1. created a datasinks/datasinks.cf file in File System which has the following contents:

<email disabled="false" supportsScheduling="true">
    <defaultDatasinkName>Default Email Datasink</defaultDatasinkName>
    <!-- or access via ID -->
    <!-- <defaultDatasinkId>14</defaultDatasinkId> -->
</email>

2. Created a Datasink using my root user (somehow my other administrators cannot create or view datasinks in the Administration tab) and configured the name, host, port, sender, sender name and encryption policy.


Am I missing something here? Any advice would be greatly appreciated. Thank you!

Offline

#2 2022-05-30 10:38:18

eduardo
Administrator
Registered: 2016-11-01
Website

Re: How to schedule reports via Email SMTP

Hi Johann,

you are missing in 1. the <configuration> file, the default datasinks is found here: https://reportserver.net/en/guides/conf … tasinkscf/

for being able to schedule via datasinks, you also need scheduler.cf, found here: https://reportserver.net/en/guides/conf … hedulercf/

For the other users to be able to see/create datasinks, they need administration permission, and also datasink admin permission. Pls take a look here: https://reportserver.net/en/guides/admi … anagement/  3.2.2. Generic rights

Administration. The generic right Administration controls the access to the Administration module. If reading right (r) is granted the user concerned can open the Administration module. The access to Administration sub-modules must be released individually. Rights other than the reading right are not queried. Target: net.datenwerke.gf.service.genrights.AdministrationViewSecurityTarget

Datasinks. The datasinks generic right controls the access to the datasinks tree in the Admin module. Reading right is queried. The actually granted access rights to single datasinks will be controlled by object rights. Target: net.datenwerke.rs.core.service.genrights.datasinks.DatasinkManagerAdminViewSecurityTarget

They also need datasink permission, for example in the datasink root folder (permissions tab)

Regards,
Eduardo

Offline

#3 2022-06-01 02:17:16

Johann
Member
Registered: 2022-05-30

Re: How to schedule reports via Email SMTP

Got it, thank you so much!

Last edited by Johann (2022-06-01 02:35:07)

Offline

Board footer

Powered by FluxBB