RS SP2 Upgrade

Hi,
We use two IIS machine hosting each an instance of Report Server. The RS
database is located on a SQL2000 SP4 cluster where no component of RS is
installed except the RS and RSTempDB databases.
We upgraded each IIS machine and the setup completed without any errors or
warning. In the release notes for SP2, it is told that the database server
needs also to be upgraded. But there are no RS components installed on the
SQL cluster and by the way nothing to upgrade.
Is this a bug on the release notes ? Is the database upgraded by the update
process on a report server machine ?
Or do I need to do anything else to upgrade the database ? How can I check
if the database was upgraded or not ?
Thanks in advance.
SBIt sounds like you have a web farm. The process of upgrading RS will upgrade
the database.
Note that you will want to upgrade your development (report designer).
Especially if you skipped SP1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"BENHAMOU Stéphane" <BENHAMOUStphane@.discussions.microsoft.com> wrote in
message news:E26F48E0-155E-41B6-8BCF-69D4605F57BE@.microsoft.com...
> Hi,
> We use two IIS machine hosting each an instance of Report Server. The RS
> database is located on a SQL2000 SP4 cluster where no component of RS is
> installed except the RS and RSTempDB databases.
> We upgraded each IIS machine and the setup completed without any errors or
> warning. In the release notes for SP2, it is told that the database server
> needs also to be upgraded. But there are no RS components installed on the
> SQL cluster and by the way nothing to upgrade.
> Is this a bug on the release notes ? Is the database upgraded by the
> update
> process on a report server machine ?
> Or do I need to do anything else to upgrade the database ? How can I check
> if the database was upgraded or not ?
> Thanks in advance.
> SB|||Thanks for your answer.
Is there a way to check the database structure upgrade ?
I run a "select * from information_schema.columns" on an SP1 and then on the
SP2 database used by my web farm, and the number of columns is exactly the
same (206) for both versions.
Do you know what are the database structure changes ?
"Bruce L-C [MVP]" a écrit :
> It sounds like you have a web farm. The process of upgrading RS will upgrade
> the database.
> Note that you will want to upgrade your development (report designer).
> Especially if you skipped SP1.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "BENHAMOU Stéphane" <BENHAMOUStphane@.discussions.microsoft.com> wrote in
> message news:E26F48E0-155E-41B6-8BCF-69D4605F57BE@.microsoft.com...
> > Hi,
> >
> > We use two IIS machine hosting each an instance of Report Server. The RS
> > database is located on a SQL2000 SP4 cluster where no component of RS is
> > installed except the RS and RSTempDB databases.
> >
> > We upgraded each IIS machine and the setup completed without any errors or
> > warning. In the release notes for SP2, it is told that the database server
> > needs also to be upgraded. But there are no RS components installed on the
> > SQL cluster and by the way nothing to upgrade.
> >
> > Is this a bug on the release notes ? Is the database upgraded by the
> > update
> > process on a report server machine ?
> >
> > Or do I need to do anything else to upgrade the database ? How can I check
> > if the database was upgraded or not ?
> >
> > Thanks in advance.
> > SB
>
>