SQL 2005 Reporting Services - Scheduling

Question

SQL 2005 Reporting Services - Scheduling

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 1

this maybe useful too:

http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/cc2bbf01-4eef-4a42-8c3e-aa41b78b6387/

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.