when I try to set up a subscription, I get this error message: "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"
I use a datasource which use windows credentials to access a database which contains stored procedure with OpenRowset query to access cube data in analysis service on the same server.
I have to use windows credentials to access cube data in analysis service. How can I store the credentails with windows credentials?
I appreciate your help!
View Complete Post