Solved

inplace  and side by side upgrade  from windows 2003 64 bit R2  contains SSRS 2008 R2 to windows 2008 64 bit

Posted on 2014-12-17
5
153 Views
Last Modified: 2015-01-12
Hello All,

Case 1 -In place upgrade
I would like to do in place upgrade from windows 2003 64 bit R2 that contains SSRS 2008 to windows 2008 R2 64 bit. The upgrade would be happened at OS level not at SSRS level.
I would like to know what are the  necessary steps should be taken  prior/during/post  upgrade from SSRS end  as we can not rollback if there is some issue with in place upgrade.

Case 2-Side by side upgrade

I would like to do side by side migration from windows 2003 32 bit  that contains SSRS 2008 to windows 2008 R2 64 bit. The side by side  would be happened at both OS level and  SSRS level.
I would like to know what are the  necessary steps should be taken  prior/during/post side by side migration  from SSRS end.



Thanks in advance
0
Comment
Question by:chandradineshbabu
  • 2
  • 2
5 Comments
 
LVL 1

Expert Comment

by:Ajay Kumar Burra
ID: 40506536
Let Check whether you are updating on 32 or 64 bit Windows 2003 with 2008 R2. you are mentioning Inline and Side by side, what it mean? In both the installations either inplace upgrade or Side by Side upgrade the installation steps are similar. First OS will get updated with the latest version and applications which are compatible will run asusally. In services you check for the applications which are manually configured. For SSRS check whether the service is stopped or run as Automatic after upgrade. Might be there will be the compatible issue will SSRS then go for SSRS 2008 R2.
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40506782
In place upgrade should runs fine and smoothly. It won't have any kind of impact in SSRS but the downtime period.

For a side by side upgrade you need to perform reports migrations and also change the pointers in all application to run the reports from the new SSRS server. A side by side upgrade should be performed only if your old server doesn't has more free resources (hardware renewing).
0
 

Accepted Solution

by:
chandradineshbabu earned 0 total points
ID: 40508514
Thanks for the reply,

For side by side my migration, what needed to be migrated ?

As per my knowledge

1.ReportDB,ReportTempDB need to be backed up and restored on new  database server
2.Back up the encryption key on old server with password and restored on new server with the same password
     If the encryption key was not backed up on old server, Do we really need encryption key backup and restore   procedure?
If the encryption key had already been backed up by some one but they did not share the password, what are the steps should be followed during the SSRS configuration on new server?
3.Config files migration
    do we really require config miles migration?

Beside above 3 steps, are there any steps need to be performed?
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40508668
I'm not a SSRS expert but MSSQL engine only. I already helped to migrate some SSRS but only had the task #1 (migrate the databases) and really don't know what my colleagues did in their tasks.
0
 

Author Closing Comment

by:chandradineshbabu
ID: 40543997
I performed my self with mentioned steps in the solution and found that migration was done smoothly without any issues.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question