Unable to install MSDE

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.

eventvwr

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.

Capture1

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:

  1. the key "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set\InstanceComponentSet.1"
  2. its instance name in the list of registr key "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances".
  3. 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: