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
145 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
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
I performed my self with mentioned steps in the solution and found that migration was done smoothly without any issues.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Several part series to implement Internet Explorer 11 Enterprise Mode
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
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 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now