Errors During Installation of Microsoft SQL Server 2022

Question

I am encountering several errors while trying to install Microsoft SQL Server 2022. Below are the details:

1. Error: MOF Compiler Issue
   • Message: The MOF compiler could not connect with the WMI server. This may be due to incompatibility with the existing WMI repository or a failure of the WMI server to start.
2. Error: PerfLib 2.0 Counter Removal
   • Message: PerfLib 2.0 counter removal failed with exit code -2147024894 during the command C:\WINDOWS\system32\unlodctr.exe /m:hkengperfctr.xml.
3. Error: SQL Server Database Engine Services Instance Features

• Message: Invalid command line argument. Consult the Windows Installer SDK for detailed help.
• Error Code: 1639.
  • Log File: sql_engine_core_inst_Cpu64_1.log.

I have attempted the setup process multiple times, but these errors persist. Any guidance on how to resolve these issues would be greatly appreciated.

Answer 1

First things first: what hardware do you have? If you have an ARM processor, beware that SQL Server does not support ARM. The rest of the answer assumes that you have a regular x64 processor.

My belief is that this is an error that occurs mainly in the situation when a user tried to install SQL Server and it failed with some error. The user might have tried some random cleanup and made renewed attempts. Because the cleanup was incomplete, Setup now fails with another error than it did originally.

Could this apply to you? Or did this happen on the first attempt? (If it does apply to you, don't feel bad. I think it is quite a natural path to take.)

Here is a link to an article that can help you to clean up properly: https://www.sql-easy.com/learn/how-to-uninstall-sql-server/. I have not tried it myself, but I learnt about it from a user who was in a similar situation as yours, and who was able to install SQL Server successfully after following the article.

If you are on Windows 11, be sure to read the article Troubleshoot errors related to system disk sector size greater than 4 KB before you try again. It discusses a known issue where Windows 11 reports a disk-sector size that SQL Server chokes on. This could be the cause for your original failure. Check out this article, and if needed apply the workarounds it proposes.

If you make a new attempt after cleanup, and it still fails, you find log files in C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log with one folder per attempt. (nnn is a three-digit number that depends on the version of SQL Server you are trying to install). The files of most interest are summary.txt, detail.txt and any file with ERRORLOG in the name. (The latter only appears if Setup came as far as trying to start SQL Server). Feel free to attach these to the thread here.

Answer 2

Hi @Shubham More,

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 helps you automatically repair issues when you're blocked from installing or removing programs. It also fixes corrupted registry keys.

Also, 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).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).

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.