none
MsiGetProductInfo failed to retrieve ProductVersion for package during install

    Question

  • I keep getting this when trying to install SQL Server 2008 Workstation Components on a Vista Premium PC that has SQL Server 2005 tools on it.

    MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.

    I have tried all kinds of cleanup of the 2005 version to no avail (Uninstall, MS Install Cleanup Utility, Registry cleanup, Old SQL Server directory deletes, etc... ).

    Wipe PC and start over is not an option.

    Any suggestions?  What the heck is it looking for? 

    I have reinstalled my SQL Server 2005 tools and have no mention of '
    2243F21A-E132-44F7-BA13-024D0845C815' in my registry, but 2008 tools still do not want to install.



    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -289740454
      Exit facility code:            1722
      Exit error code:               59738
      Exit message:                  MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
      Start time:                    2008-09-04 14:33:37
      End time:                      2008-09-04 14:38:32
      Requested action:              ComponentUpdate
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\Detail_ComponentUpdate.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xD94919CC%400xEEBAE95A

    Machine Properties:
      Machine name:                  ORBIT
      Machine processor count:       2
      OS version:                    Windows Vista
      OS service pack:               Service Pack 1
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x86
      Process architecture:          32 Bit
      OS clustered:                  No

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         C:\Temp\Zips and ISOs\SQLServer\SQLServer2008Standard\x86\setup\
      Installation edition:          STANDARD

    User Input Settings:
      ACTION:                        ComponentUpdate
      CONFIGURATIONFILE:            
      HELP:                          False
      INDICATEPROGRESS:              False
      MEDIASOURCE:                   C:\Temp\Zips and ISOs\SQLServer\SQLServer2008Standard\
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\ConfigurationFile.ini

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\SystemConfigurationCheck_Report.htm

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: System.InvalidOperationException
        Message:
            MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
        Data:
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
            at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
            at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

    Thursday, September 04, 2008 7:09 PM

Answers

  • Conor Cunningham's Blog saved me on this one.  He was describing a very similar error also resulting in the 1605 error with a MsiGetProductInfo failed message.

    In my case I took the guid 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, I then reversed that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches.

    I got one match and deleted its parent.

    My install is currently running (sailed past the earlier error).

    Conor's Blog is at http://www.sqlskills.com/blogs/conor/CommentView,guid,a044bb7f-bfb6-4f4c-9a94-3a8687a33105.aspx
    Saturday, September 06, 2008 1:40 AM

