none
Add a node 2008 failed with "Access is Denied"

    Question

  • Hi,

    I'm installing SQL 2008 on a windows 2003 cluster node and had several failures, the DB Engine being one of them.  Here is the detail error message for the first 'Access is Denied' Message for the Database Engine Services:

    2010-04-01 09:30:48 ACE: BeginClusterInstall started
    2010-04-01 09:30:48 ACE: UpdateClusterResource started
    2010-04-01 09:30:48 ACE: ConfigureSQLAgentResourceType started
    2010-04-01 09:30:48 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-01 09:30:48 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\Setup
    2010-04-01 09:30:48 Slp: Sco: Attempting to get registry value SQLPath
    2010-04-01 09:30:48 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-01 09:30:48 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\Setup
    2010-04-01 09:30:48 Slp: Sco: Attempting to get registry value SQLPath
    2010-04-01 09:30:48 ACE: Updating agent resource dll. Source: 'D:\Program Files\Microsoft SQL Server\MSSQL10.DEV08\MSSQL\Binn\SQAGTRES.DLL', Target: 'C:\WINDOWS\system32\SQAGTRES.DLL'
    2010-04-01 09:30:48 ACE: The source DLL ('C:\WINDOWS\system32\SQAGTRES.DLL') exists = 'True'.
    2010-04-01 09:30:48 ACE: Type 'SQL Server Agent' exists ...
    2010-04-01 09:30:48 ACE: Type 'SQL Server Agent' has 3 resources. Performing upgrade ...
    2010-04-01 09:30:48 ACE: File versions : ['D:\Program Files\Microsoft SQL Server\MSSQL10.DEV08\MSSQL\Binn\SQAGTRES.DLL':2007.2007.1600.22], ['C:\WINDOWS\system32\SQAGTRES.DLL':2005.2005.1399.0]. ShouldCopy = 'True'
    2010-04-01 09:30:48 ACE: Upgrading resource type 'SQL Server Agent' using resource for instance 'MSSQLSERVER' as reference ...
    2010-04-01 09:30:48 Slp: Configuration action failed for feature MPT_AGENT_CORE_CNI during timing ConfigNonRC and scenario ConfigNonRC.
    2010-04-01 09:30:48 Slp: Access is denied
    2010-04-01 09:30:48 Slp: Configuration action failed for feature MPT_AGENT_CORE_CNI during timing ConfigNonRC and scenario ConfigNonRC.
    2010-04-01 09:30:49 Slp: System.ComponentModel.Win32Exception: Access is denied
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.UpgradeResourceDLL(String nodeName, String dllPathName)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.SQLAgentFeature.UpgradeResourceDLL(SQLAgentResource sqlAgentResource, String sourceName, String targetName)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.SQLAgentFeature.ConfigureSQLAgentResourceType()
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.UpdateClusterResource()
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.BeginClusterInstall(String agentSID, String agentPrincipal, String enginePrincipalSID, String enginePrincipal)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.AddNode_ConfigNonRC(Dictionary`2 actionData, PublicConfigurationBase spcb)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.AddNode(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2010-04-01 09:30:49 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)

    2010-04-01 09:30:49 Slp: Exception: System.ComponentModel.Win32Exception.
    2010-04-01 09:30:49 Slp: Source: Microsoft.SqlServer.Configuration.Cluster.
    2010-04-01 09:30:49 Slp: Message: Access is denied.
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-04-01 09:30:50 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100401_090008\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2010-04-01 09:30:58 Slp: Access is denied
    2010-04-01 09:30:58 Slp: Watson bucket for exception based failure has been created

     

     

    Thursday, April 01, 2010 5:08 PM

Answers

  • The solution was to run the slipstream install:  http://support.microsoft.com/kb/955392

    When I first tried it last Thursday, the primary node had not been updated to sp1, which I thought was the case.

    Wednesday, April 07, 2010 10:38 PM

All replies

  • I added the second node to the available owners of the SQL related services in the Cluster Admin and the services can now failover and I can connect to the DB Engine.  Still, I don't feel very comfortable with this.
    Thursday, April 01, 2010 5:29 PM
  • Running the SP1 update gets me this error - so things are definitely not right.

    TITLE: SQL Server Setup failure.
    ------------------------------

    SQL Server Setup has encountered the following error:


    A failure was detected for a previous installation, patch, or repair for instance 'DEV08' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

    Error code 0x84B20001.

    ------------------------------

    Thursday, April 01, 2010 7:55 PM
  • I have tried installing from a local disk and am unfortunately getting the same errors.
    Tuesday, April 06, 2010 3:42 PM
  • Lets try the following steps

    1) Start->Run->Secpol.msc

    2) Expand Local Policies and select User Rights Assignments.

    3) Look for Debug Program

    4) Add the user running the setup to this policy.

    Rerun the setup.

    Cheers,

    Feroz


    Mark as Answer if it helps. This posting is provided "AS IS" with no warranties and confers no rights.
    Tuesday, April 06, 2010 4:22 PM
  • Feroz,

    Thanks for your suggestion.

    I have gotten the same error.

    Tuesday, April 06, 2010 5:26 PM
  • Here are some more logs...

    Seems like it is trying to overwrite the SQAGTRES.DLL file and failing.  It's trying to overwrite a sqagtres.dll which belongs to a 2005 isntance on the machine.  Looking at node 1, this file has been overwritten and our 2005 instance continues to function, so I'm assuming the file is backwards compatible.  Hopefully this additional information helps.

    I have also been made domain admin and have the same issue.

    2010-04-07 10:00:28 ACE: Updating agent resource dll. Source: 'D:\Program Files\Microsoft SQL Server\MSSQL10.DEV08\MSSQL\Binn\SQAGTRES.DLL', Target: 'C:\WINDOWS\system32\SQAGTRES.DLL'
    2010-04-07 10:00:28 ACE: The source DLL ('C:\WINDOWS\system32\SQAGTRES.DLL') exists = 'True'.
    2010-04-07 10:00:28 ACE: Type 'SQL Server Agent' exists ...
    2010-04-07 10:00:28 ACE: Type 'SQL Server Agent' has 3 resources. Performing upgrade ...
    2010-04-07 10:00:28 ACE: File versions : ['D:\Program Files\Microsoft SQL Server\MSSQL10.DEV08\MSSQL\Binn\SQAGTRES.DLL':2007.2007.1600.22], ['C:\WINDOWS\system32\SQAGTRES.DLL':2005.2005.1399.0]. ShouldCopy = 'True'
    2010-04-07 10:00:28 ACE: Upgrading resource type 'SQL Server Agent' using resource for instance 'MSSQLSERVER' as reference ...
    2010-04-07 10:00:28 Slp: Configuration action failed for feature MPT_AGENT_CORE_CNI during timing ConfigNonRC and scenario ConfigNonRC.
    2010-04-07 10:00:28 Slp: Access is denied
    2010-04-07 10:00:28 Slp: Configuration action failed for feature MPT_AGENT_CORE_CNI during timing ConfigNonRC and scenario ConfigNonRC.
    2010-04-07 10:00:28 Slp: System.ComponentModel.Win32Exception: Access is denied
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.UpgradeResourceDLL(String nodeName, String dllPathName)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.SQLAgentFeature.UpgradeResourceDLL(SQLAgentResource sqlAgentResource, String sourceName, String targetName)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.SQLAgentFeature.ConfigureSQLAgentResourceType()
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.UpdateClusterResource()
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.BeginClusterInstall(String agentSID, String agentPrincipal, String enginePrincipalSID, String enginePrincipal)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.AddNode_ConfigNonRC(Dictionary`2 actionData, PublicConfigurationBase spcb)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.AddNode(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    2010-04-07 10:00:28 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    2010-04-07 10:00:28 Slp: Exception: System.ComponentModel.Win32Exception.
    2010-04-07 10:00:28 Slp: Source: Microsoft.SqlServer.Configuration.Cluster.
    2010-04-07 10:00:28 Slp: Message: Access is denied.
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2010-04-07 10:00:30 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100407_094709\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2010-04-07 10:00:34 Slp: Access is denied
    2010-04-07 10:00:34 Slp: Watson bucket for exception based failure has been created
    2010-04-07 10:00:45 Slp: Completed Action: AgentConfigAction_install_postmsi_Cpu64, returned False
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\UpgradeIncompleteState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
    2010-04-07 10:00:45 Slp: Sco: Attempting to get feature configuration state for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\ConfigurationState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\UpgradeIncompleteState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
    2010-04-07 10:00:45 Slp: Sco: Attempting to get feature configuration state for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature MPT_AGENT_CORE_CNI, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\ConfigurationState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
    2010-04-07 10:00:45 Slp: Error: Action "AgentConfigAction_install_postmsi_Cpu64" failed during execution.
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Replication_Core_Inst, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\UpgradeIncompleteState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value SQL_Replication_Core_Inst
    2010-04-07 10:00:45 Slp: Sco: Attempting to get feature configuration state for feature SQL_Replication_Core_Inst, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature SQL_Replication_Core_Inst, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\ConfigurationState
    2010-04-07 10:00:45 Slp: Sco: Attempting to get registry value SQL_Replication_Core_Inst
    2010-04-07 10:00:45 Slp: Sco: Attempting to set feature configuration state FailedConfigured for feature SQL_Replication_Core_Inst, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to set instance feature flag ConfigurationState for machine , feature SQL_Replication_Core_Inst, instance MSSQL10.DEV08
    2010-04-07 10:00:45 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey
    2010-04-07 10:00:45 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\ConfigurationState
    2010-04-07 10:00:45 Slp: Sco: Attempting to set value SQL_Replication_Core_Inst
    2010-04-07 10:00:45 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.DEV08\ConfigurationState, Name = SQL_Replication_Core_Inst

    Wednesday, April 07, 2010 5:26 PM
  • Great, Good to know that. Are you still having other issue, if so post the other errors as well. I will see what best i can do.

    Cheers,

    Feroz


    Mark as Answer if it helps. This posting is provided "AS IS" with no warranties and confers no rights.
    Wednesday, April 07, 2010 5:27 PM
  • I am still having the same issues, I simply posted more of the error log since the actions of copying the dll from one directory to another seemed relevant.

    We noticed that the event log noted that the install media for office web components was not found several times during the install.

    I tried repairing that install and then removed it.  Both times I received a fatal error, but the uninstall seems to have worked.

    I am now trying to remove the node and reinstall but have received the same error.  However there is no longer the event logs about the OWC. 

    So I am still stuck and past my deadline for having this installed :(

     

     

    Wednesday, April 07, 2010 8:10 PM
  • I have reinstalled logging in with mstsc /console and had yet another failure. I cannot think of any other things to try...
    Wednesday, April 07, 2010 8:49 PM
  • The solution was to run the slipstream install:  http://support.microsoft.com/kb/955392

    When I first tried it last Thursday, the primary node had not been updated to sp1, which I thought was the case.

    Wednesday, April 07, 2010 10:38 PM