Saturday, February 25, 2012

RS App tier vs. SQL DB tier, mixing cumulative updates

Does anyone know if it is possible or if any issues will be seen by
updating our RS app tier to a different SQL SP2 cumulative update
level than our SQL DB tier? A higher cumulative update obviously.
Currently our AppTier is SSRS 2005 SP2 and our DB tier is SQL 2005
SP2.
Thanks,
KelI don't see any issue at all. You can have the metadata/object cache on SQL
2000. If RS doesn't care if the database is 2000 it sure wouldn't care if it
a slightly different SQL 2005.
I ran for 6 months with RS 2005 using SQL 2000 so I know this works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kelkoenig@.gmail.com> wrote in message
news:5349c98e-88d6-4347-b209-338c246b7597@.e23g2000prf.googlegroups.com...
> Does anyone know if it is possible or if any issues will be seen by
> updating our RS app tier to a different SQL SP2 cumulative update
> level than our SQL DB tier? A higher cumulative update obviously.
> Currently our AppTier is SSRS 2005 SP2 and our DB tier is SQL 2005
> SP2.
> Thanks,
> Kel

No comments:

Post a Comment