All replies

  • One clarification.... this is happening on Vista Ultimate 32 bit

    I also tried installing the tools via command line using:  setup /Action=Install /FEATURES=Tools

    Here is what the Detail_ComponentUpdate.txt file has in it (towards bottom):

    2008-09-04 16:00:12 Slp: Package ID SqlWriter_Cpu32: NotInstalled
    2008-09-04 16:00:12 Slp: Package ID BOL_Cpu32: NotInstalled
    2008-09-04 16:00:12 Slp: Package ID BestPracticesPolicies_Cpu32: NotInstalled
    2008-09-04 16:00:12 Slp: Package ID SyncServicesADO_Cpu32: NotInstalled
    2008-09-04 16:00:12 Slp: Package ID Synchronization_Cpu32: NotInstalled
    2008-09-04 16:00:12 Slp: Error: Action "CuSetFeatureInstallStateAction" threw an exception during execution.
    2008-09-04 16:00:12 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605. ---> System.InvalidOperationException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2008-09-04 16:00:12 Slp:    --- End of inner exception stack trace ---
    2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2008-09-04 16:00:15 Slp: Received request to add the following file to Watson reporting: C:\Users\sa\AppData\Local\Temp\tmp996.tmp
    2008-09-04 16:00:15 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2008-09-04 16:00:15 Slp: Inner exceptions are being indented
    2008-09-04 16:00:15 Slp:
    2008-09-04 16:00:15 Slp: Exception type: System.InvalidOperationException
    2008-09-04 16:00:15 Slp:     Message:
    2008-09-04 16:00:15 Slp:         MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
    2008-09-04 16:00:15 Slp:     Stack:
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2008-09-04 16:00:20 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2008-09-04 16:00:21 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2008-09-04 16:00:21 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2008-09-04 16:00:22 Slp: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
    2008-09-04 16:00:22 Slp: Watson bucket for exception based failure has been created
    2008-09-04 16:00:22 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2008-09-04 16:00:22 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2008-09-04 16:00:22 Slp: Sco: Attempting to get registry value DW0200
    2008-09-04 16:00:53 Slp: Submitted 1 of 1 failures to the Watson data repository
    2008-09-04 16:00:53 Slp:
    2008-09-04 16:00:53 Slp: ----------------------------------------------------------------------
    2008-09-04 16:00:53 Slp:
    2008-09-04 16:00:53 Slp: Error result: -289740454
    2008-09-04 16:00:53 Slp: Result facility code: 1722
    2008-09-04 16:00:53 Slp: Result error code: 59738

    Thursday, September 04, 2008 8:07 PM
  • Conor Cunningham's Blog saved me on this one.  He was describing a very similar error also resulting in the 1605 error with a MsiGetProductInfo failed message.

    In my case I took the guid 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, I then reversed that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches.

    I got one match and deleted its parent.

    My install is currently running (sailed past the earlier error).

    Conor's Blog is at http://www.sqlskills.com/blogs/conor/CommentView,guid,a044bb7f-bfb6-4f4c-9a94-3a8687a33105.aspx
    Saturday, September 06, 2008 1:40 AM
  • I had the same issue today and this solved it for me.  Thanks Henrik.

    Ben
    Monday, September 15, 2008 3:01 PM
  • It's solved my problem too. Thanks to Conor Smile
    Sunday, September 21, 2008 2:41 PM
  • Conor is the King! Saved me too.

     

    Tuesday, December 09, 2008 8:39 AM
  • Hi Henrik.

    I only found one match of the reversed key. Should I delete this one?

    Thanks
    Wednesday, February 04, 2009 11:56 AM
  • Hi

    I get the following error please help:


    2009-03-13 15:54:19 Slp: Error: Action "CuSetFeatureInstallStateAction" threw an exception during execution.
    2009-03-13 15:54:20 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605. ---> System.InvalidOperationException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2009-03-13 15:54:20 Slp:    --- End of inner exception stack trace ---
    2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2009-03-13 15:54:21 Slp: Received request to add the following file to Watson reporting: C:\Documents and Settings\.......\Local Settings\Temp\tmpAE.tmp
    2009-03-13 15:54:21 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2009-03-13 15:54:21 Slp: Inner exceptions are being indented
    2009-03-13 15:54:21 Slp:
    2009-03-13 15:54:21 Slp: Exception type: System.InvalidOperationException
    2009-03-13 15:54:21 Slp:     Message:
    2009-03-13 15:54:21 Slp:         MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
    2009-03-13 15:54:21 Slp:     Stack:
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2009-03-13 15:54:32 Slp: Sco: Unable to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_, Win32 error 2
    2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2009-03-13 15:54:32 Slp: Sco: Unable to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_, Win32 error 2
    2009-03-13 15:54:33 Slp: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
    2009-03-13 15:54:34 Slp: Watson bucket for exception based failure has been created
    2009-03-13 15:54:34 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-03-13 15:54:34 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2009-03-13 15:54:34 Slp: Sco: Attempting to get registry value DW0200
    2009-03-13 15:54:37 Slp: Submitted 1 of 1 failures to the Watson data repository
    2009-03-13 15:54:42 Slp:
    2009-03-13 15:54:42 Slp: ----------------------------------------------------------------------
    2009-03-13 15:54:42 Slp:
    2009-03-13 15:54:42 Slp: Error result: -289740454
    2009-03-13 15:54:42 Slp: Result facility code: 1722
    2009-03-13 15:54:42 Slp: Result error code: 59738

    Friday, March 13, 2009 4:17 PM
  • I got the error code 1608 while installing SQL Server 2008 Express and it worked for me aswell. Be aware that you might find (I did) a folder in the registry with these reversed numbers in the "HKCR\Installer\Products" and that isnt the one to delete. You should look for a key with that name and then delete its "folder".
    Thanks for the help
    Saturday, April 11, 2009 11:45 AM
  • Sorry Kruz, did you find solution ragerding this issue ?

    Because I'm also stumble in the same problem and still I'm investigation on that from long time without success ...

    Thanks in advance for replay.

    Tuesday, May 12, 2009 4:51 PM
  • Sorry unfortunately not, I have given up completely :-( Can anyone help???
    • Proposed as answer by Fritzmatthews Thursday, June 18, 2009 5:03 PM
    Tuesday, June 02, 2009 1:15 PM
  • this shows how to manually uninstall an instance of sql 2008.


    http://support.microsoft.com/kb/955404


    Or search for

    SQL Server 2008 installation fails when you try to install SQL Server a second time
    Thursday, June 18, 2009 5:03 PM
  • Reversing the fist part of the guid displayed on the error (msigetproductinfo failed to retrieve... 1605) and searching within the registry, for me got 2 hits, in both cases, I deleted the root key and the installation completed without drama
    Sunday, July 26, 2009 11:24 PM
  • Amen to that! :)
    Wednesday, August 19, 2009 10:33 AM
  • I solved !!! Finally during last July I found solution and I re-installed Sql 2008 Express without os refresh or os re-install … sorry for delay in my answer …

    The solution was under my nose … as found reading some threads … the problem was GUID remained into registry ….

    During my previous attempts, I deleted two, three or four times GUID showed into error box from HKCR\Installer\UpgradeCodes (HKEY_CLASSES_ROOT), without success so that I given up this solution …

    So, during last July I repeated that ... I run installation for 10, 20 (sorry I don’t remember) times and I deleted GUID showed (by “regedit”), after each attempt …

    After last … installation go on …

    Hope it Helps …

    • Proposed as answer by Alevann Wednesday, September 16, 2009 9:57 AM
    Wednesday, September 16, 2009 9:56 AM
  • What do you mean Alevann, exactly? What do I have to do?  For those of us who are not expert.... Thanks.
    Sunday, September 20, 2009 4:45 PM
  • I found a number of entries under the reversed GUID and deleted them all (they were all SQL related any way). -worked a treat!
    Tuesday, March 02, 2010 1:34 PM
  • Me too - I found many entries most of which are outside of HKCR\Installer\UpgradeCodes. I was not sure I had to delete all of them, but I deleted them anyway because I was ready to wipe out the HD after spending so many hours cleansing SQL 2005.

    Now SQL 2008 has been successfully installed on the machine.

    Thanks a lot, Henrik!


    hz
    Wednesday, May 05, 2010 2:09 PM
  • It really helped me! Thank you Henrik  >_<
    Wednesday, September 29, 2010 2:11 AM
  • Thanks a lot, Henrik!
    Saturday, October 09, 2010 5:11 PM
  • Go Connor's Blog

     

    Trick was to use the first 8 digits in reverse of the GUID that is presented to you in the error.

     

    This saved hours. Thanks for everyone on this site.


    D-B-S
    Tuesday, October 12, 2010 7:27 PM
  • Thank you Henkrik for posting this here and thanks to Conor for explaining this in the first place.

    I was ready to cry and I was ready to spend 2 days reinstalling the whole machine and making it work for me, now, with a few rounds of the process described in the solution I was able to install sql server 2008 !!

    THANK YOU THANK YOU

    Wednesday, November 03, 2010 7:48 AM
  • A pox on you Microsoft!

     

    This is the second time in two weeks I have had to manually hack the registry when trying to install SQL Client tools (2005, 2008)

     

    All because of some problem with MSXML 4 /6

     

    Grrrr

     

     


    LaCie drives. Failing when you need them most."La" meaning "Terrible", "Cie" meaning "customer service"
    Friday, December 03, 2010 10:02 AM
  • Henrik,

    Your solution worked perfectly!  It took 4 hours to go through the process weeding out all of the guid's from my registry.  In my case, SQL Server had been installed several times over 3 years on my PC.  Every install left its mark in the registry.  I had 8 of them to weed out before SQL Server 2008 finally installed.  I ran a registy cleaner several times as well which also made my PC boot up A LOT faster.

    This was certainly way better than re-imaging my hard disk like my I.T. dept. wanted to do.

    Thank you very Much!

    -Larry

    Tuesday, December 21, 2010 6:56 PM
  • Conor Cunningham's Blog saved me on this one.  He was describing a very similar error also resulting in the 1605 error with a MsiGetProductInfo failed message.

    In my case I took the guid 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, I then reversed that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches.

    I got one match and deleted its parent.

    My install is currently running (sailed past the earlier error).

    Conor's Blog is at http://www.sqlskills.com/blogs/conor/CommentView,guid,a044bb7f-bfb6-4f4c-9a94-3a8687a33105.aspx

    I had the same thing on Win7...I followed your instructions and it worked!

    Thanks a million.

    Sunday, April 24, 2011 8:29 AM
  • http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/13/upgrade-from-sql-2005-to-sql-2008-might-fail-with-msigetproductinfo-error.aspx
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Sunday, April 24, 2011 1:04 PM
    Moderator
  • Took 5 deleted parents and then it worked !!  Thanks.

     

    Wednesday, April 27, 2011 11:00 PM
  • Hi

     

    Fixed my issue aswell,

     

    Best regards

    Rene

    Thursday, April 28, 2011 12:46 PM
  • Hi all,

    I installed successfully but I couldn't access Database. Then, I uninstalled it and reinstall with option "install new installation". And there is a error what likes error all guys above met. I found product code in <HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\Folders>

    Product code in error is "2180B33F-3225-423E-BBC1-7798CFD3CD1F" and I reverse the first part 2180B33F to F33B0812. But when reinstalling, it still release this error.

    Please help me this issue.

    Monday, July 04, 2011 3:27 PM
  • Hi all,

    I followed the guide from site

    http://www.eggheadcafe.com/software/aspnet/34217839/error-installing-sql-server-2008.aspx

    The message I got is:
    MsiGetProductInfo failed to retrieve ProductVersion for package with Product
    Code = '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'. Error code: 1608.

    My Work-around steps are:
    1. Reverse the GUID and search registry for 5A6FB34A. Then I got the
    following result:

    [HKEY_CLASSES_ROOT\Installer\Features\5A6FB34A0F5DAAA4FB1456990536CE44]

    [HKEY_CLASSES_ROOT\Installer\Products\5A6FB34A0F5DAAA4FB1456990536CE44]

    [HKEY_CLASSES_ROOT\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Features\5A6FB34A0F5DAAA4FB1456990536CE44]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]

    2. Delete two keys which have "UpgradeCodes" in them and leave others
    untouched.
    [HKEY_CLASSES_ROOT\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]

    3. Install SQL Server 2008 again, which is developer version for me, and it
    went through without any hassle.

    Wish it help.

    cheers
    Yao

    His product code is A43BF6A5-XXXX-XXXX-XXXX-XXXXXXXXXXXX, and he searched in registry with 5A6FB34A. So, why did he delete

    [HKEY_CLASSES_ROOT\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]
    [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\UpgradeCodes\7AB711B11CB5E91428E0D7F4F314C2B7]
    2 registries above are not relevant with 5A6FB34A
    So, What registries do I have to delete? 
    Tuesday, July 05, 2011 3:43 AM
  • Hi,

    Thanks a lot for sharing this Henrik. It worked a treat!!!

    My problem was with SQL Server 2008 R2 running on Windows 7 Ultimate (32-bit) machine and Microsoft automatic updates kept on failing when trying to install Service Pack 1 for SQL Server 2008 R2. As usual, the upgrade error was completely useless, so I decided to download the service pack 1 manually and at least it gave me a more specific error i.e.

    ===============================================================================================

    TITLE: SQL Server Setup failure.
    ------------------------------

    SQL Server Setup has encountered the following error:

    MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{3A9FC03D-C685-4831-94CF-4EDFD3749497}'. Error code: 1605..

    ===============================================================================================

    I did what you suggested:

    Take the beginning of the GUID, 3A9FC03D, and reversed it D30CF9A3 and searched the specific registry location (HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\UpgradeCodes\)

    I started to backup every entry I was deleting and got fed up after having created 20 .reg file, so started to delete a few more and again, got fed up, so I gave the setup a go, and voila, it goes passed the error and it is now displaying the "Welcome Screen"!!! I haven't finished the installation but I'm hoping that the rest of the installation will go smoothly.

    On another note, while related, it is strange that the key i.e. D30CF9A3 was always related to SQL Server Compact Edition!!! I'm sure it is installed but why the heck is it affecting the installation of the SQL Server. Maybe they have common files... I don't know but it's been a complete pain once again having to mess around with the registry!!

    Anyway, the good news is that I'm now ready to install!!

    Thanks again!

    Thierry

    Wednesday, August 31, 2011 12:12 AM
  • Worked a treat!  Thanks a bunch. Doing a custom SQL 2008 Express installation on Vista and had this exact error. Found an instance of the reversed guid in that reg key. Then got the error again but with a different code. Another hit. Another delete and we're golden.

    I think the root cause was a SQL 2005 Express installation that would not clear. ??!

     

    Friday, September 16, 2011 8:13 PM
  • Worked perfect for me to!

    Thanks a ton!  :)

    Friday, October 07, 2011 4:43 PM
  • Conor Cunningham's Blog saved me on this one.  He was describing a very similar error also resulting in the 1605 error with a MsiGetProductInfo failed message.

    In my case I took the guid 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, I then reversed that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches.

    I got one match and deleted its parent.

    My install is currently running (sailed past the earlier error).

    Conor's Blog is at http://www.sqlskills.com/blogs/conor/CommentView,guid,a044bb7f-bfb6-4f4c-9a94-3a8687a33105.aspx

    Hey Henrik !!

    this is work in my SQL server 2008 R2 EXPRESS !

    my problem it same with you,, but now have resolve :)

    thx for your information :)

    Thanks regards,

    Galih

    (Indonesia)

    Wednesday, April 11, 2012 3:22 AM
  • I was getting the same error message and found this post - dude you saved the day with this.

    Followed those instructions and my install fired right off.. well first off the machine had a failed install of MS SQL 2000 on it, I had to download and install MSDE 2000 then VS 2008 w/ SP1.

    After the stage was set, followed those instructions and "VOILA"

    Many. many thanks for this

    Cheers Mates

    Wednesday, February 13, 2013 10:57 PM