Tuesday, March 20, 2012

Applying SQL SP2

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
there going to be any downtime on my production server?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
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:178A9EFC-E536-4D2A-BEFE-2C2A3228893E@.microsoft.com...
>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
> there going to be any downtime on my production server?

No comments:

Post a Comment