AclPermissionsFacet fault install SQL-2008-R2
- by photo_tom
While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules.
Module that is failing is AclPermissionsFacet - with this 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."
In the log file "Detail_GlobalRules.txt", I've been able to find the following error messages -
2010-09-05 07:24:39 Slp: Could not
open sub key key
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSearch.
2010-09-05 07:24:39 Slp: Could not
open sub key key
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\SQLServerSCP.
2010-09-05 07:24:39 Slp: Could not
open sub key key
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQLServer.
2010-09-05 07:24:39 Slp: Could not
open sub key key
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\SQLServerAgent.
When I look at these keys in the registry, all of their permissions are blank. My problem is that I cannot find any good information on how to reset these keys. This is on my new home dev and I think during the migration from my previous machine, these settings got corrupted on my new box. In reviewing the web, there doesn't seem to be good infomration. And what there is suggests using subinacl.exe. But after trying it and seeing it is an XP based program, I'm at a loss on how to continue.
Configuration - Windows 7/64bit Home Edition, SQL2008R2, 6gb ram.
Suggestions?
Su
