We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"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. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.
I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.
I hope this help all of you.
Saludos desde el sur del mundo.|||
What screen are you configuring the data source? I can't find the button you are referring to.
No comments:
Post a Comment