December 11, 2008 at 11:49 pm
I have an Enterprise 64 bit installation of SQL Server 2005. I'd like to create a Data Driven Subscription for a reporting services report but the option to do this is disabled in Management Studio (see attachment).
I can, however, create subscriptions for other reports in the same SSRS project. As far as I can see, the option is disabled for all reports that have an OLAP data source. Does this have to do with the fact that I am using Windows Authentication when connecting to the cube and a SQL user for the database reports? If so, how do I change the report's connection information so that the subscription option will become enabled?
December 24, 2008 at 2:54 am
Right, got it working. Had to change the data source from using Windows integrated security to Credentials stored securely on the report server. I also checked the Use as Windows credentials when connecting to the data source.
I was then able to create my data-driven subscriptions without further hassle.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply