Friday, March 30, 2012

Reporting Services SQL 2005 x64 standard edition

Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005?

Thanks

Francois

Hello Francois,

SQL Server Reporting Services 2005 is a part of SQL Server 2005 and Data Driven Subscriptions are part of 2005 Enterprise Edition(http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx). From Books On Line (BOL) "Server components require a SQL Server license. You must have a valid SQL Server license for any computer on which you install a Reporting Services server component (http://technet.microsoft.com/en-us/library/ms143238.aspx)." So the Microsoft solution is to get Enterprise Edition.

However, I came accross this article by Jason Selburg which claims to allow you to build your own data driven subscriptions using Standard Edition: http://www.sqlservercentral.com/columnists/jselburg/datadrivensubscriptions.asp

Good luck,

Larry

|||

Oops, found a more recent article by the same author:

http://www.sqlservercentral.com/columnists/jselburg/2824.asp

that appears to be much more robust.

Larry

|||

Thank you for your reply. Aplogies for only responding now.

No comments:

Post a Comment