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.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.