Installing on Cluster fails - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Installing on Cluster fails

Author

Topic

steveo
Starting Member

16 Posts

Posted - 2002-08-06 : 12:51:49

I have a 2 node cluster running Win2000 Advanced Server and MSCS. Clustering appears to be working fine. Both servers are also primary domain controllers.

When installing SQL2000 Enterprise, it gets to the last step...

Setup is performing required operations on cluster nodes. This may take a few minutes...

After a few minutes I get...

Setup failed to perform required operations on the cluster nodes

Would seem that this is a problem accessing the second node, but first server can access the seconds administrative shares just fine. Service Account and Admin account are domain admins and I can log into 2nd server directly just fine with either account. Also tried installing from install cd contents copied to a new shared directory on server 1. Same result. Both machines are identically configured.

This following is an excerpt from the SQL install log on the second server...

15:10:54 Begin Setup
15:10:54 8.00.194
15:10:54 Mode = Silent
15:10:54 ModeType = CLUSTER
15:10:54 Cluster node.
15:10:54 Cluster secondary node.
15:10:54 Cluster secondary node.
15:10:54 g_szIssPath=C:\WINNT\setup~0.iss
15:11:03 GetDefinitionEx returned: 0, Extended: 0x0
15:11:03 ValueFTS returned: 1
15:11:03 ValuePID returned: 1
15:11:03 ValueLic returned: 1
15:11:03 System: Windows NT Enterprise Server
15:11:03 SQL Server ProductType: Enterprise Edition [0x3]
15:11:03 IsNTCluster returned: 1
15:11:03 Begin Action: SetupInitialize
15:11:03 End Action SetupInitialize
15:11:03 Begin Action: SetupInstall
15:11:03 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
15:11:03 CommonFilesDir=C:\Program Files\Common Files
15:11:03 Windows Directory=C:\WINNT15:11:03 Program Files=C:\Program Files15:11:03 TEMPDIR=C:\DOCUME~1\ADMINI~1.CLU\LOCALS~1\Temp15:11:03 Begin Action: SetupInstall
15:11:03 Begin Action: CheckFixedRequirements
15:11:03 Platform ID: 0xf00000
15:11:03 Version: 5.0.2195
15:11:03 File Version - C:\WINNT\System32\shdocvw.dll: 6.0.2716.1500
15:11:03 End Action: CheckFixedRequirements
15:11:49 Begin Action: ShowDialogs
15:11:49 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
15:11:49 Begin Action ShowDialogsHlpr: 0x1
15:11:49 Begin Action: DialogShowSdWelcome
15:11:49 End Action DialogShowSdWelcome
15:11:49 Dialog 0x1 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
15:11:49 Begin Action ShowDialogsHlpr: 0x2
15:11:49 Begin Action: DialogShowSdMachineName
15:11:49 [DlgMachine]
15:11:49 Result = 1
15:11:49 Type = 268435466
15:11:49 Name = RWDS2A
15:11:49 ShowDlgMachine returned: 1
15:11:49 Name = RWDS2A, Type = 0x1000000a
15:11:49 Begin Action: CheckRequirements
15:11:49 Processor Architecture: x86 (Pentium)
15:11:49 Service Pack: 512
15:11:49 ComputerName: RWDS2A
15:11:49 User Name: Administrator
15:11:49 IsAllAccessAllowed returned: 1
15:11:49 OS Language: 0x409
15:11:49 End Action CheckRequirements
15:11:49 This combination of Package and Operating System allows a full product install.
15:11:49 End Action DialogShowSdMachineName
15:11:49 begin ShowDialogsUpdateMask
15:11:49 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
15:11:49 Updated Dialog Mask: 0xbf3c0f7, Disable Back = 0x1
15:11:49 Dialog 0x2 returned: 0
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
15:11:49 Begin Action ShowDialogsHlpr: 0x4
15:11:49 Begin Action: DialogShowSdInstallMode
15:11:49 [DlgInstallMode]
15:11:49 Result = 1
15:11:49 Type = 1
15:11:49 InstallMode : 0x1
15:11:49 End Action DialogShowSdInstallMode
15:11:49 begin ShowDialogsUpdateMask
15:11:49 nFullMask = 0xbf3c0f7, nCurrent = 0x4, nDirection = 1
15:11:49 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:49 Dialog 0x4 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
15:11:49 Begin Action ShowDialogsHlpr: 0x10
15:11:49 Begin Action: DialogShowSdRegisterUserEx
15:11:49 End Action DialogShowSdRegisterUserEx
15:11:49 begin ShowDialogsUpdateMask
15:11:49 nFullMask = 0x1bf7c0f7, nCurrent = 0x10, nDirection = 1
15:11:49 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:49 Dialog 0x10 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
15:11:49 Begin Action ShowDialogsHlpr: 0x20
15:11:49 Begin Action: DialogShowSdLicense
15:11:49 End Action DialogShowSdLicense
15:11:49 Dialog 0x20 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x40,index=6
15:11:49 Begin Action ShowDialogsHlpr: 0x40
15:11:49 Begin Action: DialogShowSdCDKey
15:11:49 digpid size : 256
15:11:49 [DlgCDKey]
15:11:49 Result = 1
15:11:49 CDKey = D7XKH-MMJ46-FF24B-9MWTM-C7YVD
15:11:49 ShowDlgCDKeyreturned: 1
15:11:49 digpid size : 164
15:11:49 CDKey = D7XKH-MMJ46-FF24B-9MWTM-C7YVD, 20 digit Product ID = 53934-400-7407656-05648
15:11:49 End Action DialogShowSdCDKey
15:11:49 begin ShowDialogsUpdateMask
15:11:49 nFullMask = 0x1bf7c0f7, nCurrent = 0x40, nDirection = 1
15:11:49 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:49 Dialog 0x40 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x80,index=7
15:11:49 Begin Action ShowDialogsHlpr: 0x80
15:11:49 Dialog 0x80 returned: 1
15:11:49 End Action ShowDialogsHlpr
15:11:49 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
15:11:49 Begin Action ShowDialogsHlpr: 0x4000
15:11:49 Begin Action: DialogShowSdVirtualServer
15:11:49 [DlgVirtServer]
15:11:49 Result = 1
15:11:49 VirtServerName = RWSQL
15:11:49 IpAddresses = 192.168.0.120,255.255.255.0,External Network
15:11:53 ShowDlgVirtualServer returned: 0
15:11:53 Ipaddress = 192.168.0.120,255.255.255.0,External Network
15:11:53 szNewList = 192.168.0.120,255.255.255.0,External Network
15:11:53 szModifiedList =
15:11:53 szRemovedList =
15:11:53 End Action DialogShowSdVirtualServer
15:11:53 begin ShowDialogsUpdateMask
15:11:53 nFullMask = 0x1bf7c0f7, nCurrent = 0x4000, nDirection = 1
15:11:53 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:53 Dialog 0x4000 returned: 1
15:11:53 End Action ShowDialogsHlpr
15:11:53 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
15:11:53 Begin Action ShowDialogsHlpr: 0x8000
15:11:53 Begin Action : DialogShowSdDiskGroups
15:11:53 [DlgDiskGroups]
15:11:53 Result = 1
15:11:53 DiskGroupsName = Disk Group 3
15:11:53 ShowDlgDiskGroups returned: 1
15:11:53 Disk Group = Disk Group 3
15:11:53 End Action : DialogShowSdDiskGroups
15:11:53 begin ShowDialogsUpdateMask
15:11:53 nFullMask = 0x1bf7c0f7, nCurrent = 0x8000, nDirection = 1
15:11:53 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:53 Dialog 0x8000 returned: 1
15:11:53 End Action ShowDialogsHlpr
15:11:53 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
15:11:53 Begin Action ShowDialogsHlpr: 0x10000
15:11:53 Begin Action: DialogShowSdClusterDef
15:11:53 [DlgClusterDef]
15:11:53 Result = 1
15:11:53 nNumNodes = 2
15:11:53 VirtServerName = RWSQL
15:11:53 szPrefowners = RWDS1A,RWDS2A
15:11:53 ShowDlgClusterDef returned: 1
15:11:53 PrefOwners = RWDS1A,RWDS2A, NumIp = 0
15:11:53 End Action DialogShowSdClusterDef
15:11:53 begin ShowDialogsUpdateMask
15:11:53 nFullMask = 0x1bf7c0f7, nCurrent = 0x10000, nDirection = 1
15:11:53 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:53 Dialog 0x10000 returned: 1
15:11:53 End Action ShowDialogsHlpr
15:11:53 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
15:11:53 Begin Action ShowDialogsHlpr: 0x20000
15:11:53 Begin Action : Cluster Security - DlgAcct
15:11:53 [DlgAccount]
15:11:53 Result = 1
15:11:53 Domain = CLUSTER
15:11:53 DomainAcct = Administrator
15:11:53 DomainPwd
15:11:53 ValidateUser returned: 1, 0, 0x90
15:11:53 IsAcctValidForCluster returned: 1, 0
15:11:53 End Action : Cluster Security - DlgAcct
15:11:53 begin ShowDialogsUpdateMask
15:11:53 nFullMask = 0x1bf7c0f7, nCurrent = 0x20000, nDirection = 1
15:11:53 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
15:11:53 Dialog 0x20000 returned: 1
15:11:53 End Action ShowDialogsHlpr
15:11:53 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
15:11:53 Begin Action ShowDialogsHlpr: 0x40000
15:11:53 Begin Action: DialogShowSdCliSvr
15:11:53 DisplaySystemPreReq
15:11:53 [DlgClientServer]
15:11:53 Result = 1
15:11:53 Type = 2
15:11:53 ShowDlgClientServerSelect returned: 1
15:11:53 Type : 0x2
15:11:53 End Action DialogShowSdCliSvr
15:11:53 begin ShowDialogsUpdateMask
15:11:53 nFullMask = 0x1bf7c0f7, nCurrent = 0x40000, nDirection = 1
15:11:53 Updated Dialog Mask: 0x1bffc0f7, Disable Back = 0x1
15:11:53 Dialog 0x40000 returned: 1
15:11:53 End Action ShowDialogsHlpr
15:11:53 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
15:11:53 Begin Action ShowDialogsHlpr: 0x80000
15:11:53 Begin Action: DialogShowSdInstanceName
15:11:53 [DlgInstanceName]
15:11:53 Result = 1
15:11:53 InstanceName = MSSQLSERVER
15:11:53 Begin Action: ShowDlgInstanceName
15:12:52 End Action: ShowDlgInstanceName
15:12:52 ShowDlgInstanceName returned : -1
15:12:52 ShowDlgInstanceName: GetLastError returned: 50044
15:12:52 End Action DialogShowSdInstanceName
15:12:52 End Action ShowDialogs
15:12:52 Action CleanUpInstall:
15:12:52 StatsGenerate returned: 2
15:12:52 StatsGenerate (0x0,0x1,0xf00000,0x200,1033,0,0x0,0x1000000a,0,0,0
15:12:52 StatsGenerate -1,Administrator)
15:12:52 Installation Failed.

Any help??

steveo
Starting Member

16 Posts

Posted - 2002-08-08 : 17:59:36

Thanks for all your help!! Where was everyone on this one?

Anywho...the problem has been solved after working through it with a Microsoft SQL support rep. The key is to not follow directions exactly.

STEVE

solart
Posting Yak Master

148 Posts

Posted - 2002-08-09 : 12:14:39

Sorry for no response, just no experience/knowledge in this area. I am planning on putting up a SQL Server 2K cluster later this year, so would appreciate it if you would share what MS told you.

TIA solart

Argyle
Yak Posting Veteran

53 Posts

Posted - 2002-08-12 : 03:15:49

Is that the entire SqlstpN.log? There usually are some more information like "Setup could not find the specified file" and such. On www.googlecom it seams that your error in the log (50044) points to just that.

Are you installing from a CD? If so is that CD shared so that the other server can reach it? Try copying the files to the local drive before installing.

Other KB's that might help:

PRB: SQL Server 2000 Cluster Setup May Fail to Perform Required Operations on the Cluster Nodes When Special Characters are Used in the Resource Name
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q302491

Windows 2000 Cluster Nodes as Domain Controllers
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q281662

Microsoft Cluster Service Installation Resources
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q259267

Argyle
Yak Posting Veteran

53 Posts

Posted - 2002-08-12 : 03:17:20

Ops, didn't see your problem was already solved... :P

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources