Having an issue with SSRS 2008 at the moment, trying to setup subscriptions.
Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports. This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....."
What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder.
Is the /any/ workaround at all that doesn't involve storing the credentials? It seems totally crazy that they cannot be prompted for them when setting up the subscription. For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work. If we saved their credentials then they would see all the data..and thats nasty.
The only workaround I can come up with would be to create a separate datasource for each user and upload a separate model, but thats really nasty to be honest and creates an administration nightmare.