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. poorang Avatar
    poorang

    thanks a lot dear.
    it worked for me.
    but how hoe did you get this solution.

  2. lifes46 Avatar
    lifes46

    Works perfectly man….thanks

  3. bikhod Avatar
    bikhod

    Wow! This fixed my problem, thanks. I have been banging my head against the wall and Google for the past week trying to get the damened product installed.

    My problems started when I installed SQL 2008 R2 on top of SQL 2008 and then decided to get rid of R2…

  4. sanjay Avatar
    sanjay

    Really help full…i able to fix this problem…saves lot of time.

  5. Juan Avatar
    Juan

    You are a genius!

    1. Author Avatar
      Author

      thanks for comment :)

  6. Mike Avatar
    Mike

    I am having this problem on Win7 Enterprise-64 installing the release of VS2010.  How did you get the SQL installer out of the cabs to find the UUID/SID/whatever that string is?  I unpacked all of the cabs to a directory, but there aren’t any file extensions and I can’t quite figure-out which is the SQL installer to run so I can get the string to delete from the registry.
     

  7. Heino Lengfelder Avatar
    Heino Lengfelder

    Danke, Danke, Danke!!!

  8. musa Avatar
    musa

    thanks. work perfect. I had clean about 5 times.

    1. Author Avatar
      Author

      Your Welcome! AnYTiME :)

  9. John Lovett Avatar
    John Lovett

    Excellent post, I had multiple bad installs and following your advice about 5 times wiped them all off and I was able to do a clean install. Thank-you!

  10. Darin Avatar
    Darin

    This works perfectly. Thanks alot

Leave a Reply

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