Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 adding 3rd node to 3 instance 2008 R2 cluster

Author  Topic 

SideOfBacon
Starting Member

1 Post
Posted - 2012-01-20 : 15:01:29
I have presented a 3rd node to a 2 node 2008 R2 cluster and am having issues getting SQL 2008 R2 SP1 (slipstreamed) to install to the new node in order to support the 3 instances from being able to run on this new node. I have successfully gotten it added to the cluster and validated. when trying to install SQL it gets about 95% of the way through the install and crashes out with the following error:

The specified node does not support a resource of this type. This may be due to version inconsistencies or due to the absence of the resource DLL on this node. (Exception from HRESULT: 0x800713D7)

Below is the information from the detail log where errors were present:

2012-01-20 11:13:49 Slp: Adding possible owner node 'node3' to resource 'SQL Server (INSTANCE1)'
2012-01-20 11:13:50 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Startup and scenario Startup.
2012-01-20 11:13:50 Slp: The specified node does not support a resource of this type. This may be due to version inconsistencies or due to the absence of the resource DLL on this node. (Exception from HRESULT: 0x800713D7)
2012-01-20 11:13:50 Slp: The configuration failure category of current exception is ConfigurationFailure
2012-01-20 11:13:50 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Startup and scenario Startup.
2012-01-20 11:13:50 Slp: System.Runtime.InteropServices.COMException (0x800713D7): The specified node does not support a resource of this type. This may be due to version inconsistencies or due to the absence of the resource DLL on this node. (Exception from HRESULT: 0x800713D7)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Interop.MSClusterLib.ClusResPossibleOwnerNodesClass.AddItem(ClusNode pNode)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.Cluster.PossibleOwnerNodes.AddItem(ClusterResource parent, String nodeName)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SQLEngineClusterFeature.Join(String instanceName, String nodeName)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SQLServerFailoverCluster.JoinEngineFailoverCluster(String instanceName, String nodeName)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SQLServerFailoverCluster.JoinFailoverCluster(String instanceName)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install_Startup_ClusterComplete(EffectiveProperties properties)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2012-01-20 11:13:50 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2012-01-20 11:13:50 Slp: Exception: System.Runtime.InteropServices.COMException.
2012-01-20 11:13:50 Slp: Source: Microsoft.SqlServer.Interop.MSClusterLib.
2012-01-20 11:13:50 Slp: Message: The specified node does not support a resource of this type. This may be due to version inconsistencies or due to the absence of the resource DLL on this node. (Exception from HRESULT: 0x800713D7).
2012-01-20 11:13:50 Slp: Watson Bucket 1
Original Parameter Values


2012-01-20 11:13:51 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\20120120_112010\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2012-01-20 11:13:51 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\20120120_112010\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2012-01-20 11:13:51 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120120_112010\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2012-01-20 11:13:51 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\20120120_112010\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2012-01-20 11:13:51 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\20120120_112010\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2012-01-20 11:13:51 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120120_112010\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2012-01-20 11:13:54 Slp: The specified node does not support a resource of this type. This may be due to version inconsistencies or due to the absence of the resource DLL on this node. (Exception from HRESULT: 0x800713D7)
2012-01-20 11:13:54 Slp: Watson bucket for exception based failure has been created
2012-01-20 11:14:02 Slp: Error: Action "SqlEngineConfigAction_install_startup_Cpu64" failed during execution.
2012-01-20 11:14:02 Slp: Completed Action: SqlEngineConfigAction_install_startup_Cpu64, returned False

2012-01-20 11:14:02 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_Startup_postmsi" will return false due to the following conditions:
2012-01-20 11:14:02 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_Startup_postmsi The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:02 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result

2012-01-20 11:14:02 Slp: Action "AgentInstall_AgentInstallStartup_Cpu64" will return false due to the following conditions:
2012-01-20 11:14:02 Slp: Condition "Feature dependency condition for action: AgentInstall_AgentInstallStartup_Cpu64 The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:02 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:02 Slp: Action "ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_Startup_postmsi" will return false due to the following conditions:
2012-01-20 11:14:02 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_Startup_postmsi The condition tests feature: SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:02 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result

2012-01-20 11:14:02 Slp: Action "ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_Startup_postmsi" will return false due to the following conditions:
2012-01-20 11:14:02 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_Startup_postmsi The condition tests feature: SQL_FullText_Adv_sql_fulltext_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:02 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result

2012-01-20 11:14:02 Slp: Action "FulltextConfigAction_install_startup_Cpu64" will return false due to the following conditions:
2012-01-20 11:14:02 Slp: Condition "Feature dependency condition for action: FulltextConfigAction_install_startup_Cpu64 The condition tests feature: SQL_FullText_Adv_sql_fulltext_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:02 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi The condition tests feature: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64. There are 11 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_StartupFinalize_postmsi The condition tests feature: SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_StartupFinalize_postmsi" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_StartupFinalize_postmsi The condition tests feature: SQL_FullText_Adv_sql_fulltext_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result

2012-01-20 11:14:03 Slp: ----------------------------------------------------------------------
2012-01-20 11:14:03 Slp: Running Action: as_cluster_group_cluster_finalconfig_Cpu64
2012-01-20 11:14:03 Slp: Action Data:
2012-01-20 11:14:03 Slp: Feature = Analysis_Server_Full_sql_as_Cpu64
2012-01-20 11:14:03 Slp: Scenario = install
2012-01-20 11:14:03 Slp: Timing = Finalize
2012-01-20 11:14:03 Slp: ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterGroupPrivateConfigObject
2012-01-20 11:14:03 Slp: FeatureName = Analysis_Server_Full
2012-01-20 11:14:03 Slp: FeatureCpuType = Cpu64
2012-01-20 11:14:03 Slp: FeaturePackageId = sql_as
2012-01-20 11:14:03 Slp: FeatureClusterState = CompleteFailoverCluster
2012-01-20 11:14:03 Slp: FeatureClusterAddNode = 1
2012-01-20 11:14:03 Slp: SlipstreamInstall = 1
2012-01-20 11:14:03 Slp: Adding a node to the cluster. No final group operations are required..
2012-01-20 11:14:03 Slp: SlpConfigAction.ExecuteAction(actionId: as_cluster_group_cluster_finalconfig_Cpu64) completed
2012-01-20 11:14:03 Slp: Checkpoint: INSTALL:FINALIZE:ANALYSIS_SERVER_FULL
2012-01-20 11:14:03 Slp: Completed Action: as_cluster_group_cluster_finalconfig_Cpu64, returned True
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64_Install_Finalize_finalize" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64_Install_Finalize_finalize The condition tests feature: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64. There are 11 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "cluster_group_cluster_finalconfig_Cpu64" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: cluster_group_cluster_finalconfig_Cpu64 The condition tests feature: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64. There are 11 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_Finalize_finalize" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Install_Finalize_finalize The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_Finalize_finalize" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64_Install_Finalize_finalize The condition tests feature: SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Action "ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_Finalize_finalize" will return false due to the following conditions:
2012-01-20 11:14:03 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu64_Install_Finalize_finalize The condition tests feature: SQL_FullText_Adv_sql_fulltext_Cpu64. There are 3 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-01-20 11:14:03 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2012-01-20 11:14:03 Slp: Completed Action: FinalizeTimingConfigAction, returned True
2012-01-20 11:14:03 Slp: ----------------------------------------------------------------------

Any assistance would be greatly appreciated on getting this resolved.
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site