none
Consistency validation for SQL Server registry keys for SQL 2012 ent installation

    Question

  • Hi,

    I have SQL 2008 R2 Sp x64 installed on Windows 2008 R2. When I try to install SQL 2012 Ent x64 separately, I am getting the error 

    "Consistency validation for SQL Server registry keys" failed

    I uninstalled, all components of SQL 2008 R2 as per MSKB, however still not able to install SQL 2012 Ent x64.

    I do not have any issues, re installing SQL 2008 R2 SP X64. but for some reason SQL 2012 Ent X64 is not getting installed.

    I checked the registry entries and the corresponding permission(added local admin, users,everyone with full control and inheritence) - OK, but same error while installing 2012

    I stopped all SQL services and tried installing SQL 2012 - Same error.

    This is my bootstrap Log : Any Help would be great. Thanks in advance !!

    (07) 2013-02-09 09:23:17 Slp: Rule evaluation done   : Succeeded
    (07) 2013-02-09 09:23:17 Slp: Rule evaluation message: The Windows Management Instrumentation (WMI) service is running.
    (07) 2013-02-09 09:23:17 Slp: Send result to channel : RulesEngineNotificationChannel
    (07) 2013-02-09 09:23:17 Slp: Initializing rule      : Consistency validation for SQL Server registry keys
    (07) 2013-02-09 09:23:17 Slp: Rule is will be executed  : True
    (07) 2013-02-09 09:23:17 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.AclPermissionsFacet
    (07) 2013-02-09 09:23:17 Slp: Launching external tool: D:\SQLSERVER_2012_R2_Evaluvate\x64\FixSqlRegistryKey_x64.exe
    (07) 2013-02-09 09:23:17 Slp: ------------------------------------------------------------
    (08) 2013-02-09 09:23:26 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer - OK.
    (08) 2013-02-09 09:23:26 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client - OK.
    (08) 2013-02-09 09:23:26 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SuperSocketNetLib - OK.
    (08) 2013-02-09 09:23:26 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect - OK.
    (07) 2013-02-09 09:23:26 Slp: ------------------------------------------------------------
    (07) 2013-02-09 09:23:26 Slp: D:\SQLSERVER_2012_R2_Evaluvate\x64\FixSqlRegistryKey_x64.exe exit code: 0
    (07) 2013-02-09 09:23:26 Slp: Launching external tool: D:\SQLSERVER_2012_R2_Evaluvate\x64\FixSqlRegistryKey_x86.exe
    (07) 2013-02-09 09:23:26 Slp: ------------------------------------------------------------
    (07) 2013-02-09 09:23:34 Slp: ------------------------------------------------------------
    (07) 2013-02-09 09:23:34 Slp: D:\SQLSERVER_2012_R2_Evaluvate\x64\FixSqlRegistryKey_x86.exe exit code: -1073741701
    (07) 2013-02-09 09:23:34 Slp: Rule 'AclPermissionsFacet' detection result: AreSqlAclPermissionsCanonical= False
    (07) 2013-02-09 09:23:34 Slp: Evaluating rule        : AclPermissionsFacet
    (07) 2013-02-09 09:23:34 Slp: Rule running on machine: <Server Name>
    (07) 2013-02-09 09:23:34 Slp: Rule evaluation done   : Failed
    (07) 2013-02-09 09:23:34 Slp: Rule evaluation message: The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys.
    (07) 2013-02-09 09:23:34 Slp: Send result to channel : RulesEngineNotificationChannel
    (07) 2013-02-09 09:23:34 Slp: Initializing rule      : Long path names to files on SQL Server installation media
    (07) 2013-02-09 09:23:34 Slp: Rule is will be executed  : True
    (07) 2013-02-09 09:23:34 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.MediaPathLenghtFacet
    (07) 2013-02-09 09:23:34 Slp: Rule 'MediaPathLength' INSTALLMEDIAPATH length is 41
    (07) 2013-02-09 09:23:34 Slp: Evaluating rule        : MediaPathLength


    Saturday, February 09, 2013 5:30 AM

Answers

  • Thanks Mark, Thanks Ahmed !!

    Downloaded another ISO of SQL 2012 Ent x64 Sp1 and that worked. I guess my previous ISO had some issues while downloading.

    Instead of spending hours with the existing media, I should have done this at the first attempt. Sometime, I laugh on my own stupid act.

    Thanks again :)


    • Marked as answer by Chuck Sumit Sunday, February 10, 2013 3:14 PM
    • Edited by Chuck Sumit Sunday, February 10, 2013 3:16 PM
    Sunday, February 10, 2013 3:14 PM

All replies

  • Copy the installation media locally to your server instance and run the installer again. This should work around this problem but let me know if it doesnt.

    ...there is also a connect item work around that you might want to try in case the above does not work http://connect.microsoft.com/SQLServer/feedback/details/668112/rule-consistency-validation-for-sql-server-registry-keys-failed


    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog|SQLCloud)


    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    Watch my sessions at the PASS Summit 2012


    • Edited by retracement Saturday, February 09, 2013 9:54 AM added the connect item
    Saturday, February 09, 2013 9:45 AM
  • Would you please check-out below thread 

    http://social.msdn.microsoft.com/Forums/en-AU/sqlsetupandupgrade/thread/23856ac2-35cb-4fc1-bae9-2056267f753d


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Saturday, February 09, 2013 1:50 PM
    Moderator
  • Thanks Mark, Thanks Ahmed !!

    Downloaded another ISO of SQL 2012 Ent x64 Sp1 and that worked. I guess my previous ISO had some issues while downloading.

    Instead of spending hours with the existing media, I should have done this at the first attempt. Sometime, I laugh on my own stupid act.

    Thanks again :)


    • Marked as answer by Chuck Sumit Sunday, February 10, 2013 3:14 PM
    • Edited by Chuck Sumit Sunday, February 10, 2013 3:16 PM
    Sunday, February 10, 2013 3:14 PM
  • The issue occur when the installer unable to update the registry entries due to lack of permission. Please follow the below steps to resolved the issue.

    1. Go to RUN –> Type regedit.

    2. Locate HKEY_LOCAL_MACHINE -> SOFTWARE -> MICROSOFT -> Microsoft SQL Server in the registry

    3. Right click and select Permissions…

    4. Click on Advanced

    5. Under Permission TAB, select “Replace permission entries on all child objects with entries shown here that apply to child objects”.

    6. Click OK.

    7. Now Re-run the Check Rule if SQL Installer is already opened. or Re-run the SQL Server installer.


    Abhimanyu Panwar

    Wednesday, September 10, 2014 12:37 PM