We have an SSRS with Oracle as data source. Creating report Works, but creating subscriptions doesn't.
On the Data Source configuration page,i use Oracle internal user and enabled "Credentials stored securely on the report server". If i click Test Connectiong, it says the connectiong was succesful.
Creating a subscription gives the 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."
Something i found out is that the reports i create have as data source :
Data Source=localhost;Initial Catalog=Production and Windows Integrated Security as credentials.
Shouldn't Oracle be the data source and what can i do to correctly configure the subscriptions?
