Error with SRSUpgradeTool.exe /PostUpgrade when attempting to upgrade an OpsMgr R2 SQL 2005 Reporting Server installation to SQL 2008


fixWhen following the steps of this article, http://technet.microsoft.com/en-us/library/dd789004.aspx, in order to upgrade your SQL reporting server from SQL 2005 to SQL 2008, you may encounter the problem described below.


In step 4 you run SRSUpgradeTool /PostSQLUpgrade and receive the following error:


D:\SupportTools\i386>srsupgradetool.exe /InstanceName:MSSQLSERVER /Action:PostSQLUpgrade
Microsoft System Center Operations Manager 2007 R2 — Upgrade SQL Reporting Server Preparation Tool
(C) Copyright 2000-2006 Microsoft Corp.


getSQLInstanceVersion: SRS Server is: XXXX.
getSQLInstanceVersion: SRS Instance is: MSSQLSERVER
getSQLInstanceVersion:  Actual SRS reg location is: SOFTWARE\Microsoft\Microsoft
SQL Server\MSRS10.MSSQLSERVER\Setup
SQL Instance reg location is MSRS10.MSSQLSERVER
SRS version is 10.0.1600.22
SRS Report Server folder is C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\.
Error: Failed while updating registry entry for reporting code MSI component


We have investigated and discovered there is a problem with the tool that may result in this error. We are currently working on correcting this and will release an updated tool shortly.


In the meantime, when you arrive at this point in the process, you can run the script below to carry out the task the tool was intended to complete at this stage.


Two VERY IMPORTANT points to note about this, if you have a 32-bit version of SQL installed on a 64 bit operating system then you will also need to edit the following line in the script to point to the correct registry location for the installation:


strRegBase  = “HKLM\SOFTWARE\ Wow6432Node\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\”


Also verify the location you have installed SQL 2008 Reporting Services to, and edit the following line if necessary.


strSRSbinFolder = “c:\program files\microsoft sql server\msrs10.mssqlserver\reporting services\reportserver\bin\”


Then save this script as a .vbs and run it to update the necessary registry keys:


‘=====================================================================================================


Option Explicit
Dim arrRegStrings(6,1)
Dim strRegBase, strR2Key, strSRSBinFolder
Dim I
Dim objShell, objFSO
strRegBase  = “HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\”
strR2Key = “C774AFD18AAA3114EBCA5E953978F85A”
strSRSBinFolder = “c:\program files\microsoft sql server\msrs10.mssqlserver\reporting services\reportserver\bin\”
arrRegStrings(0,0) = “7AB1BACE5F90C6047890E5A6EB081BD0”
arrRegStrings(0,1)  = “Microsoft.EnterpriseManagement.Reporting.Code.dll”
arrRegStrings(1,0)  = “D501522B1B6B9414CBAE65864C764271”
arrRegStrings(1,1)  = “Microsoft.EnterpriseManagement.Reporting.Security.dll”
arrRegStrings(2,0)  = “5AC8C0B2A77020E49924D2CF21976972”
arrRegStrings(2,1)  = “MicrosoftRSChart.dll”
arrRegStrings(3,0)  = “E983A6E6D27CA9A418F41317865692B3”
arrRegStrings(3,1)  = “Datawarehouse.RC1.Upgrade.sql”
arrRegStrings(4,0)  = “F1B8973016D3BDC4D8746A17464A3B40”
arrRegStrings(4,1)  = “MicrosoftRSChartDesigner.dll”
arrRegStrings(5,0)  = “CE0F03E70BC70A14185846E5E5A7C412”
arrRegStrings(5,1)  = “Datawarehouse.SP1.Upgrade.sql”
arrRegStrings(6,0)  = “C1E0F4463F705934CB07176DACAA4393”
arrRegStrings(6,1)  = strSRSBinFolder
set objShell = createobject(“WScript.Shell”)
‘Do regpath check
On Error Resume Next
objShell.RegRead strRegBase & arrRegStrings(0,0) & “\”
If Err then
                WScript.Echo “Base Registry Path incorrect please edit strRegBase to point to the correct registry location”
                WSCript.Quit 1
End If
On Error Goto 0
‘Do filepathcheck
Set objFSO = CreateObject(“Scripting.FileSystemObject”)
If Not(objFSO.FolderExists(strSRSBinFolder)) then
                WScript.Echo “SRS Install binary path incorrect. Please edit strSRSBinFolder to point to the correct folder location”
                WSCript.Quit 1
End If
On Error Goto 0
For I = 0 to UBound(arrRegStrings)
                objShell.RegWrite strRegBase & arrRegStrings(I,0) & “\” & strR2Key, strsrsbinFolder & arrRegStrings(I,1), “REG_SZ”
Next
WScript.Echo “Finished Registry Updates”


‘=====================================================================================================


Brian McDermott | Escalation Engineer

Comments (4)

  1. phoc says:

    In CU1 for SCOM 2007 R2 you can find SRSUpgradeTool  which solved the problem in my case.

    The script failed.

  2. Curtiss says:

    what happens if i get " Failed while updating registry entry for reporting code MSI component" when upgrading from sql 2008 sp3 to sql 2008 r2? do i need to point the script at the installation folder for R2 reporting?

  3. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application

  4. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application