SQL SERVER Installation error > Consistency Validation For SQL Server Registry Keys

SQL SERVER Installation error > Consistency Validation For SQL Server Registry Keys

You are attempting to install the SQL Server 2008 R2 when you receive the following error message: "Consistency validation for SQL Server registry keys failed."
NOTE: This issue can occur if an existing key for Microsoft® Business Contact Manager in the Windows Registry does not have adequate permissions, which can cause the SQL Server 2008 R2 installation to fail.



Solution :

Please use the following steps:
  1. Click Start and select Run.
  2. The Run dialog box appears. In the Select field, type regedit.
Caution: We strongly recommend that you back up the system registry before making any changes. Incorrect changes to the registry could result in permanent data loss or corrupted files. 

How to back up registry in Windows?
  1. From the Start menu, type regedit.exe in the search box, and then press Enter. If you are prompted for an administrator password or for confirmation, type the password or provide confirmation.
  2. In Registry Editor, locate and click the registry key or subkey that you want to back up.
  3. Click File > Export.
  4. In the Export Registry File dialog box, select the location to which you want to save the backup copy, and then type a name for the backup file in the File name field.
  5. Click Save.
  1. Browse to the following key :  HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
  2. Give the registry key adequate permissions.
Note: There may be keys from other programs listed under HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server, security settings for them will also need to be updated.

Give the registry key adequate permissions:
  1.                   Right-click on the key and select Properties. Click on the Security tab.
  2.                   Click the Security tab, and select the Everyone user.
  3.                   Check the box for Full Control and then click OK.
  4.                   Close the Windows Registry.

Now, Restart the system and attempt to install SQL Server 2008 R2.

Hope this Helps.
    • Related Articles

    • How do I fix a “Performance counter registry hive consistency” when installing SQL Server 2008 R2 SP2 Express Edition?

      You are attempting to install the SQL Server 2008 R2 SP2 Express edition when you receive an error similar to the following:  "Performance counter registry hive consistency check" failed. The performance counter registry hive is corrupted." ...
    • SQL SERVER Installation issue || There are validation errors on this page.

      There are validation  errors on this page. Click OK to close this dialog box. Review errors at the bottom Setup page, then provide valid parameters or click Help for more information.              Cause : Issue occur due to files and folder are ...
    • ERROR Of SQL Server OLEDB Provider support

      Problem :  While accessing any window application following error may occur:  SQL  Server OLEDB provider support error Unable to load SQL Server OLEDB provider resource DLL. The application cannot continue. Solution : Following the steps below may ...
    • Server Error in '/eXBace' Application.

      Server Error in '/eXBace' Application. Access to the registry key 'HKEY_LOCAL_MACHINE\SOFTWARE\Classes\.LKey.lic.k' is denied.              Solution : Regarding this issue you are requested to please open Registry Editor (Open Run > regedit). ...
    • You have an error in your SQL syntax.

      --------------------------- ZenIT --------------------------- [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAD"',0)' at ...