none
2nd node in FCI fails to install SQL Server 2016 RRS feed

  • Question

  • I have a two node Windows Server 2016 cluster built. Windows Cluster validation passes, but when I go to install SQL Server 2016 on the second node, it fails after clicking on "Add node to a SQL Server Failover Cluster".

    I have copied a part of the log file created when the failure occurred. 

    When I remove node from Windows Cluster, SQL Server install starts just fine.

    (01) 2018-10-19 16:37:09 Slp: Running Action: ExecuteOuterSetupStartUI
    (08) 2018-10-19 16:37:09 Slp: ----------------------------------------------------------------------
    (08) 2018-10-19 16:37:09 Slp: Running Action: SearchUpdatesAction
    (01) 2018-10-19 16:37:09 Slp: Workflow to execute: 'OUTERSETUPSTARTUI'
    (01) 2018-10-19 16:37:09 Slp: ----------------------------------------------------------------------
    (01) 2018-10-19 16:37:09 Slp: Running Action: RunRemoteDiscoveryAction
    (08) 2018-10-19 16:37:09 Slp: Discovered update on path E:\PCUSOURCE; Update: Microsoft SQL Server 2016  with SP2, Type: PCU, KB: 4052908, Baseline: 13.0.1601, Version: 13.2.5026
    (01) 2018-10-19 16:37:09 Slp: Running discovery on remote machine: SAM
    (01) 2018-10-19 16:37:09 Slp: Running discovery on local machine
    (08) 2018-10-19 16:37:09 Slp: Using service ID '7971f918-a847-4430-9279-4a52d1efe18d' to search product updates.
    (09) 2018-10-19 16:37:09 Slp: Searching updates on server: '7971f918-a847-4430-9279-4a52d1efe18d'
    (01) 2018-10-19 16:37:10 Slp: Discovery on SAM failed due to exception
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.

       at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
       at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
       at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocallyCachedLocalMachineSubKey(ServiceContainer ctx, String machineName, SqlRegistryKey key)
       at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.TryLocallyCacheRegistryKey(ServiceContainer ctx, String machineName, SqlRegistryKey machineKey, String registryPath, RegistryView regView, String regPath, RegistryAccess registryAccess, Boolean& alreadyCached)
       at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
       at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
       at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
       at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
       at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
       at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
       at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryTask.ProcessDTbl(DataTable dt, Int32 level)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryTask.CollectSqlDiscoveryData()
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryTask.CollectDiscoveryData()
    (01) 2018-10-19 16:37:10 Slp: Discovery on local machine is complete
    (01) 2018-10-19 16:37:10 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction" threw an exception during execution.
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocallyCachedLocalMachineSubKey(ServiceContainer ctx, String machineName, SqlRegistryKey key)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.TryLocallyCacheRegistryKey(ServiceContainer ctx, String machineName, SqlRegistryKey machineKey, String registryPath, RegistryView regView, String regPath, RegistryAccess registryAccess, Boolean& alreadyCached)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    (01) 2018-10-19 16:37:10 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution.
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocallyCachedLocalMachineSubKey(ServiceContainer ctx, String machineName, SqlRegistryKey key)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.TryLocallyCacheRegistryKey(ServiceContainer ctx, String machineName, SqlRegistryKey machineKey, String registryPath, RegistryView regView, String regPath, RegistryAccess registryAccess, Boolean& alreadyCached)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    (01) 2018-10-19 16:37:10 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution.
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocallyCachedLocalMachineSubKey(ServiceContainer ctx, String machineName, SqlRegistryKey key)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.TryLocallyCacheRegistryKey(ServiceContainer ctx, String machineName, SqlRegistryKey machineKey, String registryPath, RegistryView regView, String regPath, RegistryAccess registryAccess, Boolean& alreadyCached)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    --- End of inner exception stack trace ---
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    (01) 2018-10-19 16:37:10 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    (01) 2018-10-19 16:37:10 Slp: Received request to add the following file to Watson reporting: C:\Users\rbiehl.adm\AppData\Local\Temp\tmp7AAE.tmp
    (01) 2018-10-19 16:37:10 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    (01) 2018-10-19 16:37:10 Slp: Inner exceptions are being indented
    (01) 2018-10-19 16:37:10 Slp: 
    (01) 2018-10-19 16:37:10 Slp: Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException
    (01) 2018-10-19 16:37:10 Slp:     Message: 
    (01) 2018-10-19 16:37:10 Slp:         Failed to retrieve data for this request.
    (01) 2018-10-19 16:37:10 Slp:     HResult : 0x80131500
    (01) 2018-10-19 16:37:10 Slp:     Data: 
    (01) 2018-10-19 16:37:10 Slp:       HelpLink.ProdName = Microsoft SQL Server
    (01) 2018-10-19 16:37:10 Slp:       HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
    (01) 2018-10-19 16:37:10 Slp:       HelpLink.LinkId = 20476
    (01) 2018-10-19 16:37:10 Slp:     Stack: 
    (01) 2018-10-19 16:37:10 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
    (01) 2018-10-19 16:37:10 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
    (01) 2018-10-19 16:37:10 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    (01) 2018-10-19 16:37:10 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
    (01) 2018-10-19 16:37:10 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
    (01) 2018-10-19 16:37:10 Slp:     Inner exception type: System.ComponentModel.Win32Exception
    (01) 2018-10-19 16:37:10 Slp:         Message: 
    (01) 2018-10-19 16:37:10 Slp:                 Not all privileges or groups referenced are assigned to the caller.
    (01) 2018-10-19 16:37:10 Slp:                 
    (01) 2018-10-19 16:37:10 Slp:         HResult : 0x80004005
    (01) 2018-10-19 16:37:10 Slp:         Error : 1300
    (01) 2018-10-19 16:37:10 Slp:         Stack: 
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocallyCachedLocalMachineSubKey(ServiceContainer ctx, String machineName, SqlRegistryKey key)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.TryLocallyCacheRegistryKey(ServiceContainer ctx, String machineName, SqlRegistryKey machineKey, String registryPath, RegistryView regView, String regPath, RegistryAccess registryAccess, Boolean& alreadyCached)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
    (01) 2018-10-19 16:37:10 Slp:                 at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
    (09) 2018-10-19 16:37:12 Slp: Search for updates completed as 'Succeeded', number of updates found: 0
    (08) 2018-10-19 16:37:12 Slp: Update: {Name: Microsoft SQL Server 2016  with SP2; KB Article: 4052908; Version: 13.2.5026.0; Achitecture: x64; Language: 1033; Update Type: PCU} is considered to be selected for installation.
    (08) 2018-10-19 16:37:12 Slp: Update: {Name: Microsoft SQL Server 2016  with SP2; KB Article: 4052908; Version: 13.2.5026.0; Achitecture: x64; Language: 1033; Update Type: PCU} is available but is temporarily not considered to be selected for installation, because its update type 'PCU' does not match the update type 'CU' that setup is currently looking for.
    (08) 2018-10-19 16:37:12 Slp: Update: {Name: Microsoft SQL Server 2016  with SP2; KB Article: 4052908; Version: 13.2.5026.0; Achitecture: x64; Language: 1033; Update Type: PCU} is available but is temporarily not considered to be selected for installation, because its update type 'PCU' does not match the update type 'Setup' that setup is currently looking for.
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp: Microsoft Update Details:
    (08) 2018-10-19 16:37:12 Slp:   Category ID searched on Microsoft Update:          892C0584-8B03-428f-9A74-224FCD6887C0
    (08) 2018-10-19 16:37:12 Slp:   Major version of the Windows Update Agent:         8
    (08) 2018-10-19 16:37:12 Slp:   Minor version of the Windows Update Agent:         0
    (08) 2018-10-19 16:37:12 Slp:   Version of Wuapi.dll:                              10.0.14393.2368
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp:   SQL Server updates discovered:
    (08) 2018-10-19 16:37:12 Slp:   SQL Server updates available for installation:
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp: Available Product Updates Discovered:
    (08) 2018-10-19 16:37:12 Slp:   Title:                         Microsoft SQL Server 2016  with SP2
    (08) 2018-10-19 16:37:12 Slp:   Knowledge Based Article:       KB 4052908
    (08) 2018-10-19 16:37:12 Slp:   Version:                       13.2.5026.0
    (08) 2018-10-19 16:37:12 Slp:   Architecture:                  x64
    (08) 2018-10-19 16:37:12 Slp:   Language:                      1033
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp: Product Updates Selected for Installation:
    (08) 2018-10-19 16:37:12 Slp:   Title:                         Microsoft SQL Server 2016  with SP2
    (08) 2018-10-19 16:37:12 Slp:   Knowledge Based Article:       KB 4052908
    (08) 2018-10-19 16:37:12 Slp:   Version:                       13.2.5026.0
    (08) 2018-10-19 16:37:12 Slp:   Architecture:                  x64
    (08) 2018-10-19 16:37:12 Slp:   Language:                      1033
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp:   Update Source:                 Slipstream
    (08) 2018-10-19 16:37:12 Slp: 
    (08) 2018-10-19 16:37:12 Slp: Completed Action: SearchUpdatesAction, returned True
    (01) 2018-10-19 16:37:18 Slp: Watson Bucket 2 
     Original Parameter Values 

    (01) 2018-10-19 16:37:18 Slp: Parameter 0 : SQL Server 2016@RTM@ 

    (01) 2018-10-19 16:37:18 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData 

    (01) 2018-10-19 16:37:18 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege 

    (01) 2018-10-19 16:37:18 Slp: Parameter 3 : Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException@-2146233088 

    (01) 2018-10-19 16:37:18 Slp: Parameter 4 : System.ComponentModel.Win32Exception@-2147467259 

    (01) 2018-10-19 16:37:18 Slp: Parameter 5 : RunRemoteDiscoveryAction 

    (01) 2018-10-19 16:37:18 Slp: Parameter 8 : 1300 

    (01) 2018-10-19 16:37:18 Slp: 
     Final Parameter Values 

    (01) 2018-10-19 16:37:18 Slp: Parameter 0 : SQL Server 2016@RTM@ 

    (01) 2018-10-19 16:37:18 Slp: Parameter 1 : 0x360C804A 

    (01) 2018-10-19 16:37:18 Slp: Parameter 2 : 0xB2652E58 

    (01) 2018-10-19 16:37:18 Slp: Parameter 3 : 0x74E34741 

    (01) 2018-10-19 16:37:18 Slp: Parameter 4 : 0xDC80C325 

    (01) 2018-10-19 16:37:18 Slp: Parameter 5 : RunRemoteDiscoveryAction 

    (01) 2018-10-19 16:37:18 Slp: Parameter 8 : 0xA05EFA62 

    (01) 2018-10-19 16:37:19 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20181019_163706\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    (01) 2018-10-19 16:37:19 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20181019_163706\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    (01) 2018-10-19 16:37:19 Slp: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error The system cannot find the file specified.

    (01) 2018-10-19 16:37:19 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20181019_163706\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    (01) 2018-10-19 16:37:19 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20181019_163706\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    (01) 2018-10-19 16:37:19 Slp: Sco: Unable to open hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer, error The system cannot find the file specified.

    (01) 2018-10-19 16:37:19 Slp: Failed to retrieve data for this request.
    (01) 2018-10-19 16:37:19 Slp: Watson bucket for exception based failure has been created
    (01) 2018-10-19 16:37:19 Slp: WER: Application level consent value 'True' was mapped to consent status 'WerConsentApproved'
    (01) 2018-10-19 16:37:23 Slp: WER: Result of the submission:: 'WerReportUploaded'
    (01) 2018-10-19 16:37:23 Slp: WER: Submitted 1 of 1 failures to the Watson data repository
    (01) 2018-10-19 16:37:23 Slp: Sco: File 'C:\Windows\system32\Cluster.exe' does not exist
    (01) 2018-10-19 16:37:23 Slp: Collecting Cluster Logs using PowerShell:
    (01) 2018-10-19 16:37:23 Slp: Running: Powershell.exe -ImportSystemModules -ExecutionPolicy Unrestricted -command Get-ClusterLog -Destination 'C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20181019_163706' -Node 'SAMANTHA' -TimeSpan 1
    (10) 2018-10-19 16:37:26 Slp: 
    (12) 2018-10-19 16:37:26 Slp: Mode                LastWriteTime         Length Name                                                                  
    (12) 2018-10-19 16:37:26 Slp: ----                -------------         ------ ----                                                                  
    (12) 2018-10-19 16:37:26 Slp: -a----       10/19/2018   4:37 PM          73352 SAMANTHA_cluster.log                                                  
    (12) 2018-10-19 16:37:26 Slp: 
    (12) 2018-10-19 16:37:26 Slp: 
    (01) 2018-10-19 16:37:26 Slp: Process returned 0
    (01) 2018-10-19 16:37:26 Slp: Cluster log generation completed successfully
    (01) 2018-10-19 16:37:26 Slp: Dumping final cluster state.
    (01) 2018-10-19 16:37:29 Slp: Completed dumping final cluster state.
    (01) 2018-10-19 16:37:29 Slp: SetupTelemetry: Writing Telemetry to Datastore
    (01) 2018-10-19 16:37:30 Slp: 
    (01) 2018-10-19 16:37:30 Slp: ----------------------------------------------------------------------
    (01) 2018-10-19 16:37:30 Slp: 
    (01) 2018-10-19 16:37:30 Slp: Error result: -2146233088
    (01) 2018-10-19 16:37:30 Slp: Result facility code: 19
    (01) 2018-10-19 16:37:30 Slp: Result error code: 5376
    (01) 2018-10-19 16:37:30 Slp: SetupTelemetry: Closing Telemetry Session
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to get registry value MachineId
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\130
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to get registry value CustomerFeedback
    (01) 2018-10-19 16:37:30 Slp: Sco: Attempting to get registry value EnableErrorReporting
    (01) 2018-10-19 16:37:30 Slp: SetupTelemetry: Telemetry has an active session with 4 events.


    EDIT: Nothing from the Install Wizard screen works when I click, to include System Configuration Checker. Only time anything works is when node is not part of Windows Cluster.
    Monday, October 22, 2018 2:57 PM

