Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: SQL2000 Cluster Install on Win2k Adv. Server Problem

    Hello guys,

    Ive searched through this Forum among others to find out what I could about the problem Im having at the moment:

    Im trying to install SQL2000 To my 2 Node Cluster, but after filling in all the configuration info during setup, it starts to setup and after a few minutes reports that theres a fault and deinstalls (cleans) everything again.

    I logged in with the service account on the nodes, the service account even has domain admin and local admin rights.

    Heres the Log file from Node 1 :

    14:49:23 Begin Setup
    14:49:23 8.00.194
    14:49:23 Mode = Silent
    14:49:23 ModeType = CLUSTER
    14:49:23 Cluster node.
    14:49:23 Cluster secondary node.
    14:49:23 Cluster secondary node.
    14:49:23 g_szIssPath=C:\WINNT\setup~0.iss
    14:49:31 GetDefinitionEx returned: 0, Extended: 0x0
    14:49:31 ValueFTS returned: 1
    14:49:31 ValuePID returned: 1
    14:49:31 ValueLic returned: 1
    14:49:31 System: Windows NT Enterprise Server
    14:49:31 SQL Server ProductType: Enterprise Edition [0x3]
    14:49:31 IsNTCluster returned: 1
    14:49:31 Begin Action: SetupInitialize
    14:49:31 End Action SetupInitialize
    14:49:31 Begin Action: SetupInstall
    14:49:31 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
    14:49:31 CommonFilesDir=C:\Program Files\Common Files
    14:49:31 Windows Directory=C:\WINNT\
    14:49:31 Program Files=C:\Program Files\
    14:49:31 TEMPDIR=C:\DOCUME~1\SQLSER~1\LOCALS~1\Temp\
    14:49:31 Begin Action: SetupInstall
    14:49:31 digpid size : 256
    14:49:31 digpid size : 164
    14:49:31 Begin Action: CheckFixedRequirements
    14:49:31 Platform ID: 0xf00000
    14:49:31 Version: 5.0.2195
    14:49:31 File Version - C:\WINNT\System32\shdocvw.dll: 6.0.2800.1106
    14:49:31 End Action: CheckFixedRequirements
    14:50:52 Begin Action: ShowDialogs
    14:50:52 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
    14:50:52 Begin Action ShowDialogsHlpr: 0x1
    14:50:52 Begin Action: DialogShowSdWelcome
    14:50:52 End Action DialogShowSdWelcome
    14:50:52 Dialog 0x1 returned: 1
    14:50:52 End Action ShowDialogsHlpr
    14:50:52 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
    14:50:52 Begin Action ShowDialogsHlpr: 0x2
    14:50:52 Begin Action: DialogShowSdMachineName
    14:50:52 [DlgMachine]
    14:50:52 Result = 1
    14:50:52 Type = 268435466
    14:50:52 Name = SQL2N2
    14:50:53 ShowDlgMachine returned: 1
    14:50:53 Name = SQL2N2, Type = 0x1000000a
    14:50:53 Begin Action: CheckRequirements
    14:50:53 Processor Architecture: x86 (Pentium)
    14:50:53 Service Pack: 768
    14:50:53 ComputerName: SQL2N2
    14:50:53 User Name: sqlservice
    14:50:53 IsAllAccessAllowed returned: 1
    14:50:53 OS Language: 0x409
    14:50:53 End Action CheckRequirements
    14:50:53 This combination of Package and Operating System allows a full product install.
    14:50:53 End Action DialogShowSdMachineName
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
    14:50:53 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
    14:50:53 Dialog 0x2 returned: 0
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
    14:50:53 Begin Action ShowDialogsHlpr: 0x4
    14:50:53 Begin Action: DialogShowSdInstallMode
    14:50:53 [DlgInstallMode]
    14:50:53 Result = 1
    14:50:53 Type = 1
    14:50:53 InstallMode : 0x1
    14:50:53 End Action DialogShowSdInstallMode
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
    14:50:53 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:53 Dialog 0x4 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
    14:50:53 Begin Action ShowDialogsHlpr: 0x10
    14:50:53 Begin Action: DialogShowSdRegisterUserEx
    14:50:53 End Action DialogShowSdRegisterUserEx
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
    14:50:53 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:53 Dialog 0x10 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
    14:50:53 Begin Action ShowDialogsHlpr: 0x20
    14:50:53 Begin Action: DialogShowSdLicense
    14:50:53 End Action DialogShowSdLicense
    14:50:53 Dialog 0x20 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
    14:50:53 Begin Action ShowDialogsHlpr: 0x4000
    14:50:53 Begin Action: DialogShowSdVirtualServer
    14:50:53 [DlgVirtServer]
    14:50:53 Result = 1
    14:50:53 VirtServerName = SQL1ADD
    14:50:53 IpAddresses = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 ShowDlgVirtualServer returned: 0
    14:50:56 Ipaddress = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 szNewList = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 szModifiedList =
    14:50:56 szRemovedList =
    14:50:56 End Action DialogShowSdVirtualServer
    14:50:56 begin ShowDialogsUpdateMask
    14:50:56 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
    14:50:56 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:56 Dialog 0x4000 returned: 1
    14:50:56 End Action ShowDialogsHlpr
    14:50:56 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
    14:50:56 Begin Action ShowDialogsHlpr: 0x8000
    14:50:56 Begin Action : DialogShowSdDiskGroups
    14:50:56 [DlgDiskGroups]
    14:50:56 Result = 1
    14:50:56 DiskGroupsName = SQL1ADD
    14:50:57 ShowDlgDiskGroups returned: 1
    14:50:57 Disk Group = SQL1ADD
    14:50:57 End Action : DialogShowSdDiskGroups
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x8000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
    14:50:57 Begin Action ShowDialogsHlpr: 0x10000
    14:50:57 Begin Action: DialogShowSdClusterDef
    14:50:57 [DlgClusterDef]
    14:50:57 Result = 1
    14:50:57 nNumNodes = 2
    14:50:57 VirtServerName = SQL1ADD
    14:50:57 szPrefowners = SQL2N1,SQL2N2
    14:50:57 ShowDlgClusterDef returned: 1
    14:50:57 PrefOwners = SQL2N1,SQL2N2, NumIp = 0
    14:50:57 End Action DialogShowSdClusterDef
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x10000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
    14:50:57 Begin Action ShowDialogsHlpr: 0x20000
    14:50:57 Begin Action : Cluster Security - DlgAcct
    14:50:57 [DlgAccount]
    14:50:57 Result = 1
    14:50:57 Domain = ADAWDDE
    14:50:57 DomainAcct = sqlservice
    14:50:57 DomainPwd
    14:50:57 ValidateUser returned: 1, 0, 0xc0
    14:50:57 IsAcctValidForCluster returned: 1, 0
    14:50:57 End Action : Cluster Security - DlgAcct
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x20000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
    14:50:57 Begin Action ShowDialogsHlpr: 0x40000
    14:50:57 Begin Action: DialogShowSdCliSvr
    14:50:57 DisplaySystemPreReq
    14:50:57 [DlgClientServer]
    14:50:57 Result = 1
    14:50:57 Type = 2
    14:50:57 ShowDlgClientServerSelect returned: 1
    14:50:57 Type : 0x2
    14:50:57 End Action DialogShowSdCliSvr
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
    14:50:57 Dialog 0x40000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
    14:50:57 Begin Action ShowDialogsHlpr: 0x80000
    14:50:57 Begin Action: DialogShowSdInstanceName
    14:50:57 [DlgInstanceName]
    14:50:57 Result = 1
    14:50:57 InstanceName = MSSQLSERVER
    14:50:57 Begin Action: ShowDlgInstanceName
    14:52:36 End Action: ShowDlgInstanceName
    14:52:36 ShowDlgInstanceName returned : -1
    14:52:36 ShowDlgInstanceName: GetLastError returned: 50044
    14:52:36 End Action DialogShowSdInstanceName
    14:52:36 End Action ShowDialogs
    14:52:36 Action CleanUpInstall:
    14:52:36 StatsGenerate returned: 2
    14:52:36 StatsGenerate (0x0,0x1,0xf00000,0x300,1033,0,0x0,0x1000000a,0,0, 0
    14:52:36 StatsGenerate -1,sqlservice)
    14:52:36 Installation Failed.


    I would really appreciate any help on this.

  2. #2
    Join Date
    Oct 2003
    Posts
    3
    OK,

    I installed the Single SQL2000 Server on Node1.

    However, now when trying to install SQL2000 for the second node.
    I get more problems.

    Ive been through all the MSDN and whitepapers M$ have.

    Any tips pleeeeeease

  3. #3
    Join Date
    Aug 2003
    Location
    California
    Posts
    8

    Re: SQL2000 Cluster Install on Win2k Adv. Server Problem

    Is this an active/active or active/passive cluster?

    Originally posted by winsoc
    Hello guys,

    Ive searched through this Forum among others to find out what I could about the problem Im having at the moment:

    Im trying to install SQL2000 To my 2 Node Cluster, but after filling in all the configuration info during setup, it starts to setup and after a few minutes reports that theres a fault and deinstalls (cleans) everything again.

    I logged in with the service account on the nodes, the service account even has domain admin and local admin rights.

    Heres the Log file from Node 1 :

    14:49:23 Begin Setup
    14:49:23 8.00.194
    14:49:23 Mode = Silent
    14:49:23 ModeType = CLUSTER
    14:49:23 Cluster node.
    14:49:23 Cluster secondary node.
    14:49:23 Cluster secondary node.
    14:49:23 g_szIssPath=C:\WINNT\setup~0.iss
    14:49:31 GetDefinitionEx returned: 0, Extended: 0x0
    14:49:31 ValueFTS returned: 1
    14:49:31 ValuePID returned: 1
    14:49:31 ValueLic returned: 1
    14:49:31 System: Windows NT Enterprise Server
    14:49:31 SQL Server ProductType: Enterprise Edition [0x3]
    14:49:31 IsNTCluster returned: 1
    14:49:31 Begin Action: SetupInitialize
    14:49:31 End Action SetupInitialize
    14:49:31 Begin Action: SetupInstall
    14:49:31 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
    14:49:31 CommonFilesDir=C:\Program Files\Common Files
    14:49:31 Windows Directory=C:\WINNT\
    14:49:31 Program Files=C:\Program Files\
    14:49:31 TEMPDIR=C:\DOCUME~1\SQLSER~1\LOCALS~1\Temp\
    14:49:31 Begin Action: SetupInstall
    14:49:31 digpid size : 256
    14:49:31 digpid size : 164
    14:49:31 Begin Action: CheckFixedRequirements
    14:49:31 Platform ID: 0xf00000
    14:49:31 Version: 5.0.2195
    14:49:31 File Version - C:\WINNT\System32\shdocvw.dll: 6.0.2800.1106
    14:49:31 End Action: CheckFixedRequirements
    14:50:52 Begin Action: ShowDialogs
    14:50:52 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
    14:50:52 Begin Action ShowDialogsHlpr: 0x1
    14:50:52 Begin Action: DialogShowSdWelcome
    14:50:52 End Action DialogShowSdWelcome
    14:50:52 Dialog 0x1 returned: 1
    14:50:52 End Action ShowDialogsHlpr
    14:50:52 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
    14:50:52 Begin Action ShowDialogsHlpr: 0x2
    14:50:52 Begin Action: DialogShowSdMachineName
    14:50:52 [DlgMachine]
    14:50:52 Result = 1
    14:50:52 Type = 268435466
    14:50:52 Name = SQL2N2
    14:50:53 ShowDlgMachine returned: 1
    14:50:53 Name = SQL2N2, Type = 0x1000000a
    14:50:53 Begin Action: CheckRequirements
    14:50:53 Processor Architecture: x86 (Pentium)
    14:50:53 Service Pack: 768
    14:50:53 ComputerName: SQL2N2
    14:50:53 User Name: sqlservice
    14:50:53 IsAllAccessAllowed returned: 1
    14:50:53 OS Language: 0x409
    14:50:53 End Action CheckRequirements
    14:50:53 This combination of Package and Operating System allows a full product install.
    14:50:53 End Action DialogShowSdMachineName
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
    14:50:53 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
    14:50:53 Dialog 0x2 returned: 0
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
    14:50:53 Begin Action ShowDialogsHlpr: 0x4
    14:50:53 Begin Action: DialogShowSdInstallMode
    14:50:53 [DlgInstallMode]
    14:50:53 Result = 1
    14:50:53 Type = 1
    14:50:53 InstallMode : 0x1
    14:50:53 End Action DialogShowSdInstallMode
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
    14:50:53 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:53 Dialog 0x4 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
    14:50:53 Begin Action ShowDialogsHlpr: 0x10
    14:50:53 Begin Action: DialogShowSdRegisterUserEx
    14:50:53 End Action DialogShowSdRegisterUserEx
    14:50:53 begin ShowDialogsUpdateMask
    14:50:53 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
    14:50:53 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:53 Dialog 0x10 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
    14:50:53 Begin Action ShowDialogsHlpr: 0x20
    14:50:53 Begin Action: DialogShowSdLicense
    14:50:53 End Action DialogShowSdLicense
    14:50:53 Dialog 0x20 returned: 1
    14:50:53 End Action ShowDialogsHlpr
    14:50:53 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
    14:50:53 Begin Action ShowDialogsHlpr: 0x4000
    14:50:53 Begin Action: DialogShowSdVirtualServer
    14:50:53 [DlgVirtServer]
    14:50:53 Result = 1
    14:50:53 VirtServerName = SQL1ADD
    14:50:53 IpAddresses = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 ShowDlgVirtualServer returned: 0
    14:50:56 Ipaddress = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 szNewList = 129.129.100.92,255.255.0.0,IUNetwork
    14:50:56 szModifiedList =
    14:50:56 szRemovedList =
    14:50:56 End Action DialogShowSdVirtualServer
    14:50:56 begin ShowDialogsUpdateMask
    14:50:56 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
    14:50:56 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:56 Dialog 0x4000 returned: 1
    14:50:56 End Action ShowDialogsHlpr
    14:50:56 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
    14:50:56 Begin Action ShowDialogsHlpr: 0x8000
    14:50:56 Begin Action : DialogShowSdDiskGroups
    14:50:56 [DlgDiskGroups]
    14:50:56 Result = 1
    14:50:56 DiskGroupsName = SQL1ADD
    14:50:57 ShowDlgDiskGroups returned: 1
    14:50:57 Disk Group = SQL1ADD
    14:50:57 End Action : DialogShowSdDiskGroups
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x8000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
    14:50:57 Begin Action ShowDialogsHlpr: 0x10000
    14:50:57 Begin Action: DialogShowSdClusterDef
    14:50:57 [DlgClusterDef]
    14:50:57 Result = 1
    14:50:57 nNumNodes = 2
    14:50:57 VirtServerName = SQL1ADD
    14:50:57 szPrefowners = SQL2N1,SQL2N2
    14:50:57 ShowDlgClusterDef returned: 1
    14:50:57 PrefOwners = SQL2N1,SQL2N2, NumIp = 0
    14:50:57 End Action DialogShowSdClusterDef
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x10000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
    14:50:57 Begin Action ShowDialogsHlpr: 0x20000
    14:50:57 Begin Action : Cluster Security - DlgAcct
    14:50:57 [DlgAccount]
    14:50:57 Result = 1
    14:50:57 Domain = ADAWDDE
    14:50:57 DomainAcct = sqlservice
    14:50:57 DomainPwd
    14:50:57 ValidateUser returned: 1, 0, 0xc0
    14:50:57 IsAcctValidForCluster returned: 1, 0
    14:50:57 End Action : Cluster Security - DlgAcct
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
    14:50:57 Dialog 0x20000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
    14:50:57 Begin Action ShowDialogsHlpr: 0x40000
    14:50:57 Begin Action: DialogShowSdCliSvr
    14:50:57 DisplaySystemPreReq
    14:50:57 [DlgClientServer]
    14:50:57 Result = 1
    14:50:57 Type = 2
    14:50:57 ShowDlgClientServerSelect returned: 1
    14:50:57 Type : 0x2
    14:50:57 End Action DialogShowSdCliSvr
    14:50:57 begin ShowDialogsUpdateMask
    14:50:57 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
    14:50:57 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
    14:50:57 Dialog 0x40000 returned: 1
    14:50:57 End Action ShowDialogsHlpr
    14:50:57 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
    14:50:57 Begin Action ShowDialogsHlpr: 0x80000
    14:50:57 Begin Action: DialogShowSdInstanceName
    14:50:57 [DlgInstanceName]
    14:50:57 Result = 1
    14:50:57 InstanceName = MSSQLSERVER
    14:50:57 Begin Action: ShowDlgInstanceName
    14:52:36 End Action: ShowDlgInstanceName
    14:52:36 ShowDlgInstanceName returned : -1
    14:52:36 ShowDlgInstanceName: GetLastError returned: 50044
    14:52:36 End Action DialogShowSdInstanceName
    14:52:36 End Action ShowDialogs
    14:52:36 Action CleanUpInstall:
    14:52:36 StatsGenerate returned: 2
    14:52:36 StatsGenerate (0x0,0x1,0xf00000,0x300,1033,0,0x0,0x1000000a,0,0, 0
    14:52:36 StatsGenerate -1,sqlservice)
    14:52:36 Installation Failed.


    I would really appreciate any help on this.

  4. #4
    Join Date
    Oct 2003
    Posts
    3
    Hello wolv,

    It should be a simple Active/Passive Cluster.

    But as you can see I somehow cant install to the Second Node

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •