March 6, 2009 at 10:17 am
I have a report built using SSRS that pulls data from an SSAS cube, the data source uses integrated security and works fine. All the users who are supposed to see it can see it, when I try to set up a subscription to email it out to a couple of users I get
(rsInvalidDataSourceCredentialSetting) error
and the status is
Failure sending mail: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database.
how come the report works but the subscription doesnt and how can I work round it
any ideas?
March 6, 2009 at 10:58 am
You are using a data source with integrated security selected. The scheduler does not like that because it does not have valid NT credentials.
You can select the option to include the credentials in the data source. The credential you use can be NT credentials DOMAIN\User and the password. It's ugly if you have a password policy that forces you to change the password regularly, but it does work.
Now, since you have users directly accessing the report and are scheduling it, I would recommend you create two data sources and use the one with hard-coded credentials just for the scheduled report. That way, you still have the user-by-user security for your cube when they are accessing the report directly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply