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\.

Komal Komal 1 Reputation point
2022-02-06T07:07:24.443+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-02-07T03:32:43.78+00:00

    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.


  2. Ronen Ariely 15,096 Reputation points
    2022-02-07T13:32:51.803+00:00

    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

    171876-image.png

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

    171924-image.png

    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:

    171849-image.png

    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

    171885-image.png

    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"

    171867-image.png

    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

    0 comments No comments

  3. padma sagar 1 Reputation point
    2022-06-29T05:15:47.887+00:00

    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.215992-sql-server.png

    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

    0 comments No comments

  4. Jagath Jayaprakash 0 Reputation points
    2022-09-29T10:17:54.69+00:00

    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.