Cannot create data-driven subscription

Hi,

I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).

When I try and click on on the DDS button for a report I get the following message:

"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."

1. I have set the data source to use stored credentials.

2. I'm using one simple string parameter

3. Its not a linked report

Any ideas?

regards,

avner

Make sure your report does not contain expressions depending on user like User!UserID.

See http://msdn2.microsoft.com/en-us/library/ms156012.aspx.

|||

thanks! that resolved the problem.

|||

Hi,

I'm having the same problem. I'm using the browser interface for SSRS and when I click on a report and go to Subscriptions, the buttons for New Subscription and Data-driven Subscription have warning icons, and when I click on either I get the same message as above.

The report already has a data-driven subscription which was working fine. I haven't made any changes to the report. This problem is affecting all reports. What has changed is the data source (now pointing to a different database), which is using "Credentials stored securely on the server" and "Use as Windows credentials..." and "Impersonate the authenticated user..." both checked.

Is there some security setting being cached in the reports? Do I need to update the reports in some way to make them work with the updated data source?

Regards,

Greg

|||

Answering my own question, the problem was the "Impersonate the authenticated user..." option. When I unchecked this for the data source I was able to create subscriptions.

Regards,

Greg