sql server reporting services: We currently have SQL Reporting Services 2000 (version 8.00.1042.00) in which
we have access to data driven subscriptions. We only have SQL Server 2000
standard.

In setting up a new server with SQL Server 2005 and SQL Reporting 2005
(version 9.00.1399.00) we do not have access to data driven subscriptions. I
assume this is because the SQL Server 2005 DVDs we have are for the standard
version and therefore SQL Reporting Services packaged with it is also the
standard version.

I presume there is no reason why you could not use SQL Reporting Services
2005 enterprise version with SQL Server 2005 standard, but do we need a SQL
Server 2005 enterprise licence to be able to do this, or can we just upgrade
SQL Reporting Services 2005, which I presume will be much cheaper?

Thanks

--

First, the fact that you had data driven subscriptions with SQL Server 2000
standard meant that you were in violation of the license. Data driven
subscriptions are an enterprise feature for which (regardless of whether you
can install it or not) requires an enterprise license. Same is true with RS
2005. Note that there is no separate license for RS 2005 (or 2000 for that
matter). RS is part of SQL Server and requires that version of SQL Server
license.

As far as upgrading, I don't know about upgrade costs. What I do know is
there is no such thing as a RS upgrade, you are upgrading SQL Server. Note
that you can buy a SQL Server 2005 license, leave SQL Server at 2000 and
just upgrade RS 2005 (that is what I have done). But, you have the right to
upgrade everything to 2005 and are just choosing to upgrade RS.

Licensing works this way, whatever box has RS installed needs a SQL Server
license for it. So if you have a web farm with say 3 IIS servers running RS
and the database used for metadata/object caching is on another server you
need a total of 4 SQL Server server licenses. In this case (since web farm
is an enterprise license) you need enterprise.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce

You say are running RS 2005 with SQL 2000 but I thought you could not create
reports for SQL 2000 with RS 2005? Can you clarify? thanks

SQL Server 2000 is the metadata/object cache for my RS 2005. RS 2005 is a
asp.net 2.0 application. It does not even have to be on the same box as the
database (but if you do that you still need a SQL Server license for the IIS
box running RS). SQL Server Database can be either 2000 or 2005 and RS 2005
can use it for its object store. You cannot create RS 2000 reports with RS
2005, that is different from what I am saying above.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]