I need to move the report manager from one computer to another computer.
Currently the RS database is on a db server, separate from the report
manager. This will stay the same. I need to know what the steps are for
moving the Report Manager to this new server, and keep all my
folders/schedules intact.Hello dachrist,
The first step would be to install Reporting Services on the new server. If
you are installing Standard Edition you can not choose the database during
the installation, however, you can use a combination of two command line
utilities to connect to the existing database post install. These are:
rsconfig and rsactivate. rsconfig sets the connection information to the
database and a basic syntax would be:
rsconfig -c -s DBServerName -d ReportServer -a SQL -u SQLUsername -P
Password
The "-d" option specifies the ReportServer database and "-a" sets the
authentication type to SQL authentication. rsconfig will be run on the new
Reporting Services Server.
You then run rsactivate on the dbserver to activate the new Reporting
Services Server you just installed, what you referred to as the Report
Manager. .
rsactivate -m NewReportingServicesServer -u Username -p Password
Username and Password will be the Windows account with administrative
priveleges to the Reporting Services Web Service.
I hope this helps.
Rodney Landrum
Author : "Pro SQL Reporting Services" (Apress)
www.apress.com
"dachrist" <dachrist@.discussions.microsoft.com> wrote in message
news:5FAE2190-1179-4FE6-BA4D-FB552C6D9D8F@.microsoft.com...
>I need to move the report manager from one computer to another computer.
> Currently the RS database is on a db server, separate from the report
> manager. This will stay the same. I need to know what the steps are for
> moving the Report Manager to this new server, and keep all my
> folders/schedules intact.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment