Consistency Validation For SQL Server Registry Keys

SQL SERVER || 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.