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