Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Data Driven Subscription Disabled

Hi All,

We are using SQL Server 2005 enterprise edition for our project with SSRS 2005.

We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled.

We have ensured the following:

1- The server is enterprise edition with SP1

2- The users are part of local admin group on the report server

3- The report credentials are stored in the database.

Is there anything missed out?

Thank

Manish

Did you ever get an answer to this? We are having the same thing going on. Are you using integrated security or just Windows?|||

I guess Data Driven Subscription button is not disabled but you're getting error message if it's pressed. Correct? Make sure your report does not contain expressions depending on user like User!UserID. See http://msdn2.microsoft.com/en-us/library/ms156012.aspx for all DD subscription creation guidelines.

|||

No, the Data Driven Subscription button is disabled. I have through the tutorial about4 times. We use the Developer edition and the SQL Server Agent is running. I have also set up the datasource as instructed.

Any other ideas?

Thanks,

SP

|||

I know we installed the Developer edition, but when I use select @.@.version, it says only standard edition. We installed it through the MSDN subscription CD Disc 3097.1

Is there another way to tell what version you have?

Thanks,

SP

Daily scheduled job has its schedule disabled despite successful completion

I have a job which is scheduled to run once daily. The job is enabled and the schedule is also enabled. After the job runs (successfully), the schedule has its 'Enabled' flag reset (i.e. the 'Enabled' checkbox in the schedule properties has become unchecked) and so is not rescheduled.

I have other jobs configured in a similar way, but they are run and then rescheduled in the normal way without any problems.

What could be going on?I'm sure you'd know but there is definately no disables step in the job?
e.g
EXEC sp_update_job @.job_name = 'bla bla',
@.enabled = 0|||This may be of some use to you. Have you checked the logs?

http://support.microsoft.com/default.aspx?scid=kb;en-us;295378&Product=sql2k