Friday, March 23, 2012

RS2008 with SQL 2005 (different question)

Slightly different than the post before it.
If we have SQL 2005 and we don't want to upgrade to 2008 what options
do we have with regards to using RS2008? Can it be purchased
separately or something? Our reporting server is running 2005 great
but we want to benefit from the advances in RS2008 without having to
upgrade and pay a ton of money for it and take up a lot of time and
effort to upgrade everything, including the DB engine.
Thanksbased on the webcasts i have seen, I don't think RS 2008 will be available
separately.
"SQL Guy" <aymantg@.gmail.com> wrote in message
news:35ac9e28-4e09-4098-930f-9de83298236a@.w28g2000hsf.googlegroups.com...
> Slightly different than the post before it.
> If we have SQL 2005 and we don't want to upgrade to 2008 what options
> do we have with regards to using RS2008? Can it be purchased
> separately or something? Our reporting server is running 2005 great
> but we want to benefit from the advances in RS2008 without having to
> upgrade and pay a ton of money for it and take up a lot of time and
> effort to upgrade everything, including the DB engine.
> Thanks|||I don't have the definitive word on this but my guess (and I am counting on
it) will be that this will be the same as RS2005 and SQL 2000. With that
combination you could run RS 2005 and have it use SQL 2000 database for its
metadata/object caching. This was/is fully supported and I ran that way for
6 months. My guess is that RS 2008 will be similar, that it will allow SQL
2005 to be used for its metadata/object caching.
Now, as far as licensing. I am assuming no change in licensing. Today you
have to have a SQL 2005 license for whatever server is running RS. So if it
is a web farm and you have 5 web servers all using the same DB, then all 5
web servers have to have a SQL 2005 server license. If you run RS 2005 on
the same server as SQL 2000, you have to have a SQL 2005 license. You just
have the option not to upgrade the database but you still have to have a
license.
HTH,
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SQL Guy" <aymantg@.gmail.com> wrote in message
news:35ac9e28-4e09-4098-930f-9de83298236a@.w28g2000hsf.googlegroups.com...
> Slightly different than the post before it.
> If we have SQL 2005 and we don't want to upgrade to 2008 what options
> do we have with regards to using RS2008? Can it be purchased
> separately or something? Our reporting server is running 2005 great
> but we want to benefit from the advances in RS2008 without having to
> upgrade and pay a ton of money for it and take up a lot of time and
> effort to upgrade everything, including the DB engine.
> Thanks

No comments:

Post a Comment