Moving RS to new Hardware

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.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?
"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.
>>
>|||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.
>>
>>
>|||Thanks, good point; that's what I will do.
"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.
>>
>>
>>
>