Damilola's Blog on Ease of Administration


UPGRADING SQL 2008 SP1 TO SQL 2008 R2 WITH SCOM 2007 R2 ALREADY DEPLOYED
September 28, 2010, 10:42 am
Filed under: SCOM, SQL | Tags: ,

Recently I was saddled with the task of upgrading our SQL 2008 SP1 server to SQL 2008 R2. Here is what I did;
TASKS

PRE-UPGRADE
1. Install and run SQL Server 2008 R2 upgrade advisor on the server
2. Based on the analysis report from the upgrade advisor, make corrections and re-run the upgrade advisor.
Issues Encountered and Resolution
1. Custom security and authentication extensions were detected; the effect of this was that the upgrade would be blocked. In order to resolve this, the security and authentication entries in the report services configuration file were removed and placed in a text file.
2. Custom data processing and report items extensions were discovered; the effect of this is that the upgrade can be done but the custom extensions would have to be manually moved from the old installation file to the new installation file

UPGRADE
1. Run the setup file from the disk or shared directory and on the installation center page, select planning menu and select system configuration checker (this helps to ensure that the system requirements are adequate)
2. Select Installation menu and select upgrade from SQL 2000, 2005, 2008
3. After the support files are installed a restart is required though the upgrade can continue and the server can be restarted after the upgrade is complete.

POST UPGRADE
1. Update the reporting server configuration file with the security and authentication entries copied out before the upgrade. This enables the Operations manager reporting server function again.
2. Move all extensions present in the old bin folder of the old report server installation to the bin folder of the new reporting server.

LESSONS LEARNT
Ensure to run the upgrade advisor first in order to help plan your upgrade. 🙂