|
|
You're in the
sql server reporting services
group:Moving RS to new Hardware
sql server reporting services:
webfarm (which is what you say you don't want to do). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jason Wood" <jwood63@hotmail.com> wrote in message news:QnpGf.11363$915.6027@southeast.rr.com... >I have two servers, one being the SQL server with RS db, one being the > webserver with reporting services on it. I want to replace this webserver > slowly by installing reporting services on a new server but at the same > time > being able to access the reports on the old server until we take it > offline. > > Should I install RS on new server and point to the existing DB or is there > something special I will have to do to get it to work? I don't want to > create a web farm since the old server is coming offline in the next month > or so but can't do all at once. > > Thanks in advance. > >
I have two servers, one being the SQL server with RS db, one being the
webserver with reporting services on it. I want to replace this webserver slowly by installing reporting services on a new server but at the same time being able to access the reports on the old server until we take it offline. Should I install RS on new server and point to the existing DB or is there something special I will have to do to get it to work? I don't want to create a web farm since the old server is coming offline in the next month or so but can't do all at once. Thanks in advance.
I thought the issue is that you want to have two RS servers both showing the
same reports? And that you want to do this without doing a web farm. The only way to do that is to have a separate SQL Server database for the metadata. What I would do is install RS and have it have its own databases (I don't know the steps to do this when the same SQL Server is hosting two different RS remotely). Then I would just deploy the same reports to the second server and manually keep up with changes until you retire the first RS server. I have my RS and the metadata database on the same box. The data I am reporting off on is on a variety of servers. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Jason Wood" <jwood63@hotmail.com> wrote in message news:HmLGf.11467$915.8413@southeast.rr.com... > So reinstall and restore RS database and use the command tools to reset > the key? > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:u2swOiNLGHA.3944@tk2msftngp13.phx.gbl... >> You can't have two servers pointing to the same database without it being >> a webfarm (which is what you say you don't want to do). >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Jason Wood" <jwood63@hotmail.com> wrote in message >> news:QnpGf.11363$915.6027@southeast.rr.com... >>>I have two servers, one being the SQL server with RS db, one being the >>> webserver with reporting services on it. I want to replace this >>> webserver >>> slowly by installing reporting services on a new server but at the same >>> time >>> being able to access the reports on the old server until we take it >>> offline. >>> >>> Should I install RS on new server and point to the existing DB or is >>> there >>> something special I will have to do to get it to work? I don't want to >>> create a web farm since the old server is coming offline in the next >>> month >>> or so but can't do all at once. >>> >>> Thanks in advance. >>> >>> >> >> > >
So reinstall and restore RS database and use the command tools to reset the
key? [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:u2swOiNLGHA.3944@tk2msftngp13.phx.gbl... > You can't have two servers pointing to the same database without it being > a webfarm (which is what you say you don't want to do). > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jason Wood" <jwood63@hotmail.com> wrote in message > news:QnpGf.11363$915.6027@southeast.rr.com... >>I have two servers, one being the SQL server with RS db, one being the >> webserver with reporting services on it. I want to replace this >> webserver >> slowly by installing reporting services on a new server but at the same >> time >> being able to access the reports on the old server until we take it >> offline. >> >> Should I install RS on new server and point to the existing DB or is >> there >> something special I will have to do to get it to work? I don't want to >> create a web farm since the old server is coming offline in the next >> month >> or so but can't do all at once. >> >> Thanks in advance. >> >> > >
Thanks, good point; that's what I will do.
[quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:udeqjeaLGHA.140@TK2MSFTNGP12.phx.gbl... >I thought the issue is that you want to have two RS servers both showing >the same reports? And that you want to do this without doing a web farm. >The only way to do that is to have a separate SQL Server database for the >metadata. What I would do is install RS and have it have its own databases >(I don't know the steps to do this when the same SQL Server is hosting two >different RS remotely). Then I would just deploy the same reports to the >second server and manually keep up with changes until you retire the first >RS server. I have my RS and the metadata database on the same box. The data >I am reporting off on is on a variety of servers. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Jason Wood" <jwood63@hotmail.com> wrote in message > news:HmLGf.11467$915.8413@southeast.rr.com... >> So reinstall and restore RS database and use the command tools to reset >> the key? >> >> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> news:u2swOiNLGHA.3944@tk2msftngp13.phx.gbl... >>> You can't have two servers pointing to the same database without it >>> being a webfarm (which is what you say you don't want to do). >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> "Jason Wood" <jwood63@hotmail.com> wrote in message >>> news:QnpGf.11363$915.6027@southeast.rr.com... >>>>I have two servers, one being the SQL server with RS db, one being the >>>> webserver with reporting services on it. I want to replace this >>>> webserver >>>> slowly by installing reporting services on a new server but at the same >>>> time >>>> being able to access the reports on the old server until we take it >>>> offline. >>>> >>>> Should I install RS on new server and point to the existing DB or is >>>> there >>>> something special I will have to do to get it to work? I don't want to >>>> create a web farm since the old server is coming offline in the next >>>> month >>>> or so but can't do all at once. >>>> >>>> Thanks in advance. >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |