SQL Express Troubleshooting: The performance counter registry hive is corrupted.(Error -2067922940)

Issue

On the installation of SQL express, you come across error code 2067922940.

Error

Multiple products install SQL express as a backend, so you can see some other log related to the same error.

Visual Studio 2010: (quoted from there)

  • [09/26/11,00:07:03] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Error code -2067922940 for this component is not recognized
  • [09/26/11,00:07:03] Microsoft SQL Server 2008 Express Service Pack 1 (x64): [2] Component Microsoft SQL Server 2008 Express Service Pack 1 (x64) returned an unexpected value.
  • [09/26/11,00:07:04] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2008 Express Service Pack 1 (x64) is not installed.

BackUpExec 2014

  • Error: V-225-302: ERROR: Failed to install SQL Express BKUPEXEC instance with error -2067922940.

Solution

The unofficial way if you don't use performance counter is simply to use the install switch /SKIPRULES=PerfMonCounterNotCorruptedCheck

The official way is to repair the performance counter with lodctr /R

Some other links on how to do it.

See Also