Remove Bad Install

[DonP]

After attempting to install SQL Server on Windows 2000 SP3 and having the installation fail, I can neither finish the installation nor can I uninstall it. The service is there but doesn't start and when I try an uninstall, there is an error that it cannot find something that it needs to uninstall. If I try to reinstall, I get a message that it needs to be uninstalled first. SQL Server was on this system before with a different harddrive so it is not a hardware compatibility issue. How can I get rid of it in order to try again?

Don
contact@pc-homepage.com

http://www.pc-homepage.com/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[JayKusch]

If the standard un-install utility doesn't do the trick for some reason, here

Remove the <sql> directory and everything under it
Remove the <sql> dir from the path (use control panel/system for this)
Remove the SQL registry entries using regedt32/regedit. These are :-

(All versions)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
(6.0 and above.)

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLExecutive
(7.0 and above)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server 7
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServ65
If you have lost permission to any of the registry keys then log on as administrator and take ownership of them starting at the highest relevant level. Use regedt32 and check the box to take ownership of all subkeys as well.


Thanks

J. Kusch

 

[DonP]

Thanks, that seems to have done the trick. I haven't tried reinstalling but at least with the old one gone, it can be done.

Don
contact@pc-homepage.com

http://www.pc-homepage.com/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases