Skip to content

Missing MSI and MSP files

If you hit missing MSI/MSP issue, suggest them to try the FixMissingMSI tool developed by Simon

Here is how SQL Server work with MSI/MSP files, you may need to use this skill to troubleshoot if the FixMissingMSI does not resolve the issue.

MSI and MSP files are stored in c:\windows\installer folder during patching and SQL installation, and will be used in next SQL Server patching/uninstallation.

The patching/uninstallation fails if the files are not there.

For example, the file 47f929.msi was removed in c:\windows\installer. Then how to restore the file?

Here are the steps

1.Search the key word ’47f929.msi’ under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\.This registry is where MSI files stored .

2.Then we get the VersionNumber 39ABAC180C729DB4B9E522C7675BF964.

3.The original file is stored in different location but under the same VersionNumber


4.Use the VersionNumber to search HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\


5.The name is stored at PackageName of SourceList

6.Now we are able to target the file by combining the DisplayVersion+LastUsedSource+PackageName.

What about MSP files

It’s little bit complex to handle the MSP files.

1.MSP links to MSI.

2.ALL MSI has 0 or more MSP files.


3.Search the VersionNumber 9B8D98DD6CF467A4D98BAFDCC80F2086 under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\VersionNumber\Patches. Please note ‘InstallProperties’ is for msi file, the ‘Patches’ is for MSP.

4.The VersionNumber is useful.

5.Use the keyword to search HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Patches, which tells you the cache file name


6.Use the VersionNumber to search HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Patch\


You will get the original file name.


Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: