sql server reporting services: Licencing question -- sql server reporting services

Licencing question

Eric Le Bouffon
3/17/2006 2:29:32 AM

sql server reporting services: We have several SQL servers 2000 in production.
I would like to introduce SQL Server 2005 Reporting Services but
without upgrading the existing servers.

What is the cheapest option to install one SQL Server 2005 Server
instance to use it's Reporting Services feature (accessing the SQL 2000
databases) in an intranet context?
We would have a few thousands potential end users through IE.
I don't expect much traffic though and the databases queried are very
small: single processor machine would do, for instance.

Cheers

Eric

Re: Licencing question

Bruce L-C [MVP]
3/19/2006 9:01:03 PM

If you want to use one of your existing 2000 boxes for the metadata/object
store you can do that. The object store can be either local to the server
running RS or it can be remote. The metadata/object store database can be
either 2000 or 2005. For whatever server running RS you need to have a SQL
Server license. I suggest SQL Server Standard. There are very few feature
differences (data driven subscriptions and web farm support are the two
biggest differences). If you need either of these then upgrade at that time.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]