Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
158 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 48

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 48

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
An article on effective troubleshooting
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
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…

856 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