Add a third node to a cluster

Hy,
I have this problem, when I try from the setup wizard of sql 2000 to add the
new node-c the node is listed unavailable. I add the node-c to the cluster
group and function without problem with node-a and node-b, the sql 2000 in
node-a and node-b is function without problem, I not understand why the setup
sql 2000 give the node-c unavaiable to add!
Can anybody help me? sorry for the english!
Windows 2003 Server EE sp 1
SQL Server 2000 EE sp 3a
Server HP DL380
Bernardo
Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
NODE C with any information that might lead you in the direction as to why it
is listed as unavailable. Post what you find.
Regards
cT
"bernardo" wrote:

> Hy,
> I have this problem, when I try from the setup wizard of sql 2000 to add the
> new node-c the node is listed unavailable. I add the node-c to the cluster
> group and function without problem with node-a and node-b, the sql 2000 in
> node-a and node-b is function without problem, I not understand why the setup
> sql 2000 give the node-c unavaiable to add!
> Can anybody help me? sorry for the english!
> Windows 2003 Server EE sp 1
> SQL Server 2000 EE sp 3a
> Server HP DL380
|||15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||This is the sqlstp.log
15:59:39 Begin Setup
15:59:39 8.00.194
15:59:39 Mode = Normal
15:59:39 ModeType = NORMAL
15:59:39 GetDefinitionEx returned: 0, Extended: 0x0
15:59:39 ValueFTS returned: 1
15:59:39 ValuePID returned: 1
15:59:39 ValueLic returned: 1
15:59:39 System: Windows NT Enterprise Server
15:59:39 SQL Server ProductType: Enterprise Edition [0x3]
15:59:39 IsNTCluster returned: 1
15:59:39 Begin Action: SetupInitialize
15:59:39 End Action SetupInitialize
15:59:39 Begin Action: SetupInstall
15:59:39 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
15:59:39 CommonFilesDir=C:\Program Files\Common Files
15:59:39 Windows Directory=C:\WINDOWS\
15:59:39 Program Files=C:\Program Files\
15:59:39 TEMPDIR=C:\DOCUME~1\HYPHEN~1\LOCALS~1\Temp\1\
15:59:39 Begin Action: SetupInstall
15:59:39 digpid size : 256
15:59:40 digpid size : 164
15:59:40 Begin Action: CheckFixedRequirements
15:59:40 Platform ID: 0xf00000
15:59:40 Version: 5.2.3790
15:59:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2440
15:59:40 End Action: CheckFixedRequirements
15:59:40 Begin Action: ShowDialogs
15:59:40 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:59:40 Begin Action ShowDialogsHlpr: 0x1
15:59:40 Begin Action: DialogShowSdWelcome
15:59:46 End Action DialogShowSdWelcome
15:59:46 Dialog 0x1 returned: 1
15:59:46 End Action ShowDialogsHlpr
15:59:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:59:46 Begin Action ShowDialogsHlpr: 0x2
15:59:46 Begin Action: DialogShowSdMachineName
15:59:55 ShowDlgMachine returned: 1
15:59:55 Name = CLX-CLUSTER-SQL, Type = 0x20000008
15:59:55 GetCDKeyForThisVS returned: 0
15:59:55 Begin Action: CheckRequirements
15:59:55 Processor Architecture: x86 (Pentium)
15:59:55 Service Pack: 256
15:59:55 ComputerName: CLX-CLUSTER-C
15:59:55 User Name: hyphenadmin
15:59:55 IsAllAccessAllowed returned: 1
15:59:55 OS Language: 0x409
15:59:55 End Action CheckRequirements
15:59:55 This combination of Package and Operating System allows a full
product install.
15:59:55 End Action DialogShowSdMachineName
15:59:55 begin ShowDialogsUpdateMask
15:59:55 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:59:55 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
15:59:55 Dialog 0x2 returned: 0
15:59:55 End Action ShowDialogsHlpr
15:59:55 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:59:55 Begin Action ShowDialogsHlpr: 0x4
15:59:55 Begin Action: DialogShowSdInstallMode
15:59:57 ShowDlgInstallMode returned: 1
15:59:57 InstallMode : 0x20
15:59:57 End Action DialogShowSdInstallMode
15:59:57 begin ShowDialogsUpdateMask
15:59:57 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
15:59:57 Updated Dialog Mask: 0xb73c03f, Disable Back = 0x1
15:59:57 Dialog 0x4 returned: 1
15:59:57 End Action ShowDialogsHlpr
15:59:57 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
15:59:57 Begin Action ShowDialogsHlpr: 0x8
15:59:57 Begin Action : DialogShowSdAdvanced
15:59:59 ShowDlgAdvanced returned: 1
15:59:59 Adv Install Mode = -2147483648
15:59:59 End Action : DialogShowSdAdvanced
15:59:59 begin ShowDialogsUpdateMask
15:59:59 nFullMask = 0xb73c03f, nCurrent = 0x8, nDirection = 1
15:59:59 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
15:59:59 Dialog 0x8 returned: 1
15:59:59 End Action ShowDialogsHlpr
15:59:59 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:59:59 Begin Action ShowDialogsHlpr: 0x4000
15:59:59 Begin Action: DialogShowSdVirtualServer
16:00:01 ShowDlgVirtualServer returned: 0
16:00:01 Ipaddress = 192.9.220.221,255.255.255.0,Lan Team
16:00:01 szNewList =
16:00:01 szModifiedList =
16:00:01 szRemovedList =
16:00:01 End Action DialogShowSdVirtualServer
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x4000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x4000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:00:01 Begin Action ShowDialogsHlpr: 0x8000
16:00:01 Begin Action : DialogShowSdDiskGroups
16:00:01 ShowDlgDiskGroups returned: 1
16:00:01 Disk Group = B - SQL CLUSTER Group
16:00:01 End Action : DialogShowSdDiskGroups
16:00:01 begin ShowDialogsUpdateMask
16:00:01 nFullMask = 0x3c00f, nCurrent = 0x8000, nDirection = 1
16:00:01 Updated Dialog Mask: 0x3c00f, Disable Back = 0x1
16:00:01 Dialog 0x8000 returned: 1
16:00:01 End Action ShowDialogsHlpr
16:00:01 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:00:01 Begin Action ShowDialogsHlpr: 0x10000
16:00:01 Begin Action: DialogShowSdClusterDef
16:00:05 ShowDlgClusterDef returned: -1
16:00:05 ShowDlgClusterDef: GetLastError returned: 0
16:00:05 The operation completed successfully.
16:00:05 End Action DialogShowSdClusterDef
16:00:05 End Action ShowDialogs
16:00:05 Action CleanUpInstall:
16:00:05 StatsGenerate returned: 2
16:00:05 StatsGenerate (0x0,0x20,0xf00000,0x100,1033,0,0x0,0x20000008,0,0 ,0
16:00:05 StatsGenerate -1,hyphenadmin)
16:00:05 Installation Failed.
"Charles Tolento" ha scritto:
[vbcol=seagreen]
> Bernardo
> Take a look at the SQLSTP.LOG in the %systemroot%. See if SQL if flagging
> NODE C with any information that might lead you in the direction as to why it
> is listed as unavailable. Post what you find.
>
> Regards
> cT
> "bernardo" wrote:
|||Im having the same problem. Does anyone have an idea whats the cause?