CODEWITHSUNDEEP
reporting-servicesreportbuilder3.0
Bradley Uffner
Bradley Uffner

Reputation: 17001

Can't subscribe to ReportBuilder report in SSRS 2008-r2

When a user tries to subscribe to a report created via ReportBuilder they receive the following error: "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."

As far as I can tell the credentials ARE being stored, but report server seems to be ignoring them. We are able to subscribe to non-ReportBuilder reports using the same data source just fine.

We have been trying to track down the problem for several weeks now and haven't gotten anywhere. Any help would be greatly appreciated.

The report uses a shared data source on its model. This is the only model defined on the server: Report Configuration

The model uses the following data source defined on the server (this is the same data source that other reports use, and it's the only data source stored on the server.): Model Configuration

The Data Source is set to store the credentials on the report server (you can see the results of testing the connection at the bottom of the screenshot): Data Source Configuration

Upvotes: 1

Views: 423

Answers (1)

Tomi Niemenmaa
Tomi Niemenmaa

Reputation: 650

You cannot subscribe to a Report Builder report that uses a model as a data source if the model contains model item security settings. Could this be the cause of your issue?

Upvotes: 1

Related Questions