?
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
Medium Priority
?
167 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 53

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 53

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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
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…

839 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