Thursday, 8 August 2013

upgrading a system to sql server 2008 r2 having sql server 2005

Consider a scenario-
where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files.

********************************************************
TITLE: SQL Server Setup failure.
------------------------------
SQL Server Setup has encountered the following error:
MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code =
'{0826F9E4-787E-481D-83E0-BC6A57B056D5}'. Error code: 1605..


Solution-

  • Get the Product Code = '{0826F9E4-787E-481D-83E0-BC6A57B056D5}' from the error message that you are getting.
  • Byte reverse the first part from 0826F9E4 to 4E9F6280.

  • Search in the registry and try to find a match for "4E9F6280"
  • Take a backup of the registry and delete the parent key.

  • There can be a lot of search results in this case, but need not worry. Just delete all the parent registries of this search result which are having only this key value. But in case the parent registry have more than one key values, then just delete this particular child key value.

  • Restart the system, and It's good to go. 

No comments:

Post a Comment