Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Des
Starting Member
7 Posts |
 Posted - 2008-10-28 : 14:23:31
|
| Hi,We have used a script to create a bunch of reports, report models, and data sources. There is a report that is using a report model as a data source and then the report model uses a shared data source in the background.When we try to create a subscription, we get 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.Is there a work around for this? What do we need to change in order to have this working? We do not have the option to have the report use the data source directly because the report model is needed to generate the report. Any help at all will be greatly appreciated. ~Desirée |
|
|
Des
Starting Member
7 Posts |
Posted - 2008-10-28 : 14:28:51
|
| Never mind, as soon as I posted this, we fixed it by setting the backend data source to use a domain account.~Des |
 |
|
|
|
|
|
Report model as data source (subscription too?)