March 6, 2008 at 10:35 am
I've managed to get completely confused.
What's the implications of running 2005 SSRS only, on a server, with the metadata databases on another SQL 2000 server? It's currently how it's run, with SSRS Standard.
I've been asked about licensing and cost to upgrade this SSRS installation to Enterprise to use Data Driven Subscriptions. Won't that require a SQL 2005 Enterprise backend?
We're already running a licensed SQL 2005 Enterprise server elsewhere, aren't we covered to use SSRS Enterprise on another server?
Have I even put this question in the correct Forum? :hehe::unsure:
--------
[font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]
March 6, 2008 at 11:12 am
Per SQL 2005 licensing: running ANY component of SQL Server 2005 on a given server requires that that server be fully licensed for SQL 2005.
Meaning - it really doesn't matter that SSRS 2005 happens to be connecting to 2000 to get some or all of its data. It needs to be licensed to accomodate however many report users you need.
If you intend to use the SSRS capabilities for Enterprise - then that's what needs to be purchased server-license-wise.
Here's one of the "big" documents used to explain all of this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 7, 2008 at 7:24 am
Thanks Matt, that's perfect, exactly what I was looking for!
Rob.
--------
[font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply