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
149 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 46

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 46

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

863 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

23 Experts available now in Live!

Get 1:1 Help Now