SSRS Email Subscription Not working

1
votes

I'm trying to set up a couple of email delivery subscriptions to send out a few reports.

I have 1 fully working subscription that emails out every day at the same time. How ever if i try to create any more it fails. If i change the name of the report (with the working subscription) in any way it then fails until i undo any name changes that have been done.

Do i need to configure each report (the first subscription was already set up for me.)

I have tried making the new subscriptions but each time get a fail to send message.

1
emailreporting-servicessubscriptions
Do you have any details from the reporting services error log that you can share? - Ross Bush
all im seeing is - user5627259
rsServerConfigurationError - user5627259

1 Answers

1
votes

If you don't use a shared data source you will need to configure the data connection report by report. Also, you need to set up the subscription one-by-one.

If you have access, try to run a query for the execution log for more detailed information.

USE ReportServer GO

SELECT * FROM ExecutionLogStorage