SQL Server 2008 R2 - Consistency validation for SQL Server registry keys failed

Article ID

ias-10803

Article Name

SQL Server 2008 R2 - Consistency validation for SQL Server registry keys failed

Created Date

3rd January 2013

Product

Problem

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.

Resolution

To resolve this problem you will need give the registry key adequate permissions: IMPORTANT: It is 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. Please make sure you modify only the keys specified.

Click Start and select Run.

In the Run box, type regedit.

Browse to the following key: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MICROSOFTBCM\MSSQLServer\\SuperSocketNetLib\Lpc. 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.

Right-click on the key and select Properties.

Click on the Security tab.

Click the Security tab, and select the Everyone user.

Check the box for Full Control and then click OK.

Close the Windows Registry.

Attempt to install SQL Server 2008 R2.

Share This Page