August 6, 2002 at 3:42 pm
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??
August 6, 2002 at 6:39 pm
I found this in the MS Knowledge Base. Footprint looks similar:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q318672
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 7, 2002 at 4:48 pm
Thanks. This just does the cluster install in 2 steps (first exclude 2nd node and setup virtual server on 1st, then add 2nd). The end result was the same.
Although, there was a different error that popped up on the 2nd node after failure. It claimed that it was unable to load REPLRES.DLL
I cannot find this DLL on the cd or anywhere on my first nodes successful install.
Any ideas. Searching on the net seems to indicate that it's a SQL7-related file.
August 7, 2002 at 6:23 pm
The only applicable knowledge base article dealing with clustering that pulls up on replres.dll is a SQL Server 7.0 one.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q254593
I'll try to remember to look at my clusters tomorrow to see if I find that file.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 8, 2002 at 6:33 am
I can not seem to find the DLL file on my cluster server but the closest I got to it was in C:\Program Files\Microsoft SQL Server\80\COM\Resources\1033 which is a RESPEL file but not a .dll
I had the same problem before with DLLs missing from the second node but my case was sqagtres.dll file. I manually copied it to the System32 folders and it worked.
August 8, 2002 at 10:06 am
Can anyone provide a list of SQL dlls that I could proload on node2 and where they go?
Maybe that's my problem.
I believe part of the problem may be that these two servers are also domain controllers. Although all the domain accounts I have setup appear to work fine from either machine (the admin account and the sql service account).
Some instructions talk about making sure that your user has admin rights and rights to 'log on as service'. I can't find any setting for 'log on as service' in the Active Directory User manager.
Or could Win2000 SP2 be causing this problem with the install?
August 8, 2002 at 10:16 am
Caveat!! Caveat!! I am *not* an AD expert, however...if you go to: Domain Controller Security Policy in Admin Tools, then open the tree: Windows Settings...Security Settings...Local Policies...User Rights Assignment, scroll down, you can see the "Log on as a service" right, and who it is assigned to, right click to change it.
I hope this helps you. As a general question, aside from the economics, who decided to put SQL on a cluster which is also the domain controller? AD is much more cpu-intensive than NT's DC roles - I would have thought a separate server for the AD root would have been easier?
Simon, UK
August 8, 2002 at 3:54 pm
Pure economics. Not just a 2nd server would be needed....2 servers would be to provide fault tolerance for AD/Clusters ability to run/etc. Hopefully at a later date we will be able to have the data servers just handle data.
August 8, 2002 at 4:00 pm
PROBLEM SOLVED.
I did get SQL 2000 Enterprise to install properly on the 2-nodes. Thanks bkelley for finding the KB article and an MS support rep for providing an alternate workaround.
While the articles workaround did not work...a slight variation of it did. The key was to add the second node to the virtual server FROM THE SECOND NODE and not from the FIRST as the KB article says.
Then the second virtual server was installed in reverse order of the first. Both instances are working great and failover is functioning properly so far.
One of those instances where not following the directions precisely works...
THANKS ALL!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply