How to fix SQL Server installation error

Question

I keep getting this error every time I try to download the SQL server. Has anyone encountered this before, I would appreciate any help with this . Thank you

Answer 1

Hi @gianlucaast ,

(01) 2023-03-22 14:24:18 Slp: The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.

Please refer to this thread:

https://stackoverflow.com/questions/63636622/sql-install-error-the-mof-compiler-could-not-connect-with-the-wmi-server

You can download this troubleshooter. It help you automatically repair issues when you're blocked from installing or removing programs. It also fixes corrupted registry keys.

There is another way.

Please follow the below steps to remove all components of previous installed SQL Server completely:

1. Remove all SQL Server components from 'Programs and Features'
2. Backup the registry
3. Delete the following keys in regedit:

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

1. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
3. Reboot the machine

In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Thanks for your question.

There are several reasons for this installation error. Could you please post the error logs.

The location by default is: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log

There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can also find a Detail.txt file.

Thank you!

Answer 3

I looked at the log files, and I don't have a full answer. But my impression is that your version of the MSI installer is older than the one that the SQL Server installer expects. Why what would happen I don't know. But check that you have 22H2 of Windows 10 and all Cumulative Updates of Windows. But Windows may also be in need of repairs. (MSI is a Windows thing, and certainly not within my expertise.)