Missing C:\Windows\Installer files when trying to update SQL Server

While trying to install a service pack on one of my systems, I ran into a server that kept exiting setup stating it was missing files from C:\Windows\Installer.  This is unfortunate as some people will actually clear out the C:\Windows\Installer directory trying to free up space.  Luckily, Microsoft has a few tools for fixing this issue.  You can either use the FixMissingMSI tool, or the FindSQLInstall.vbs script.  I prefer the FixMissingMSI tool as sometimes getting the approval to run a .vbs script can be difficult to obtain.  Both tools can be found here:


Update:  Several co-workers have asked me if there is anything that is safe to remove from this directory.  The answer is that it depends.  If you see a ton of .tmp files and they each 133MB and there’s a hundred of them, by all means delete them.  Typically .tmp files are caused by a failed download from the updates server.  Remove these without a problem, then download the actual update file that is being installed and install it manually.  This should clear up any issues like that.

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 )

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: