sql server reporting services: Applying SQL SP2 -- sql server reporting services

Applying SQL SP2

Marvin
10/5/2007 11:07:02 AM

sql server reporting services:

I installed RS 2005 on a WIN 2003 64bit. I installed the RS Database on a
remote server Win 2003 32bit/SQL 2005 with sp2. I want to install SP2 to the
Report Server/Manager site on my 64 bit machine. When running the wizard on
the 64bit machine, it wants to upgrage the RS Database installed on the
remote server, but SP2 has already been applied. Am I going to encounter any
issues if i go forward? The remote RS Database is on a production server. Is

Re: Applying SQL SP2

Bruce L-C [MVP]
10/5/2007 1:24:06 PM

Keep in mind that RS 2005 can use a SQL 2000 database as well as a SQL 2005
database as the storage for its metadata/object caching. When you apply the
patch to RS it is modifying data, tables, etc in the database it uses. It is
not upgrading SQL Server to SP2. As far as downtime, it will affect RS (but
you are already affecting that since that is what you are upgrading). It
will not affect SQL Server itself.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]