Problem Installing SP1 in Web Farm

I have some concerns about the install process outlined in the readme for SP1. The readme indicates that the database server (the server hosting the ReportServer database) should be upgraded first.
â'The order in which you apply SP1 is important. You must first apply SP1 to the server that hosts the report server database (this updates the database format to the SP1 version). Once you update the database, you can update the report server nodes in any order.â'
My infrastructure looks like this ->
Server 1 & 2 : 2 node NLB running Reporting Services
Server 3: SQL Server 2000 server hosting the ReportServer database (no RS components)
When I install SP1 on the database server (it is not running any RS components â' just hosting the ReportServer database) the install fails with the following error ->
â'The upgrade patch cannot be installed by the windows installer services because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program.â'
When the install on the database server failed, I went ahead and installed SP1 on the servers running Reporting Services â' The install completed and Reporting Services shows the appropriate version number (8.00.878.00) but I didnâ't see any splash screens indicating that the database was being upgraded (as I have when I have applied SP1 on machines running both SQL Server and Reporting Services).
Has anyone had a similar experience upgrading the database server, either in a web farm scenario or a two-server (RS: Server1, SQL: Server2) scenario?
Has anyone successfully implemented SP1 on a SQL Server that is not running any RS components?
Thanks,
MarkThe readme seems to be a little confusing. You can only run setup on
machines that RS is installed on, because your DB resides on a separate
machine you do not need to run SP1 setup on this machine.
Here is a good way to upgrade SP1 on a farm.
Turn off the other nodes (turn off IIS and the ReportServer windows service)
Run SP1 install on the one machine that still has IIS and the ReportServer
service running. This will upgrade the DB.
Hitting the vroot for this machine should now work
For each machine in the farm:
Turn on IIS and the ReportServer service
Run sp1 setup
Ensure machine is working properly
Following these steps you will be able to upgrade your farm.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:CAF2DC91-11C5-4E76-8ED9-FC99824E6D9F@.microsoft.com...
> I have some concerns about the install process outlined in the readme for
SP1. The readme indicates that the database server (the server hosting the
ReportServer database) should be upgraded first.
> "The order in which you apply SP1 is important. You must first apply SP1
to the server that hosts the report server database (this updates the
database format to the SP1 version). Once you update the database, you can
update the report server nodes in any order."
> My infrastructure looks like this ->
> Server 1 & 2 : 2 node NLB running Reporting Services
> Server 3: SQL Server 2000 server hosting the ReportServer database (no RS
components)
> When I install SP1 on the database server (it is not running any RS
components - just hosting the ReportServer database) the install fails with
the following error ->
> "The upgrade patch cannot be installed by the windows installer services
because the program to be upgraded may be missing, or the upgrade patch may
update a different version of the program."
> When the install on the database server failed, I went ahead and installed
SP1 on the servers running Reporting Services - The install completed and
Reporting Services shows the appropriate version number (8.00.878.00) but I
didn't see any splash screens indicating that the database was being
upgraded (as I have when I have applied SP1 on machines running both SQL
Server and Reporting Services).
> Has anyone had a similar experience upgrading the database server, either
in a web farm scenario or a two-server (RS: Server1, SQL: Server2) scenario?
> Has anyone successfully implemented SP1 on a SQL Server that is not
running any RS components?
> Thanks,
> Mark
>|||Thanks Daniel
So even though I donâ't see an â'upgrading databaseâ?¦â' dialog box during SP1 install on the first node â' I can assume that the upgrade has taken place?
Is there anything I can check in the ReportServer db to confirm?
Thanks,
Mark
"Daniel Reib [MSFT]" wrote:
> The readme seems to be a little confusing. You can only run setup on
> machines that RS is installed on, because your DB resides on a separate
> machine you do not need to run SP1 setup on this machine.
> Here is a good way to upgrade SP1 on a farm.
> Turn off the other nodes (turn off IIS and the ReportServer windows service)
> Run SP1 install on the one machine that still has IIS and the ReportServer
> service running. This will upgrade the DB.
> Hitting the vroot for this machine should now work
> For each machine in the farm:
> Turn on IIS and the ReportServer service
> Run sp1 setup
> Ensure machine is working properly
> Following these steps you will be able to upgrade your farm.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
> news:CAF2DC91-11C5-4E76-8ED9-FC99824E6D9F@.microsoft.com...
> > I have some concerns about the install process outlined in the readme for
> SP1. The readme indicates that the database server (the server hosting the
> ReportServer database) should be upgraded first.
> >
> > "The order in which you apply SP1 is important. You must first apply SP1
> to the server that hosts the report server database (this updates the
> database format to the SP1 version). Once you update the database, you can
> update the report server nodes in any order."
> >
> > My infrastructure looks like this ->
> >
> > Server 1 & 2 : 2 node NLB running Reporting Services
> > Server 3: SQL Server 2000 server hosting the ReportServer database (no RS
> components)
> >
> > When I install SP1 on the database server (it is not running any RS
> components - just hosting the ReportServer database) the install fails with
> the following error ->
> >
> > "The upgrade patch cannot be installed by the windows installer services
> because the program to be upgraded may be missing, or the upgrade patch may
> update a different version of the program."
> >
> > When the install on the database server failed, I went ahead and installed
> SP1 on the servers running Reporting Services - The install completed and
> Reporting Services shows the appropriate version number (8.00.878.00) but I
> didn't see any splash screens indicating that the database was being
> upgraded (as I have when I have applied SP1 on machines running both SQL
> Server and Reporting Services).
> >
> > Has anyone had a similar experience upgrading the database server, either
> in a web farm scenario or a two-server (RS: Server1, SQL: Server2) scenario?
> >
> > Has anyone successfully implemented SP1 on a SQL Server that is not
> running any RS components?
> >
> > Thanks,
> > Mark
> >
>
>