Move RS database to a new computer

we are aware of KB84245 Titled:
"How to move a Reporting Servides database from a computer that is running
Reporting Services to another computer".
this seems rather clear. But I have I a question.
Does this article assume the original DB is on the web server machine, and
if so would these
exact instructions apply to mvoing a database in a multi-tier arrangement.
By which I mean: in our case we have a Web Server and a Database Server.
The Web Server Hosts ReportingSservices and the Database Server hosts the
ReportingService DBs. We are moving our reportingservice DB to a different
database server.
are there additional/different instructions I should follow for a move in a
multi-tier arrangement? Are is this KB good to go for all situations?
thanks.
dlrHi Dennis,
I just successfully moved a RS database to a new server in a 2-tiered
environment, and the MS instructions worked perfectly. I backed up the 2
dbs to files, then restored them to the new db server. Then on the IIS
machine, I used rsconfig utility to reconfigure the db location/connection
info. I moved the reportserver component to a new IIS machine as well, so I
had to backup/restore the encryption keys, too - but I don't think you'll
have to do that, as you're not moving the reportserver.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Dennis Redfield wrote:
> we are aware of KB84245 Titled:
> "How to move a Reporting Servides database from a computer that is
> running Reporting Services to another computer".
> this seems rather clear. But I have I a question.
> Does this article assume the original DB is on the web server
> machine, and if so would these
> exact instructions apply to mvoing a database in a multi-tier
> arrangement.
> By which I mean: in our case we have a Web Server and a Database
> Server. The Web Server Hosts ReportingSservices and the Database
> Server hosts the ReportingService DBs. We are moving our
> reportingservice DB to a different database server.
> are there additional/different instructions I should follow for a
> move in a multi-tier arrangement? Are is this KB good to go for all
> situations?
> thanks.
> dlr|||well i did have problems. I moved the RS databases to a new server (which
was a clean SQL Server install with no prior RS history). and indeed
everything seemed to work fine until I got permission errors when attempting
a snap-shot execution. The problem:
RS creates an RSExecRole in the databases it creates AND in the master
database and adds your connection user to those roles. On the databases
moved to the new server theRSExecRole move along with the restore. The
master database on the new machine is not restored from anywhere, of course,
and thus IT DOES NOT HAVE THE RSExecRole. If you are using the prinicple of
least previlge and use a RS database connection user with few intrinsic
rights you will see the permission error. Solution: manually create the
RSExecRole in "master" and manually add your connection user to this role.
Easy but not fun in a disaster recovery situation.
dlr
"Jake Marx" <msnews@.longhead.com> wrote in message
news:OPxDc7PvEHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi Dennis,
> I just successfully moved a RS database to a new server in a 2-tiered
> environment, and the MS instructions worked perfectly. I backed up the 2
> dbs to files, then restored them to the new db server. Then on the IIS
> machine, I used rsconfig utility to reconfigure the db location/connection
> info. I moved the reportserver component to a new IIS machine as well, so
I
> had to backup/restore the encryption keys, too - but I don't think you'll
> have to do that, as you're not moving the reportserver.
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> Dennis Redfield wrote:
> > we are aware of KB84245 Titled:
> > "How to move a Reporting Servides database from a computer that is
> > running Reporting Services to another computer".
> >
> > this seems rather clear. But I have I a question.
> >
> > Does this article assume the original DB is on the web server
> > machine, and if so would these
> > exact instructions apply to mvoing a database in a multi-tier
> > arrangement.
> >
> > By which I mean: in our case we have a Web Server and a Database
> > Server. The Web Server Hosts ReportingSservices and the Database
> > Server hosts the ReportingService DBs. We are moving our
> > reportingservice DB to a different database server.
> >
> > are there additional/different instructions I should follow for a
> > move in a multi-tier arrangement? Are is this KB good to go for all
> > situations?
> >
> > thanks.
> >
> > dlr
>