Shared Data Sources can't use Subscription ?

Question

Shared Data Sources can't use Subscription ?

onlo

SSCertifiable

Points: 5080
More actions
May 26, 2008 at 8:50 pm

#188168

Dear all,
I use Shared Data Sources and fail to create a report subscription.
"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid."
Some web sites say in order to make a report subscription, I have to choose :
"A custom data source", "Credentials stored securely in the report server".
Does it mean I can't use "A shared data source" if I need to make a report subscription ?
Or there are some workarounds for this problem ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29389 More actions · Answer 1

Your data source is defined so that Report Services impersonates the credentials of the user runing the report. For a subscription to be created for a report, reporting services does not permit this to occur. Instead you will need to create another data source that explicitly specifies credentials for a user and point the report (or a copy of it) at that data source) and then create the subscription.

onlo SSCertifiable Points: 5080 More actions · Answer 2

So does it mean what I guessed is correct :

Shared Data Source is not allowed in Report Subscription ?

happycat59 One Orange Chip Points: 29389 More actions · Answer 3

No, it doesn't. You can use any data source but it does need to store the credentials of a user that can run the report

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 4

Before creating subscriptions, you need to ask yourself if you need to run the report with the users access. If all users run reports with the same access, then you can simply change the data source to use a specific user (i.e. a system user).

The scheduled reports needs to know what credentials you want to run with, when producing the reports. So you have a couple of options:

a) One data source, saved credntials (for online & batch)

b) Two data sources, one with saved credentials (batch) and one that uses the users credentials (online).

Of course, you could extend this a bit (i.e. different batch profiles), but I wouldn't recommend traveling this path unless absolutely necessary.