Unable to install SQL 2008 due to the remnants of a previous installation

Sometime remnants of a previous installation/ a failed install can prevent us from reinstalling SQL server

I have documented the consequence of one such instance which rendered us to be unable to install SQL 2008 from the server

· When we launched the setup we got the following error :

SQL Server Setup failure. 1

SQL Server Setup has encountered the following error:

MsiGetProductlnfo failed to retrieve Productversion for package with Product Code = ‘{DF167CE3-60E7-44EA-99EC-2507C 5 1F37AE}’. Error code: 1605..

We got the obfuscated product code :

---------------------------

Obfuscated product code Result

---------------------------

3EC7S1FD7E06AE4499CE52705CF173EA

---------------------------

OK

---------------------------

· Went into the registry (start-->run-->regedit) and took a full registry backup

· We then went to the following key HKEY_CLASSES_ROOT\Installer\UpgradeCodes

· We then used the obfuscated product code : 3EC761FD-7E06-AE44-99CE-52705CF173EA

· We searched for it within the registry key HKCR\Installer\UpgradeCodes for matches.

· We got one match and deleted its parent.

· We ran the installation which failed yet again with this error :

TITLE: SQL Server Setup failure.

------------------------------

SQL Server Setup has encountered the following error:

MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{DF167CE3-60E7-44EA-99EC-2507C51F37AE}'. Error code: 1605..

------------------------------

BUTTONS:

OK

------------------------------

· We navigated to this key :HKEY_CLASSES_ROOT\Installer\Features\3EC761FD7E06AE4499CE52705CF173EA and saw that we were having issues (access denied ) issues with it

· We obfuscated the GUID again : DF167CE360E744EA99EC2507C51F37AE , we searched for it and found a key

· We added everyone to the root and added the full control to administrators, System and even replace permission entries to all sub-keys. Same error.

· Since we not have any special changes/permissions set, decided to reset the registry permissions(needs to be used with caution , contingent on the fact that we do not have customized permissions set on the registry)

· We used the KB : http://support.microsoft.com/kb/313222 to reset the permissions so that the setup program will have access to it

· We got this error again from the setup:

MSI error description: Could not open key: UNKNOWN\Components\00C004FEE241478418DBB8505B78CBC5\D56941F2B76595E4DABEA0C21C3EDAFD. Verify that you have sufficient access to that key, or contact your support personnel.

TITLE: Microsoft SQL Server 2008 Setup

------------------------------

The following error has occurred:

Could not open key: UNKNOWN\Components\9419DB21C522CF24897B0DF659D5B883\5B3A043535835474EB2DDDF95F733113. Verify that you have sufficient access to that key, or contact your support personnel.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401

------------------------------

MSI error description: Could not open key: UNKNOWN\Components\00C004FEE241478418DBB8505B78CBC5\D56941F2B76595E4DABEA0C21C3EDAFD. Verify that you have sufficient access to that key, or contact your support personnel.

· Every time setup for giving us errors for different GUID's

· The registry permissions were altered to prevent us from running the setup

· We used this KB : http://support.microsoft.com/kb/237607 to use the Regini.exe tool to modify registry permissions from within a script.

· While trying to reset the permissions on 2 registry entries we are getting the following message.

REGINI: CreateKey (\registry\machine\SOFTWARE\Microsoft\Windows\CurrentVersion\I

nstaller\UserData\S-1-5-18\Components\9419DB21C522CF24897B0DF659D5B883\5B3A04353

5835474EB2DDDF95F733113) relative to handle (000000000) failed - 5

REGINI: Failed to load from file 'c:\Users\msm\Desktop\test.txt' (5)

· We then took the permissions on the following hive : \SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components and then replace the security permissions on the sub keys

· This time the setup of SQL server went through successfully

Regards,
Amrutha Varshini J
SE, Microsoft SQL Server