Change ReportServer database

We have installed Reporting Services on a new server using the local
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
RickIn SQL 2005:
Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
Tools/Reporting Services Configuration
This will open the Reporting Services Configuration Manager. Choose
"Database Setup" from the left column and set the server and database name.
In SQL 2000 run the following (see
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
-p<password>
<ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
authentication of the service account SQLRS will use to connect to the
ReportServer database <UserName> & <Password> is the name/password of the
service account mentioned above.
Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
rsconfig can be found in the C:\Program Files\Microsoft SQL
Server\80\Tools\Binn folder.
This assumes that the report services db is a restore of the original. If
it's different then it get's a little more complicated as encryption keys and
versions need to match.
"Rick" wrote:
> We have installed Reporting Services on a new server using the local
> database. Now we want to point to a ReportServer database on another
> database server.
> How can we change the server used for the ReportServer database to point to
> a different server?
> Thanks
> --
> Rick|||Thanks.
--
Rick
"Limey" wrote:
> In SQL 2005:
> Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
> Tools/Reporting Services Configuration
> This will open the Reporting Services Configuration Manager. Choose
> "Database Setup" from the left column and set the server and database name.
> In SQL 2000 run the following (see
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
> rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
> -p<password>
> <ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
> authentication of the service account SQLRS will use to connect to the
> ReportServer database <UserName> & <Password> is the name/password of the
> service account mentioned above.
> Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
> rsconfig can be found in the C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
> This assumes that the report services db is a restore of the original. If
> it's different then it get's a little more complicated as encryption keys and
> versions need to match.
>
>
> "Rick" wrote:
> > We have installed Reporting Services on a new server using the local
> > database. Now we want to point to a ReportServer database on another
> > database server.
> >
> > How can we change the server used for the ReportServer database to point to
> > a different server?
> >
> > Thanks
> > --
> > Rick