January 4, 2010 at 7:52 pm
I am installing a new SQL2008 Cluster on a Windows 2008 virtual server and have twice run into the same error "setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)" I am new to sql2008 and clustering so I am unsure how to work around the error and correct it. I have included the following text files for details to help.
--------------------------------------------------------------------------------------------------------------------------
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068774911
Exit facility code: 1201
Exit error code: 1
Exit message: Failed: see details below
Start time: 2010-01-05 10:13:52
End time: 2010-01-05 10:26:19
Requested action: InstallFailoverCluster
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xDCFFB30D%400x1251FB33
Cluster properties:
Machine name: SQL01
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Complete 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Connectivity 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Backwards Compatibility 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools SDK 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Integration Services 1033 Standard Edition 10.0.1600.22 No
Machine name: SQL02
Product Instance Instance ID Feature Language Edition Version Clustered
Machine Properties:
Machine name: SQL01
Machine processor count: 4
OS version: Windows Server 2008
OS service pack:
OS region: Australia
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: Yes
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Complete 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Connectivity 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Backwards Compatibility 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools SDK 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Integration Services 1033 Standard Edition 10.0.1600.22 No
Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: E:\x64\setup\
Installation edition: STANDARD
User Input Settings:
ACTION: InstallFailoverCluster
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: SVDPWA\SqlAdmin
AGTSVCPASSWORD: *****
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <empty>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\ConfigurationFile.ini
ERRORREPORTING: False
FAILOVERCLUSTERDISKS: Cluster Disk 1
FAILOVERCLUSTERGROUP: SQLCRG
FAILOVERCLUSTERIPADDRESSES: <empty>
FAILOVERCLUSTERNETWORKNAME: SQLCDATA
FEATURES: SQLENGINE,REPLICATION,FULLTEXT,BOL
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: D:\
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: SQLDATA1
INSTANCENAME: SQLDATA1
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: E:\
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Latin1_General_CI_AS
SQLDOMAINGROUP: <empty>
SQLSVCACCOUNT: SVDPWA\SqlAdmin
SQLSVCPASSWORD: *****
SQLSYSADMINACCOUNTS: SVDPWA\SqlAdmin
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x1C2074D8@1216@1
Configuration error description: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Detail.txt
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x1C2074D8@1216@1
Configuration error description: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Detail.txt
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x1C2074D8@1216@1
Configuration error description: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Detail.txt
Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\SystemConfigurationCheck_Report.htm
--------------------------------------------------------------------------------------------------------------
Detail text
010-01-05 10:22:51 Slp: Running Action: cluster_failover_cluster_name_cluster_config_Cpu64
2010-01-05 10:22:51 Slp: Action Data:
2010-01-05 10:22:51 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
2010-01-05 10:22:51 Slp: Scenario = install
2010-01-05 10:22:51 Slp: Timing = ConfigNonRC
2010-01-05 10:22:51 Slp: ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.FailoverClusterNamePrivateConfigObject
2010-01-05 10:22:51 Slp: FeatureName = SQL_Engine_Core_Inst
2010-01-05 10:22:51 Slp: FeatureCpuType = Cpu64
2010-01-05 10:22:51 Slp: FeaturePackageId = sql_engine_core_inst
2010-01-05 10:22:51 Slp: FeatureClusterState = CompleteFailoverCluster
2010-01-05 10:22:51 Slp: Creating cluster network name 'SQLCDATA'.
2010-01-05 10:22:51 Slp: Creating cluster resource 'SQL Network Name (SQLCDATA)' of type 'Network Name' in group 'SQLCRG'
2010-01-05 10:22:52 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
2010-01-05 10:22:52 Slp: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range.
2010-01-05 10:22:52 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
2010-01-05 10:22:52 Slp: Microsoft.SqlServer.Configuration.Cluster.ClusterException: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range. ---> System.ArgumentException: Value does not fall within the expected range.
2010-01-05 10:22:52 Slp: at MSClusterLib.ClusPropertiesClass.get_Item(Object varIndex)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.Cluster.ClusterNetworkName.set_RequireKerberos(Int32 value)
2010-01-05 10:22:52 Slp: --- End of inner exception stack trace ---
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.Cluster.ClusterNetworkName.set_RequireKerberos(Int32 value)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.Cluster.ClusterNetworkName.CreateName(WindowsCluster c, ClusterGroup g, String netName)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.ClusterConfiguration.FailoverClusterNamePrivateConfigObject.CreateFailoverClusterNameResource(FailoverClusterNamePublicConfigObject pubConfig)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.ClusterConfiguration.FailoverClusterNamePrivateConfigObject.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
2010-01-05 10:22:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
2010-01-05 10:22:52 Slp: Exception: Microsoft.SqlServer.Configuration.Cluster.ClusterException.
2010-01-05 10:22:52 Slp: Source: Microsoft.SqlServer.Configuration.Cluster.
2010-01-05 10:22:52 Slp: Message: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range..
2010-01-05 10:22:52 Slp: Inner exception:
2010-01-05 10:22:52 Slp: Exception: System.ArgumentException.
2010-01-05 10:22:52 Slp: Source: MSClusterLib.
2010-01-05 10:22:52 Slp: Message: Value does not fall within the expected range..
2010-01-05 10:22:52 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\20100105_101319\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2010-01-05 10:22:54 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\20100105_101319\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2010-01-05 10:22:54 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2010-01-05 10:22:54 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\20100105_101319\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2010-01-05 10:22:54 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\20100105_101319\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2010-01-05 10:22:54 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100105_101319\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2010-01-05 10:22:57 Slp: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name (SQLCDATA)'. Error: Value does not fall within the expected range.
2010-01-05 10:22:57 Slp: Watson bucket for exception based failure has been created
2010-01-05 10:26:16 Slp: Completed Action: cluster_failover_cluster_name_cluster_config_Cpu64, returned False
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\UpgradeIncompleteState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Sco: Attempting to get feature configuration state for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\ConfigurationState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\UpgradeIncompleteState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Sco: Attempting to get feature configuration state for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\ConfigurationState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\UpgradeIncompleteState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Sco: Attempting to get feature configuration state for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature SQL_Engine_Core_Inst, instance MSSQL10.SQLDATA1
2010-01-05 10:26:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey
2010-01-05 10:26:16 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLDATA1\ConfigurationState
2010-01-05 10:26:16 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Inst
2010-01-05 10:26:16 Slp: Error: Action "cluster_failover_cluster_name_cluster_config_Cpu64" failed during execution.
2010-01-05 10:26:16 Slp: Action "cluster_disk_cluster_config_Cpu64" will return false due to the following conditions:
2010-01-05 10:26:16 Slp: Condition "Feature dependency condition for action: cluster_disk_cluster_config_Cpu64 The condition tests feature: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64. There are 10 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2010-01-05 10:26:16 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64 failed in result Result
2010-01-05 10:26:16 Slp: Error: Action "cluster_disk_cluster_config_Cpu64" failed during execution.
------
Thanks in Advance
January 5, 2010 at 1:12 am
there's a protocols blog which might be of use http://blogs.msdn.com/sql_protocols/
this team have some really great stuff which has helped me more than once - not sure if this will help here - although I have clustered sql 2008/win 2008 I wouldn't know where to start with this.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 5, 2010 at 10:56 am
Have you tried slipstreaming SP1 and performing the install with that already on? It might resolve this.
Check out http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx for slipstreaming sp1 onto the SQL2008 RTM.
January 18, 2010 at 8:11 pm
The slipstream solution worked and I was able to complete the install. I have no run into another problem, but I will post this in another thread.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply