CODEWITHSUNDEEP
reporting-servicesssrs-2008credentials
DeepSea
DeepSea

Reputation: 3232

SSRS 2008 Credentials used to run this report are not stored

I created a report in SSRS, and deployed it. I went to the properties of the report the Process option, and tried to set up Cache a temporary copy of the report and got an error 'Credentials used to run this report are not stored.' I get the same error if I go to Snapshot Options and try to select any of the options there.

Thanks in advance

Upvotes: 0

Views: 6327

Answers (1)

Ian Preston
Ian Preston

Reputation: 39586

As per the error, you need to set up the report Data Source similar to the following:

enter image description here

If you're not storing credentials you cannot cache reports or create snapshots.

With cached reports, a temporary copy is created when a user runs a report and this can be used for subsequent runs of the report. Since this could be performed by different users, the only way this can work is if the same connection is used to the Data Source each time; it must be independent of whoever is running the report when the copy is cached.

Same principle for snapshots; no guarantee who will run reports based off the snapshot, so the Data Source connection must be independent of the user running the report, i.e. stored at the Data Source level.

Upvotes: 5

Related Questions