While trying to install SQL Server 2008 Cumulative Update I kept getting this error
Attempted to perform an unauthorized operation
the SQL Server log located at
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\
showed the following
2010-08-17 13:01:34 Slp: Message:
2010-08-17 13:01:34 Slp: Attempted to perform an unauthorized operation.
2010-08-17 13:01:34 Slp: Data:
2010-08-17 13:01:34 Slp: WatsonData = Uninstall@{F692770D-0E27-4D3F-8386-F04C6F434040}
2010-08-17 13:01:34 Slp: DisableRetry = true
2010-08-17 13:01:34 Slp: Stack:
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey(String subkey, RegistryAccess requestedAccess)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.ArpRegKey.CleanupPatchedProductRegistryInfo()
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.ExecuteAction(String actionId)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.GetInstalledPackages(String instanceName, List`1& installedInstancePackages, List`1& installedSharedPackages, String& returnedErrorMessage)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2010-08-17 13:01:34 Slp: Inner exception type: System.UnauthorizedAccessException
2010-08-17 13:01:34 Slp: Message:
2010-08-17 13:01:34 Slp: Attempted to perform an unauthorized operation.
2010-08-17 13:01:34 Slp: Stack:
2010-08-17 13:01:34 Slp: at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey(String subkey, RegistryAccess requestedAccess)
2010-08-17 13:01:47 Slp: Watson Bucket 1
Original Parameter Values
2010-08-17 13:01:47 Slp: Parameter 0 : SQL2008@RTM@KB979065
2010-08-17 13:01:47 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey
2010-08-17 13:01:47 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey
2010-08-17 13:01:47 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1
2010-08-17 13:01:47 Slp: Parameter 4 : System.UnauthorizedAccessException@-2147024891
2010-08-17 13:01:47 Slp: Parameter 5 : InitializeUIDataAction
2010-08-17 13:01:47 Slp: Parameter 7 : Uninstall@{F692770D-0E27-4D3F-8386-F04C6F434040}
2010-08-17 13:01:47 Slp: Parameter 8 : Uninstall@{F692770D-0E27-4D3F-8386-F04C6F434040}
The solution to this turned out to be to go into regedit and set the permissions of Administrators to Write as well as read for all the SQL Server related Uninstalls in the following path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\
some of the ones I had to set are
{F5FEEB7E-F647-4D18-85BA-096750A15547} (SSIS)
{F01EC9B9-21B4-441E-958A-1E01098B03BE} (SSAS)
Thanks,
Khaled Auf
No comments:
Post a Comment