Yesterday I was installing newly released Visual Studio 2010 RTM on my Windows 7 running PC and Setup encountered the error while installing SQL Server 2008 Express Service Pack 1.

Actually I was using pre-release version of Visual Studio 2010 (RC) and uninstalled before prior to install retail release (RTM) of Visual Studio 2010 as instructed. Everything went fine except Visual Studio 2010 RTM Setup that logged the error in log file.

[04/13/10,10:00:09] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Error code 2064843076 for this component is not recognized.
[04/13/10,10:00:09] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Component Microsoft SQL Server 2008 Express Service Pack 1 (x64) returned an unexpected value.

Then I tried to install SQL Server 2008 Express manually (out of Visual Studio setup) to know the exact error message and it was-

MsiGetProductInfo failed to retireve ProductVersion for package with Product Code = ‘{AA4A4B2C-0465-3CF8-BA76-27A024D8ACAB}’. Error code: 1605

The GUID {AA4A4B2C-0465-3CF8-BA76-27A024D8ACAB} may different on different machines

SQL Server Setup Error Code 1605

After observing few aspects, I got the solution and would like to share it with you. To fix the error, you need to follow these simple steps.

How To:

1. Run Registry Editor (type regedit in Start Search or Run dialog box and press enter) and navigate to- HKEY_CLASSES_ROOT\Installer\UpgradeCodes

2. Take the first part of GUID and reverse it, in my case it is AA4A4B2C and its reverse string is C2B4A4AA. Now search for C2B4A4AA and you’ll get a match than delete the its parent subkey (it will be a kind of GUID without braces).

Deleting Registry Subkey

3. Now run the Setup again, it will go smoothly without any hassle.

Applies To:

  • SQL Server 2008
  • SQL Server 2008 Express

53 responses to “FIX: SQL Server Setup has encountered the error code: 1605”

  1. Stefano Carfagna Avatar
    Stefano Carfagna

    To solve the problem I wrote a small software to remove all the key from the registry

    holding the string “SQL Server” into value . It has been a risk but finally it works.

    write me ill’send y the exe

  2. Nguy?n ?ình Vi?t Avatar
    Nguy?n ?ình Vi?t

    Thanks you

  3. Setanta Avatar
    Setanta

    Many thanks Ramesh i need this program for my study i have spent 3 days to figure how to install this stupid program to finish my homework again thank you man!!!

  4. Atite666 Avatar
    Atite666

    BIG BIG BIG THX !!!

  5. Bigpappa Avatar
    Bigpappa

    THANK YOU!!!

    1. Ramesh Kumar Avatar
      Ramesh Kumar

      Thanks for your comments and appreciation!

  6. nh0xm0us3 Avatar
    nh0xm0us3

     I love you=))

  7. Crgturbo Avatar
    Crgturbo

    great. its worked. Thanks a lot. 

  8. Nguy?n ?ình B?c Avatar
    Nguy?n ?ình B?c

    Thanks you

  9. Herpderp9114life Avatar
    Herpderp9114life

    I had to repeat this process 5 times but it eventually worked. Thanks.
    MS SQL Server 2008 sure was a nuisance to reinstall.

  10. ptkk_tinhban168 Avatar
    ptkk_tinhban168

    TUY?T L?M! C?M ?N B?N NHI?U L?M!

Leave a Reply to Setanta Cancel reply

Your email address will not be published. Required fields are marked *