All replies


  • (01) 2018-10-19 16:37:09 Slp: Running discovery on remote machine: SAM
    (01) 2018-10-19 16:37:09 Slp: Running discovery on local machine
    (08) 2018-10-19 16:37:09 Slp: Using service ID '7971f918-a847-4430-9279-4a52d1efe18d' to search product updates.
    (09) 2018-10-19 16:37:09 Slp: Searching updates on server: '7971f918-a847-4430-9279-4a52d1efe18d'
    (01) 2018-10-19 16:37:10 Slp: Discovery on SAM failed due to exception
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.

    I answered a similar question long back see if that helps. The issue is related to account with which you are running sql server setup it does not have privilege to perform *some* action on remote machine.

    There is Support Article which says what all rights are required


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, October 22, 2018 3:12 PM
    Moderator
  • Hey Shashank,

    The account that I am logged in as to do the install is a Domain Administrator. Domain Administrators are added to the local Administrators group. Do I need to specifically assign the account to local Administrators group?

    Also, the SID that is being referenced in the logs does not look like the SID of the account being used. Is there an account that is grabbed when the SQL Installer program opens?

    Thanks,

    Robert 

    Monday, October 22, 2018 5:02 PM
  • Hello Hilary,

    I do believe I ran across this thread and may have dismissed it as I am using a Domain Administrator account to install SQL.

    I will read through it a little more in detail and see if there is something here I may need to look at.

    Thanks,

    Robert

    Monday, October 22, 2018 5:04 PM
  • Hello Hilary,

    I looked over the article you referenced and it did not provide the solution. Still on the hunt. Have you come across anything else?

    Thanks,

    Robert

    Monday, October 22, 2018 11:02 PM
  • Hello Shashank,

    I attempted the fixes you pointed out in your response to no avail. Is there anything else you can think of that would assist?

    Thanks,

    Robert

    Monday, October 22, 2018 11:03 PM
  • Hello Shashank,

    I attempted the fixes you pointed out in your response to no avail. Is there anything else you can think of that would assist?

    Thanks,

    Robert

    Did you followed the MS support  article which talks about privilege , I have given that in my first reply

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, October 23, 2018 4:07 AM
    Moderator
  • I have set all privileges referenced in several forums. I have no firewalls active, I have given account local admin rights, I have ensured the local administrator account on both systems have same name and password. 

    If the node on which I am trying to add to the cluster is not in the Windows Cluster, Setup runs fine. After I connect it to the Windows Cluster, with the same account that I am using to install SQL, it fails with the above in original post.

    Tuesday, October 23, 2018 3:14 PM
  • In high security environment even admins are not given certain permissions. The error comes when process is trying to set something which uses AdjustTokenPrivilege, this is where error is coming. I strongly suggest you to read below blog and Assign privileges mentioned in below blog to account you are using to install. Also made sure you right click on setup and select run as administrator

    https://blogs.technet.microsoft.com/fort_sql/2009/12/17/installing-sql-server-2008-services-in-a-high-security-domain/


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Proposed as answer by Puzzle_Chen Thursday, October 25, 2018 7:23 AM
    Tuesday, October 23, 2018 4:35 PM
    Moderator
  • Hi Robert, 

    This is not abnormal.  Hilary Cotter pointed another thread which is helpful I recommend to read through.  However based on my experiences, the most possible reason was related to service running on another nodes: 

    Let's go back to the log you provided, first search: "Error:" You would find the following: 

    01) 2018-10-19 16:37:10 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction" threw an exception during execution.
    (01) 2018-10-19 16:37:10 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller.

    The reason you saw this error, was possibly because of the a specific service running on another node. The service name is:  Remote Registry.  Please check if this service was disabled or stopped. If so, please enable and start it. 

    The action "Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction" was called to check all other nodes involved in the windows cluster for a few information.  If this specific service is not running on any of other nodes, you would get this error. 

    Please try and let us know if this solved your problem. 

    Regards

    -zen


    SQL Server MCM/AWS SAP/Vmware VCP

    Thursday, December 5, 2019 2:01 PM