Currently we have SQL server reporting services running on a win 2000 server
running IIS. I need to move the reporting services to a new server running
win 2003 w/ IIS. How do I go about installing this on the new server and
keeping the old settings and reports.
thanks
mikeSimulate a Farm installation , then de-activate the first node.
1. Install another Reporting Services on the new server, pointing to the
existing SQL Server repository. When setup is complete, you should see all of
your reports through that server, since the repository (database) is the
same. During the install , you will be taken through a (web farm) setup
screen that is slightly different then a regular stand-alone install. On that
screen you have to specifiy the new server . Do that.
2. after verifiing that you are able to access your reports throught the new
server via the browser, go ahead and de-activate the first node by deleting
rows 2 and 3 from the keys tables in the ReportServer database (the metabase
repository at this point will think it has only one server) , after that
restart the new report server.
3. Take the first RS sever offline. You have successfully performed the
migration.
"Mike Fremont" wrote:
> Currently we have SQL server reporting services running on a win 2000 server
> running IIS. I need to move the reporting services to a new server running
> win 2003 w/ IIS. How do I go about installing this on the new server and
> keeping the old settings and reports.
> thanks
> mike|||Note that this only works if you are using RS Enterprise (web farm does not
work with standard).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:A162A01B-ED4F-48A5-A149-6C658EACFE9A@.microsoft.com...
> Simulate a Farm installation , then de-activate the first node.
> 1. Install another Reporting Services on the new server, pointing to the
> existing SQL Server repository. When setup is complete, you should see all
of
> your reports through that server, since the repository (database) is the
> same. During the install , you will be taken through a (web farm) setup
> screen that is slightly different then a regular stand-alone install. On
that
> screen you have to specifiy the new server . Do that.
> 2. after verifiing that you are able to access your reports throught the
new
> server via the browser, go ahead and de-activate the first node by
deleting
> rows 2 and 3 from the keys tables in the ReportServer database (the
metabase
> repository at this point will think it has only one server) , after that
> restart the new report server.
> 3. Take the first RS sever offline. You have successfully performed the
> migration.
>
> "Mike Fremont" wrote:
> > Currently we have SQL server reporting services running on a win 2000
server
> > running IIS. I need to move the reporting services to a new server
running
> > win 2003 w/ IIS. How do I go about installing this on the new server
and
> > keeping the old settings and reports.
> >
> > thanks
> > mikesql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment