SQL Server Tools Refusing To Install

Hi all,

Having massive problem getting the SQL Server 2005 Management Tools to install on a XP Professional (SP2) computer. So I have no SSMS, Profiler, etc. Neither the files are there, nor the icons.

The error in the dialog box is coming back with:

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the remplate.ini and set the UPGRADE property to the name of the component."


The computer would have had SQL 2000 and SQL 2005 Express Edition installed at some stage but both were uninstalled before my attempting to install SQL Server 2005 Developer Edition. Build 9.00.1399.06.

After this dialog box the setup fails that component (Management Tools) then crashes, generating a CAB file with all the logs in the C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG directory.

The log files seem to indicate an incompatibility between version of files installed and what wants to be installed.

Problem of course is that it's probably read this from the registry somewhere, the files physically do not exist.

So I have tried the following with no luck:

start /wait setup.exe /qb REINSTALL=SQL_Tools90
start /wait setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS
start /wait setup.exe /qb UPGRADE=SQL_Tools90
start /wait setup.exe /qb UPGRADE=SQL_Tools90 REINSTALLMODE=OMUS

So then I had a look in the registry. Found Microsoft SQL Server 2005 Tools under HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstall{A30965BD-2D4D-45CE-8F04-6A6889818CF1}


Is was to deleting the entire subtree, so thought that if I rename the GUID value and even the name that might solve the problem and force an install.

Still no joy.

So any ideas on how to force an installation of the Management Tools. I then plan to install SQL Server 2005 SP2.

I do not think that installing SQL Server 2005 SP2 will reinstall the files, but I could be wrong.


So any suggestions on what to wipe from the registry, whether there is a later set of the tools that I can install separately, or how I can force a reinstallation of the tools. Or should I install SQL Server 2005 SP2 and hope it fixes it up?

Perhaps I should uninstall the Microsoft SQL Server 2005 Tools using MsiExec.exe /I{A30965BD-2D4D-45CE-8F04-6A6889818CF1} from the registry and then try to install them again?


TIA,

Victor