Does anyone know the steps to move the SQL RS web services front-end? The
back-end database will stay in its current location.
Thanks,
DougTake a look at this article:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
erik perez
www.solien.com
"Doug Lott" <dlott@.rmahomeservices.com> wrote in message
news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> Does anyone know the steps to move the SQL RS web services front-end? The
> back-end database will stay in its current location.
> Thanks,
> Doug
>|||This article does a great of explaining how to move the web service to
another website on the same server, but I need to move the whole front-end
installation including the windows service to another server entirely.
Thanks,
Doug
"erik perez" <erik.nojunkmail.at.solien.com> wrote in message
news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> Take a look at this article:
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> --
> erik perez
> www.solien.com
> "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > Does anyone know the steps to move the SQL RS web services front-end?
The
> > back-end database will stay in its current location.
> >
> > Thanks,
> >
> > Doug
> >
> >
>|||I would imagine it would probably be best to use the RS Installer to install
Reporting Services on the new server just like you installed the original
server. Make sure you backup your ReportServer and ReportServerTempDB
databases, and also make copies of your configuration files and encryption
key in case you need them. Also, you should note that installing Reporting
Services on a server separate from where the SQL Server database resides
will require you have an additional SQL Server license.
--
erik perez
www.solien.com
"Doug Lott" <dlott@.rmahomeservices.com> wrote in message
news:eY4GMQ0lEHA.3544@.TK2MSFTNGP15.phx.gbl...
> This article does a great of explaining how to move the web service to
> another website on the same server, but I need to move the whole front-end
> installation including the windows service to another server entirely.
> Thanks,
> Doug
> "erik perez" <erik.nojunkmail.at.solien.com> wrote in message
> news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> > Take a look at this article:
> >
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> >
> > --
> > erik perez
> > www.solien.com
> >
> > "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> > news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > > Does anyone know the steps to move the SQL RS web services front-end?
> The
> > > back-end database will stay in its current location.
> > >
> > > Thanks,
> > >
> > > Doug
> > >
> > >
> >
> >
>|||Erik is correct. This is the easiest way to move the report server. Trying
to do it manually is possible but not trivial. The biggest gotcha would be
if you point to the existing database during setup. If you are planning on
doing this then setup will think you are joining a web farm, as long as the
original machine is still running then everything should be fine, if it is
not then you will fail to activate. The other option is to install the new
RS pointing to a new DB. Once the install is complete use RSConfig.exe to
point to the old database. You will also need to run rskeymgmt to extract
the key from the old RS and import it into the new RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"erik perez" <erik.nojunkmail.at.solien.com> wrote in message
news:eOdHdZ0lEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I would imagine it would probably be best to use the RS Installer to
install
> Reporting Services on the new server just like you installed the original
> server. Make sure you backup your ReportServer and ReportServerTempDB
> databases, and also make copies of your configuration files and encryption
> key in case you need them. Also, you should note that installing
Reporting
> Services on a server separate from where the SQL Server database resides
> will require you have an additional SQL Server license.
> --
> erik perez
> www.solien.com
> "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> news:eY4GMQ0lEHA.3544@.TK2MSFTNGP15.phx.gbl...
> > This article does a great of explaining how to move the web service to
> > another website on the same server, but I need to move the whole
front-end
> > installation including the windows service to another server entirely.
> >
> > Thanks,
> >
> > Doug
> >
> > "erik perez" <erik.nojunkmail.at.solien.com> wrote in message
> > news:eTO52F0lEHA.1672@.TK2MSFTNGP14.phx.gbl...
> > > Take a look at this article:
> > >
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> > >
> > > --
> > > erik perez
> > > www.solien.com
> > >
> > > "Doug Lott" <dlott@.rmahomeservices.com> wrote in message
> > > news:OMDdED0lEHA.712@.TK2MSFTNGP09.phx.gbl...
> > > > Does anyone know the steps to move the SQL RS web services
front-end?
> > The
> > > > back-end database will stay in its current location.
> > > >
> > > > Thanks,
> > > >
> > > > Doug
> > > >
> > > >
> > >
> > >
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment