Recently I had a problem installing MSDE on a Windows 2003 Member Server. After spending loads of time trying checking the Windows logs as well as the MSDE installation log, the problem end up being down the previous MSDE installation not being fully uninstalled. The information available in Windows logs Source: MsiInstaller Event IDs: 1015, 1033 and 11708, made me think it was a problem with MSI Installer.
msiexec /unregister and msiexec /regserver (Event ID 1015 — Windows Installer Service Availability) did not resolve this nor did installing the current latest version of Windows Installer 4.5 http://support.microsoft.com/kb/942288
Checking the MSDE installation log made me believe that a software policy was preventing the installation of MSDE from completing, however this turned out not to be the case.
Finally I decided to check the registry to delete all instances of MSSQLServer as per How to manually remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) instance … as well as deleting:
- the key "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set\InstanceComponentSet.1"
- its instance name in the list of registr key "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances".
- delete this entire key "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\<instancename>"
as per the following group post …
Once complete, installation of MSDE ran successfully as expected.