Home Dashboard Directory Help
Search

Rule 'Consistency validation for SQL Server registry keys' failed by Code Cambridge Ltd


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


3
0
Sign in
to vote
Type: Bug
ID: 668112
Opened: 5/12/2011 3:40:56 AM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

After uninstalling SQL Server 2008 R2 Standard and reinstalling, the following error occurs.
"Rule 'Consistency validation for SQL Server registry keys' failed". 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.

After checking the Install Logs I found that there was a missing file. 'FixSqlRegistryKey_x86'.
This is interesting as I was performing the x64 install and the directory was \x64.

As a temporary workaround I just extracted the missing 'FixSqlRegistryKey_x86.exe' file into the \x64 directory from the \x86 directory and re-ran setup.

I did not have to adjust any registry keys as the help indicated.

Details
Sign in to post a comment.
Posted by Microsoft on 6/13/2011 at 11:30 AM
Hello,

Thank you for your time providing this feedback. We are at this time resolving this as not repro. Please do not hesitate to reactivate the issue once repro steps are provided.

Thanks,
Microsoft SQL Server
Posted by Microsoft on 5/24/2011 at 11:51 AM
Hello,

From the logs provided, there is no indication of SQL unintentionally deleting this particular file. Can you please provide the steps you created the initial media starting from your MSDN download for us to understand possible points of failure?

Thanks,
Microsoft SQL Server
Posted by Code Cambridge Ltd on 5/20/2011 at 2:06 AM
2011-05-12 11:16:00 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.AclPermissionsFacet
2011-05-12 11:16:00 Slp: Launching external tool: C:\TEMP\en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546\x64\FixSqlRegistryKey_x64.exe
2011-05-12 11:16:00 Slp: ------------------------------------------------------------
2011-05-12 11:16:00 Slp: ------------------------------------------------------------
2011-05-12 11:16:00 Slp: C:\TEMP\en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546\x64\FixSqlRegistryKey_x64.exe exit code: 0
2011-05-12 11:16:00 Slp: Launching external tool: C:\TEMP\en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546\x64\FixSqlRegistryKey_x86.exe
2011-05-12 11:16:00 Slp: File C:\TEMP\en_sql_server_2008_r2_standard_x86_x64_ia64_dvd_521546\x64\FixSqlRegistryKey_x86.exe does not exist!
2011-05-12 11:16:00 Slp: Rule 'AclPermissionsFacet' detection result: AreSqlAclPermissionsCanonical= False
2011-05-12 11:16:00 Slp: Evaluating rule        : AclPermissionsFacet
2011-05-12 11:16:00 Slp: Rule running on machine: XXXX-XXXX
2011-05-12 11:16:00 Slp: Rule evaluation done : Failed
2011-05-12 11:16:00 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.
2011-05-12 11:16:00 Slp: Send result to channel : RulesEngineNotificationChannel
Posted by Microsoft on 5/17/2011 at 11:56 AM
Hello,

Thank you for your feedback. Can you please provide logs located at%Program Files%\Microsoft SQL Server\100\Setup Bootstrap\Log so we can investigate this further?

Thanks,
Microsoft SQL Server
Sign in to post a workaround.
Posted by Code Cambridge Ltd on 5/12/2011 at 3:41 AM
As a temporary workaround I just extracted the missing 'FixSqlRegistryKey_x86.exe' file into the \x64 directory from the \x86 directory and re-ran setup.