I had 1 node of a 2 node SQL 2000 SP4 cluster fail. I had to rebuild node 1
and added back to the cluster
I installed SQL 2000 to the non-failed node and then applied SP4 to the same
non-failed node.
The setup failed. There was no NEED_SP_KEY in the registry which I am aware
would need to be deleted from the non-failed node. I've re-installed the OS
and re-applied the install and SP with same results.
The same install sequence I used works fine on my VMWare Virtual setup wich
I used to test the sequence first.
the sqlsp.log is as follows
13:49:21 Begin Setup
13:49:21 Version on Media: 8.00.2039
13:49:21 Mode = Normal
13:49:21 ModeType = NORMAL
13:49:21 Loading library - sqlsut.dll (#L1)
13:49:21 Begin: SetupInitialize()
13:49:22 End: SetupInitialize()
13:49:22 Begin: CheckFixedRequirements()
13:49:22 Platform ID: 0xf00000
13:49:22 Version: 5.2.3790
13:49:22 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.212
13:49:22 End: CheckFixedRequirements()
13:49:22 Processor Architecture: x86 (Pentium)
13:49:22 ComputerName: SMSARCCL2
13:49:22 User Name: SMSArchiveCluster
13:49:22 IsAllAccessAllowed returned: 1
13:49:22 OS Language: 0x809
13:49:22 Begin: SetupInstall()
13:49:22 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
13:49:22 CommonFilesDir=C:\Program Files\Common Files
13:49:22 Windows Directory=C:\WINDOWS\
13:49:22 Program Files=C:\Program Files\
13:49:22 TEMPDIR=C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\
13:49:22 End: SetupInstall()
13:49:24 Begin: ShowDialogs()
13:49:24 Initial Dialog Mask: 0x8300037, Disable Back=0x1
13:49:24 Begin Action ShowDialogsHlpr: 0x1
13:49:24 Begin Action: DialogShowSdWelcome
13:49:26 End Action DialogShowSdWelcome
13:49:26 Dialog 0x1 returned: 1
13:49:26 End Action ShowDialogsHlpr
13:49:26 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
13:49:26 Begin Action ShowDialogsHlpr: 0x2
13:49:26 Begin Action: DialogShowSdMachineName
13:50:41 ShowDlgMachine returned: 1
13:50:42 Name = SMSARCHIVECLU, Type = 0x20000008
13:50:42 End Action DialogShowSdMachineName
13:50:42 begin ShowDialogsUpdateMask
13:50:42 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
13:50:42 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
13:50:42 Dialog 0x2 returned: 1
13:50:42 End Action ShowDialogsHlpr
13:50:42 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
13:50:42 Begin Action ShowDialogsHlpr: 0x4
13:50:42 Begin Action: DialogShowSdInstallMode
13:50:42 ShowDlgInstallMode returned: 1
13:50:42 InstallMode : 0x2
13:50:42 End Action DialogShowSdInstallMode
13:50:42 begin ShowDialogsUpdateMask
13:50:42 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
13:50:42 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
13:50:42 Dialog 0x4 returned: 1
13:50:42 End Action ShowDialogsHlpr
13:50:42 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
13:50:42 Begin Action ShowDialogsHlpr: 0x200
13:50:42 Begin Action: DialogShowSdInstanceName
13:50:42 Begin Action: ShowDlgInstanceName
13:50:42 SKU is : Enterprise Edition
13:50:42 End Action: ShowDlgInstanceName
13:50:42 ShowDlgInstanceName returned : 0
13:50:42 InstanceName : MSSQLSERVER
13:50:42 End Action DialogShowSdInstanceName
13:50:42 begin ShowDialogsUpdateMask
13:50:42 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 0
13:50:42 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
13:50:42 Dialog 0x200 returned: 0
13:50:42 End Action ShowDialogsHlpr
13:50:42 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
13:50:42 Begin Action ShowDialogsHlpr: 0x400
13:50:42 Begin Action: DialogShowSdMaintain
13:50:42 ShowDlgMaintainInstall returned : 1
13:50:42 Type : 0xc
13:50:42 CreateSetupTopology(SMSARCCL2), Handle : 0x11e5068, returned : 0
13:50:42 CreateSetupTopology returned : 0, Handle : 0x11e5068
13:50:42 Topology Type : 1, Return Value : 0
13:50:42 ST_GetPhysicalNode returned : 0, PNHandle : 0x11e4150
13:50:42 PN_EnumerateEx returned : 0
13:50:42 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
13:50:42 PN_GetInstance for MSSQLSERVER [0x11e4150] returned : 0
13:50:42 SQLI_GetPackageId [0x11e46c0] returned : 0, PackageId = 0x3
13:50:42 SQLI_GetVersion [0x11e46c0] returned : 0, Version = 8.00.194
13:50:42 SQLI_GetSQLStates for MSSQLSERVER [0x11e46c0] returned : 0,
SQLStates: 0x400209
13:50:42 SQLI_GetInstallPath [0x11e46c0] returned : 0, Path = C:\Program
Files\Microsoft SQL Server\MSSQL
13:50:42 SQLI_GetDataPath [0x11e46c0] returned : 0, DataPath = G:\Program
Files\Microsoft SQL Server\MSSQL
13:50:42 SQLI_GetVersion [0x11e46c0] returned : 0, Version = 8.00.194
13:50:42 SQLI_GetRegKeyRoot [0x11e46c0] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
13:50:42 SQLI_GetPackageName [0x11e46c0] returned : 0, szPackage =
Enterprise Edition
13:50:42 SQLI_GetPackageId [0x11e46c0] returned : 0, PackageId = 0x3
13:50:42 Previous Install Path: C:\Program Files\Microsoft SQL
Server\MSSQL
13:50:42 Previous Install Data: G:\Program Files\Microsoft SQL
Server\MSSQL
13:50:42 Previous Install Version: 8.00.194
13:50:42 ReleaseSetupTopology
13:50:42 End Action DialogShowSdMaintain
13:50:42 begin ShowDialogsUpdateMask
13:50:42 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
13:50:42 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:50:42 Dialog 0x400 returned: 1
13:50:42 End Action ShowDialogsHlpr
13:50:42 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
13:50:42 Begin Action ShowDialogsHlpr: 0x2000
13:50:42 Begin Action: DialogShowSdUpgrade
13:50:42 ShowDlgUpgrade returned : 1
13:50:42 Checking databases on instance 'MSSQLSERVER'
13:50:42 Begin Action: Check for VS Node
13:50:42 Begin Action: Check for VS Node
13:50:42 Begin Action: Cluster Resources Offline
13:50:49 End Action: Cluster Resources Offline
13:50:49 Authenticate access
13:50:49 Begin SDPassword Dialog
13:50:51 End SDPassword Dialog
13:50:51 C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
13:50:51 Process Exit Code: (0)
13:50:51 C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022
13:51:03 Process Exit Code: (0)
13:51:03 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:SMSARCHIVECLU -n -d master -Q
"exit" -o "C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\sqlsp.out" -E
13:51:03 Process Exit Code: (0)
13:51:03 Begin: CheckSAPassword
13:51:03 Begin: LogOnUsingBlankSA
13:51:03 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:SMSARCHIVECLU -n -d master -o
"C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\sqlsp.out" -Q"Exit(declare @ret int if
(select count(*) from master..syslogins where name='sa' AND ( (1 = pwd
13:51:03 Process Exit Code: (0)
13:51:03 End: LogOnUsingBlankSA
13:51:03 Begin: SdBlankPwd
13:51:03 End: SdBlankPwd
13:51:03 End: CheckSAPassword
13:51:03 Begin : SdErrorReportingDlg
13:51:05 End: SdErrorReportingDlg
13:51:06 Access authenticated
13:51:06 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:SMSARCHIVECLU -n -b -d
master -o "C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\~sqldb0.txt" -i
"C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\SqlSetup\Bin\dbverify.sql" -E
13:51:06 Process Exit Code: (0)
13:51:06 C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
13:51:21 Process Exit Code: (0)
13:51:21 Setup Type: Custom (303)
13:51:21 Processing: SQLProg
13:51:21 Processing: SQLProg\SQLServr
13:51:21 Processing: SQLProg\UpgTools
13:51:21 Processing: SQLProg\ReplSupp
13:51:21 Processing: SQLProg\Install
13:51:21 Processing: SQLProg\System
13:51:21 Processing: SQLProg\SvrExt
13:51:21 Processing: SQLProg\Dat
13:51:21 Processing: SQLProg\DatSmpl
13:51:21 Processing: SQLProg\BaseSys
13:51:21 Processing: SQLProg\BaseBinn
13:51:21 Processing: SQLProg\MSSearch
13:51:21 Processing: SQLProg\BaseInst
13:51:21 Processing: SQLProg\UI
13:51:21 Processing: SQLProg\Symbols
13:51:21 Processing: SQLProg\Perfmon
13:51:21 Processing: SQLProg\Root
13:51:21 Processing: SQLProg\EXE
13:51:21 Processing: SQLProg\DLL
13:51:21 Processing: MgtTool
13:51:21 Processing: MgtTool\SEM
13:51:21 Processing: MgtTool\Profiler
13:51:21 Processing: MgtTool\Qryanlz
13:51:22 Processing: MgtTool\DTCCLi
13:51:22 Processing: MgtTool\Wzcnflct
13:51:22 Processing: MgtTool\UtilSys
13:51:22 Processing: MgtTool\UtilBinn
13:51:22 Processing: Connect
13:51:22 Processing: Connect\ConnSys
13:51:22 Processing: Books
13:51:22 Processing: Books\Bookso
13:51:22 Processing: DevTools
13:51:22 Processing: DevTools\Headers and Libraries
13:51:22 Processing: DevTools\MDAC SDKs
13:51:22 Processing: DevTools\VDI
13:51:22 Processing: DevTools\Dbg Int
13:51:22 Processing: Samples
13:51:22 Processing: Samples\ADO
13:51:22 Processing: Samples\DBLIB
13:51:22 Processing: Samples\Desktop
13:51:22 Processing: Samples\DTS
13:51:22 Processing: Samples\ESQLC
13:51:22 Processing: Samples\Misc
13:51:22 Processing: Samples\MSDTC
13:51:22 Processing: Samples\ODBC
13:51:22 Processing: Samples\ODS
13:51:22 Processing: Samples\OLEAut
13:51:22 Processing: Samples\Repl
13:51:22 Processing: Samples\SilverstoneDB
13:51:22 Processing: Samples\SQLDMO
13:51:22 Processing: Samples\SQLNS
13:51:22 Processing: Samples\Utils
13:51:22 Processing: Samples\XML
13:51:22 Processing: CoreRepl
13:51:22 Processing: CoreRepl\Res1033
13:51:22 Processing: CoreRepl\ResIntl
13:51:22 Processing: Core
13:51:22 Processing: Core\Res1033
13:51:22 Processing: Core\ResOther
13:51:22 Processing: Repostry
13:51:22 Processing: Repostry\RepstSys
13:51:22 Processing: Repostry\Res1033
13:51:22 Processing: Repostry\ResIntl
13:51:22 Processing: CoreMisc
13:51:22 Processing: CoreMisc\ActiveX
13:51:22 Processing: CoreMisc\Res1033
13:51:22 Processing: Monarch
13:51:22 Processing: Monarch\Monr1033
13:51:22 Processing: Monarch\MonrIntl
13:51:22 Processing: Jet
13:51:22 Processing: CoreInst
13:51:22 Processing: CoreCOM
13:51:22 Processing: CoreCOM\Res1033
13:51:22 Processing: CoreCOM\ResIntl
13:51:22 Processing: CoreTool
13:51:22 Processing: CoreTool\Res1033
13:51:22 Processing: CoreTool\ResOther
13:51:22 Processing: DBLibCli
13:51:22 Processing: SFExt
13:51:22 Processing: SFExt\ActiveX
13:51:22 Processing: SFExt\Res1033
13:51:22 Processing: SFExt\ResIntl
13:51:22 Processing: Trace
13:51:22 Processing: Trace\Res1033
13:51:22 Processing: Trace\ResOther
13:51:22 Processing: CnctBinn
13:51:22 Processing: MiscCore
13:51:22 Processing: MC
13:51:22 Processing: MC\MC1033
13:51:22 Processing: MC\MCIntl
13:51:22 Processing: MC\Help
13:51:22 Processing: UI
13:51:22 Processing: UI\UIHlp
13:51:22 Processing: UI\UI1033
13:51:22 Processing: UI\UIIntl
13:51:22 Processing: ClstSys
13:51:22 Processing: SQLMgr
13:51:22 Processing: SQLMgr\Res1033
13:51:22 Processing: SQLMgr\ResIntl
13:51:22 Processing: SvrTool
13:51:22 Processing: SvrTool\Res1033
13:51:22 Processing: SvrTool\ResIntl
13:51:22 Processing: DTSUI
13:51:22 Processing: DTSUI\Res1033
13:51:22 Processing: DTSUI\ResIntl
13:51:22 Processing: ClFTSys
13:51:22 Processing: ClFtdata
13:51:22 Processing: MSOlap
13:51:22 Processing: MSOlap\Res1033
13:51:22 Processing: MSOlap\ResIntl
13:51:22 Processing: ATL
13:51:22 Processing: ATL\winnt
13:51:22 Processing: ATL\win9x
13:51:22 Processing: MFC42U
13:51:22 Processing: VC
13:51:22 Processing: VB
13:51:22 Processing: OCX1
13:51:22 Processing: SQLAdHlp
13:51:22 Processing: SQLAdHlp\Res1033
13:51:22 Processing: SQLAdHlp\ResOther
13:51:22 Setup type: Custom
13:51:22 End Action DialogShowSdUpgrade
13:51:22 begin ShowDialogsUpdateMask
13:51:22 nFullMask = 0xb03e607, nCurrent = 0x2000, nDirection = 1
13:51:22 Updated Dialog Mask: 0xb03e003, Disable Back = 0x1
13:51:22 Dialog 0x2000 returned: 1
13:51:22 End Action ShowDialogsHlpr
13:51:22 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
13:51:22 Begin Action ShowDialogsHlpr: 0x4000
13:51:22 Skipping DialogShowSdVirtualServer
13:51:22 begin ShowDialogsUpdateMask
13:51:22 nFullMask = 0xb03e003, nCurrent = 0x4000, nDirection = 1
13:51:22 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:22 Dialog 0x4000 returned: 1
13:51:22 End Action ShowDialogsHlpr
13:51:22 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
13:51:22 Begin Action ShowDialogsHlpr: 0x8000
13:51:22 Begin Action : DialogShowSdDiskGroups
13:51:22 ShowDlgDiskGroups returned: 1
13:51:22 Disk Group = Group 0
13:51:22 End Action : DialogShowSdDiskGroups
13:51:22 begin ShowDialogsUpdateMask
13:51:22 nFullMask = 0xb03e607, nCurrent = 0x8000, nDirection = 1
13:51:22 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:22 Dialog 0x8000 returned: 1
13:51:22 End Action ShowDialogsHlpr
13:51:22 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
13:51:22 Begin Action ShowDialogsHlpr: 0x10000
13:51:22 Begin Action: DialogShowSdClusterDef
13:51:22 Before !! The Prefowner list is : . g_szSpNeededNodelst is : .
g_nNumnodes :0 g_szOwners :, g_szDiskGroup Group 0
13:51:22 ShowDlgClusterDef returned: 1
13:51:22 PrefOwners = SMSARCCL2,SMSARCCL1, NumIp = 2
13:51:22 Begin Action : ValidateNodeActions
13:51:22 Begin Action : EnumerateInstancesForVirtualServer
13:51:22 End Action : EnumerateInstancesForVirtualServer
13:51:22 Begin Action : ValidateNodeActions
13:51:22 End Action : ValidateNodeActions
13:51:22 End Action : ValidateNodeActions
13:51:22 End Action DialogShowSdClusterDef
13:51:22 begin ShowDialogsUpdateMask
13:51:22 nFullMask = 0xb03e607, nCurrent = 0x10000, nDirection = 1
13:51:22 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:22 Dialog 0x10000 returned: 1
13:51:22 End Action ShowDialogsHlpr
13:51:22 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
13:51:22 Begin Action ShowDialogsHlpr: 0x20000
13:51:22 Begin Action : Cluster Security - DlgAcct
13:51:31 ShowDlgAcct returned: 1
13:51:31 [DlgAccount]
13:51:31 Domain = SMSDOMAIN
13:51:31 DomainAcct = SMSArchiveCluster
13:51:31 Result = 1
13:51:31 End Action : Cluster Security - DlgAcct
13:51:31 begin ShowDialogsUpdateMask
13:51:31 nFullMask = 0xb03e607, nCurrent = 0x20000, nDirection = 1
13:51:31 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:31 Dialog 0x20000 returned: 1
13:51:31 End Action ShowDialogsHlpr
13:51:31 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
13:51:31 Begin Action ShowDialogsHlpr: 0x1000000
13:51:31 Begin Action: DlgCollation
13:51:31 ShowDlgCollation returned: 1
13:51:31 collation_name = Latin1_General_CI_AS,locale_name =
Latin1_General,lcid = 0x809,SortId = 0,dwCompFlags = 0x30001
13:51:31 End Action DlgCollation
13:51:31 begin ShowDialogsUpdateMask
13:51:31 nFullMask = 0xb03e607, nCurrent = 0x1000000, nDirection = 1
13:51:31 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:31 Dialog 0x1000000 returned: 1
13:51:31 End Action ShowDialogsHlpr
13:51:31 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
13:51:31 Begin Action ShowDialogsHlpr: 0x2000000
13:51:31 Begin Action: DlgNetwork
13:51:31 ShowDlgNetwork returned: 1
13:51:31 [DlgServerNetwork]
13:51:31 NetworkLibs = 255
13:51:31 TCPPort = 1433
13:51:31 TCPPrxy = Default
13:51:31 NMPPipeName = \\.\pipe\sql\query
13:51:31 Result = 1
13:51:31 End Action DlgNetwork
13:51:31 begin ShowDialogsUpdateMask
13:51:31 nFullMask = 0xb03e607, nCurrent = 0x2000000, nDirection = 1
13:51:31 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
13:51:31 Dialog 0x2000000 returned: 1
13:51:31 End Action ShowDialogsHlpr
13:51:31 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
13:51:31 Begin Action ShowDialogsHlpr: 0x8000000
13:51:31 Begin Action: DialogShowSdStartCopy
13:51:31 End Action DialogShowSdStartCopy
13:51:31 begin ShowDialogsUpdateMask
13:51:31 nFullMask = 0xb03e607, nCurrent = 0x8000000, nDirection = 1
13:51:31 Updated Dialog Mask: 0x803e607, Disable Back = 0x1
13:51:31 Dialog 0x8000000 returned: 1
13:51:31 End Action ShowDialogsHlpr
13:51:31 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
13:51:31 End: ShowDialogs()
13:51:31 Initializing Event Log
13:51:31 Begin Action : LogEvent
13:51:31 End Action : LogEvent
13:51:31 Begin Action : ClusterSetupHelper
13:51:31 Begin Action : CreateClustISSFiles
13:51:31 End Action : CreateClustISSFiles
13:51:31 Begin Action : ClusterWriteRemIni
13:51:31 End Action : ClusterWriteRemIni
13:51:31 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=2
Server.1=SMSARCCL2
Server.2=SMSARCCL1
[Server.1]
NumRemoteServices=1
1.app="\\SMSARCCL2\C$\SQL2KSP4\x86\setup\setupsql.exe"
1.server=SMSARCCL2
1.script=\\SMSARCCL2\admin$\SMSARCCL2_MSSQLSERVER.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
"\\SMSARCCL2\C$\SQL2KSP4\x86\setup\setup.ins" -f1 %s -f2
"\\SMSARCCL2\admin$\setup.log" -e "stpsilnt._ex" -b -x
"C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\"
1.user=SMSDOMAIN\SMSArchiveCluster
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app="\\SMSARCCL2\C$\SQL2KSP4\x86\setup\setupsql.exe"
1.server=SMSARCCL1
1.script=\\SMSARCCL2\admin$\SMSARCCL1_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\SMSARCCL2\C$\SQL2KSP4\x86\setup\setup.ins" -f1 %s -f2
"\\SMSARCCL1\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=SMSDOMAIN\SMSArchiveCluster
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
13:51:31 Setup is performing required operations on cluster nodes. This may
take a few minutes...
13:51:31 "C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\SqlSetup\Bin\remsetup.exe"
C:\WINDOWS\remsetup.ini
13:57:17 Process Exit Code: (-12)
13:57:17 Begin Action : GetRemsetupRetCode
13:57:17 Installation return status on SMSARCCL2 : 0
13:57:17 Installation return status on SMSARCCL1 : -12
13:57:17 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 08/31/05 13:51:32 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x7c] created for execution.
CThread::Process [0x7c]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
CThread::Run thread [0x84] created for execution.
CThread::Process [0x84]
CThreadPool::RunUntilCompleteHlpr start thread [0x7c],index=0
CThreadPool::RunUntilCompleteHlpr start thread [0x84],index=1
Script file copied to '\\SMSARCCL1\ADMIN$\SMSARCCL1_MSSQLSERVER.iss'
successfully.
Installing remote service (SMSARCCL1)...
CProcess::RunUntilComplete [0x7c] exit code: 0
Remote process exit code was '0' (SMSARCCL2).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x7c]
Thread [0x7c] exit code: [0x0]
CRemoteProcess::RunUntilComplete [0x84] exit code: -12
Remote process exit code was '-12' (SMSARCCL1).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x84]
Thread [0x84] exit code: [0xfffffff4]
CThreadPool::RunUntilComplete returned -12
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (SMSARCCL2)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 08/31/05 13:57:04 ####
Disconnecting from remote machine (SMSARCCL1)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 08/31/05 13:57:17 ####
13:57:17 End Action : Run setup on cluster nodes
13:57:17 One or more errors occurred while running remote setup on the
clustered machines.
13:57:40 Setup failed to perform required operations on the cluster nodes.
13:57:40 End Action : ClusterSetupHelper
13:57:40 Begin Action : LogEvent
13:57:40 End Action : LogEvent
13:57:40 Begin Action : CloseEventLog
13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 01 Sep 2005 14:29 GMT
Node 1 is the failed node, node 2 has SP4 installed.
1 - add node 1 to domain
2 - drop node 2
3 - bring node 1 online to verify disk access and assign the same drive
letters as node 2
4 - drop node 1
5 - bring on-line node 2
6 - bring on-line node 1
7 - enable network access for MSDTC node 1
8 - add node 1 to cluster
9 - Install SQL 2000 node 2
10 - verify administrators group on machine has same accounts as node 2
11 - find and delete NEEP_SP_KEY from node 2 (SP 4 bug). Not always present
and not found in this instance.
12 - Install SP4 node 2 ---> failure
Many thanks for anybody who even looks at this
Nik Marshall-Blank MCSD/MCDBA
>I had 1 node of a 2 node SQL 2000 SP4 cluster fail. I had to rebuild node 1
> and added back to the cluster
[quoted text clipped - 482 lines]
> 13:57:40 Begin Action : CloseEventLog
> 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 01 Sep 2005 14:37 GMT
And sqlsp.log on the rebuilt node is
13:28:39 Begin Setup
13:28:39 Version on Media: 8.00.761
13:28:39 Mode = Normal
13:28:39 ModeType = NORMAL
13:28:39 Begin: SetupInitialize()
13:28:39 End: SetupInitialize()
13:28:39 Begin: CheckFixedRequirements()
13:28:39 Platform ID: 0xf00000
13:28:39 Version: 5.2.3790
13:28:39 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.1830
13:28:40 End: CheckFixedRequirements()
13:28:40 Processor Architecture: x86 (Pentium)
13:28:40 Service Pack: 256
13:28:40 ComputerName: SMSARCCL1
13:28:40 User Name: smsarchivecluster
13:28:40 IsAllAccessAllowed returned: 1
13:28:40 OS Language: 0x809
13:28:40 Begin: SetupInstall()
13:28:40 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
13:28:40 CommonFilesDir=C:\Program Files\Common Files
13:28:40 Windows Directory=C:\WINDOWS\
13:28:40 Program Files=C:\Program Files\
13:28:40 TEMPDIR=C:\DOCUME~1\SMSARC~1\LOCALS~1\Temp\1\
13:28:40 End: SetupInstall()
13:28:40 Begin: ShowDialogs()
13:28:40 Initial Dialog Mask: 0x8300037, Disable Back=0x1
13:28:40 Begin Action ShowDialogsHlpr: 0x1
13:28:40 Begin Action: DialogShowSdWelcome
13:28:42 End Action DialogShowSdWelcome
13:28:42 Dialog 0x1 returned: 1
13:28:42 End Action ShowDialogsHlpr
13:28:42 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
13:28:42 Begin Action ShowDialogsHlpr: 0x2
13:28:42 Begin Action: DialogShowSdMachineName
13:29:02 ShowDlgMachine returned: -1
13:29:02 ShowDlgMachine: GetLastError returned: 0
13:29:02 The operation completed successfully.
13:29:02 End Action DialogShowSdMachineName
13:29:02 End: ShowDialogs()
13:29:02 Action CleanUpInstall:
13:29:02 Installation Failed.
> Node 1 is the failed node, node 2 has SP4 installed.
>
[quoted text clipped - 506 lines]
>> 13:57:40 Begin Action : CloseEventLog
>> 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 01 Sep 2005 15:14 GMT
This is in the setup.log in c:\windows
[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-12
and also I get this is the failing nodes sqlsp1.log
14:47:05 Begin: SdShowSp3WrngDlg
but no End Action. I think the install on node 1 is displaying a dialog in
silent mode. But why? Any ideas.
> And sqlsp.log on the rebuilt node is
>
[quoted text clipped - 558 lines]
>>> 13:57:40 Begin Action : CloseEventLog
>>> 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 01 Sep 2005 19:28 GMT
Well..
It looks like I'm helping my self here. This is the dialog box tat's being
displayed
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A
3/ReadmeSql2k32sp4.htm#_backward_compatibility_checklist_dialog__238p
So All I have to do is get SP3 applied. I've tested that applying SP3 over
SP4 causes no damage nor reverts SP4 back to SP3. So now to get 2 servers at
SQL 2000 RTM and SP4 apply SP3 to SP4 to get SP3 and SP4 (I hope) and then
apply SP4 to SP4 to get both at SP4. I'll post my results as it may be
useful to others.
> This is in the setup.log in c:\windows
>
[quoted text clipped - 576 lines]
>>>> 13:57:40 Begin Action : CloseEventLog
>>>> 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 01 Sep 2005 19:48 GMT
That works. Sp4 gets ultimately applied to both machines.
MSDTC got installed as auto but easily amended to manual startup.
Failover tested successfully.
> Well..
>
[quoted text clipped - 589 lines]
>>>>> 13:57:40 Begin Action : CloseEventLog
>>>>> 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 02 Sep 2005 06:43 GMT
Just to confitm that works.
So it appears that to recover from a failed node to SP4 level can happen in
1 of 3 ways.
1 - No problems as Microsoft expects.
2 - Registry key NEEP_SP_KEY to be deleted from the operational SP4 node
after SQL RTM install.
3 - After installing SQL 2000 RTM to the operational SP4 node, apply SP3 to
the operational SP4 node then apply SP4 again after that.
I would be interested in comments from anybody from Microsoft about this.
>I had 1 node of a 2 node SQL 2000 SP4 cluster fail. I had to rebuild node 1
> and added back to the cluster
[quoted text clipped - 482 lines]
> 13:57:40 Begin Action : CloseEventLog
> 13:57:40 End Action : CloseEventLog
Hiren - 16 Sep 2005 18:59 GMT
Hi Nik Marshall,
I came across the same situation and not be able to apply SP4.
Thanks a lot to your research and details which help me to install SP3
first and SP4 successfully.
What microsoft try to achive with this kind of bugs....
Thanks again a lot for your very usefull artical.
Thanks,
Hiren
> Just to confitm that works.
>
[quoted text clipped - 496 lines]
> > 13:57:40 Begin Action : CloseEventLog
> > 13:57:40 End Action : CloseEventLog
Nik Marshall-Blank - 23 Sep 2005 12:48 GMT
Glad it worked.

Signature
Nik Marshall-Blank MCSD/MCDBA
> Hi Nik Marshall,
> I came across the same situation and not be able to apply SP4.
[quoted text clipped - 524 lines]
>> > 13:57:40 Begin Action : CloseEventLog
>> > 13:57:40 End Action : CloseEventLog