Tuesday, August 17, 2010

Install SQL Server 2008 Cumulative Update 9 or Service Pack 1 on Windows Server 2008

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