PerfLib 2.0 counter removal failed with exit code 2. Command line: C:\Windows\system32\unlodctr.exe /m:hkengperfctr.xml from directory C:\Program Files\Microsoft SQL Server\150\Shared\.

Question

I am trying to install Mysql 2019 express in custom.........but it is showing this error everytime.........i have tried many different ways to resolve this issue but nothing worked.........plz help me in resolving it

Answer 1

Hi @Komal Komal ,

Welcome to Microsoft Q&A!
After seeing your file path, I assume that you are having problems with the SQL Server installation process.

it is showing this error everytime.......

Did you try to uninstall and reinstall it multiple times?
This error may be caused by you not uninstalling SQL Server cleanly and reinstalling it.
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
4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
6. Reboot the machine
   Finally, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

Also you can look at this: Fix problems that block programs from being installed or removed
If I misunderstood you, please feel free to let me know.

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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

I am installing from the local file only

Not according to your screenshot!

The file that you download from the site is not the SQL Server installation file but the online installation file:

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

You can check this size of the file and find that it is only a few MB

According to your screenshot you are using this file and NOT the SQL Server media

In your screenshot you can notice there are three options. The third one is what you should do: Download Media

Next, you have option to choose which the media which you need according to the features you want to use.

The first option will download only the SQL Server Engine

If you don't need Full Text service and reporting service then you do not need to download the file that include these features. Select the first option

how to install only database engine services?

Option 1: As explain above you can download the media which include only the database engine feature without the full text and reporting (file should be about 255 MB)

Option 2: Even if you download the file which include these features, you can install only the database Engine (File is above 750 MB)).

When you execute the installation media (not the online installation but the media which you download), then you can this window:

Click on the first option to install new SQL Server instance and follow the steps of the installation, until you get to the following step: Feature Selection

Here you can select which feature you want to install or add to previous installed server

Click on "Unselect All" to clean the selection from all features

and select only "Database Engine Service"

This will install SQL Server minimum installation without extra features (which can add in the future)

Note! Don't forget to execute the installation as administrator or using one of the OS administrators

Answer 3

I'm trying to install Microsoft SQL Server developer edition some of the instance features are failed to install and I tried the above answers methods but still getting the same error message.

Detailed results:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 1639

Answer 4

I too faced a similar error and situation for one of my customer, and the best possible solution is to remove the existing database engine and reinstall with a named instance.