FIX: SQL Server Setup has encountered the error code: 1605

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”

emna

2014-04-08

bonsoir j’ai pas comprie la 2 poinnt pour le demache de guid et ou je cherche le n

umero??

Reply
Hakuna matat

2013-05-05

^________________________________________^ oh ,thx

Reply
reddy

2013-02-13

Great !!!!!!!!!!!!!!!!!
Now it is working !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Reply
Edward Putt Jr.

2012-10-04

I have no clue how you figured this out. It seems to have worked.
I am putting this here for anyone who is having issues upgrading commvault 8 to 9 and get the dreaded “C:Program FilesMicrosoft SQL Server100Setup BootstrapLOGsummary.txt” error at the database upgrade part.

I found the error in the bootstrap log and did as you said, and it worked great, so far, not done yet.

I am going to say it worked. If not I will come back and let you know. This worked awesome thank you thank you thank you.

Reply
1. emna
  
  2014-04-08
  
  HI TU Peut m’explicer la 2 point pour le guide j’ai pas comprie :) merci d’avance
Edu

2012-10-03

You are a crack!! Thanks a lot!
Edu

Reply
Eric (Seattle)

2012-09-10

Wow, this took a ton of attempts but it eventually worked. Thanks!

Reply
jio

2012-08-22

I had to do it few times and many entries were found for the same key reg but at the end it worked… thank s a bunch

Reply
Cantoluna Queen’s

2012-08-19

Sorry but i cant understand what u mean about “Take the first part of GUID and reverse it, in my case it is AA4A4B2C and its reverse string is C2B4A4AA”. Plaese help me :((

Reply