Building an Active/Active/Passive SQL 2000 cluster on top of a 3 node 2003
server cluster. As I go to install I end up getting a "An error occured
while creating virtual server resources for clustering. The system cannot
find the file specified."
I've gone through KB 815431 and made sure the named piped alias is
configured properly and it appears to be working correctly. Let me know if
anyone has any ideas. Here's my sqlstp.log up to the point of the error.
16:12:58 Begin Setup
16:12:58 8.00.194
16:12:58 Mode = Normal
16:12:58 ModeType = NORMAL
16:12:58 GetDefinitionEx returned: 0, Extended: 0x0
16:12:58 ValueFTS returned: 1
16:12:58 ValuePID returned: 1
16:12:58 ValueLic returned: 1
16:12:58 System: Windows NT Enterprise Server
16:12:58 SQL Server ProductType: Enterprise Edition [0x3]
16:12:58 IsNTCluster returned: 1
16:12:58 Begin Action: SetupInitialize
16:12:58 End Action SetupInitialize
16:12:58 Begin Action: SetupInstall
16:12:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
16:12:58 CommonFilesDir=C:\Program Files\Common Files
16:12:58 Windows Directory=C:\WINDOWS\
16:12:58 Program Files=C:\Program Files\
16:12:58 TEMPDIR=C:\WINDOWS\TEMP\
16:12:58 Begin Action: SetupInstall
16:12:58 digpid size : 256
16:12:58 digpid size : 164
16:12:58 Begin Action: CheckFixedRequirements
16:12:58 Platform ID: 0xf00000
16:12:58 Version: 5.2.3790
16:12:58 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.279
16:12:58 End Action: CheckFixedRequirements
16:12:58 Begin Action: ShowDialogs
16:12:58 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
16:12:58 Begin Action ShowDialogsHlpr: 0x1
16:12:58 Begin Action: DialogShowSdWelcome
16:13:01 End Action DialogShowSdWelcome
16:13:01 Dialog 0x1 returned: 1
16:13:01 End Action ShowDialogsHlpr
16:13:01 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:13:01 Begin Action ShowDialogsHlpr: 0x2
16:13:01 Begin Action: DialogShowSdMachineName
16:13:15 ShowDlgMachine returned: 1
16:13:15 Name = NPBSQLC7, Type = 0x10000008
16:13:15 Begin Action: CheckRequirements
16:13:15 Processor Architecture: x86 (Pentium)
16:13:15 ComputerName: NPBSQL6
16:13:15 User Name: <Removed>
16:13:15 IsAllAccessAllowed returned: 1
16:13:15 OS Language: 0x409
16:13:15 End Action CheckRequirements
16:13:15 This combination of Package and Operating System allows a full
product install.
16:13:15 End Action DialogShowSdMachineName
16:13:15 begin ShowDialogsUpdateMask
16:13:15 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
16:13:15 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
16:13:15 Dialog 0x2 returned: 0
16:13:15 End Action ShowDialogsHlpr
16:13:15 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:13:15 Begin Action ShowDialogsHlpr: 0x4
16:13:15 Begin Action: DialogShowSdInstallMode
16:13:15 InstallMode : 0x1
16:13:15 End Action DialogShowSdInstallMode
16:13:15 begin ShowDialogsUpdateMask
16:13:15 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
16:13:15 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:15 Dialog 0x4 returned: 1
16:13:15 End Action ShowDialogsHlpr
16:13:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
16:13:15 Begin Action ShowDialogsHlpr: 0x10
16:13:15 Begin Action: DialogShowSdRegisterUserEx
16:13:17 End Action DialogShowSdRegisterUserEx
16:13:17 begin ShowDialogsUpdateMask
16:13:17 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
16:13:17 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:17 Dialog 0x10 returned: 1
16:13:17 End Action ShowDialogsHlpr
16:13:17 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
16:13:17 Begin Action ShowDialogsHlpr: 0x20
16:13:17 Begin Action: DialogShowSdLicense
16:13:17 End Action DialogShowSdLicense
16:13:17 Dialog 0x20 returned: 1
16:13:17 End Action ShowDialogsHlpr
16:13:17 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
16:13:17 Begin Action ShowDialogsHlpr: 0x4000
16:13:17 Begin Action: DialogShowSdVirtualServer
16:13:27 ShowDlgVirtualServer returned: 0
16:13:27 Ipaddress = 10.10.0.58,255.255.252.0,SQL2 Public Team
16:13:27 szNewList = 10.10.0.58,255.255.252.0,SQL2 Public Team
16:13:27 szModifiedList =
16:13:27 szRemovedList =
16:13:27 End Action DialogShowSdVirtualServer
16:13:27 begin ShowDialogsUpdateMask
16:13:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
16:13:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:27 Dialog 0x4000 returned: 1
16:13:27 End Action ShowDialogsHlpr
16:13:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:13:27 Begin Action ShowDialogsHlpr: 0x8000
16:13:27 Begin Action : DialogShowSdDiskGroups
16:13:30 ShowDlgDiskGroups returned: 1
16:13:30 Disk Group = NPBSQLC7
16:13:30 End Action : DialogShowSdDiskGroups
16:13:30 begin ShowDialogsUpdateMask
16:13:30 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
16:13:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:30 Dialog 0x8000 returned: 1
16:13:30 End Action ShowDialogsHlpr
16:13:30 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:13:30 Begin Action ShowDialogsHlpr: 0x10000
16:13:30 Begin Action: DialogShowSdClusterDef
16:13:31 ShowDlgClusterDef returned: 1
16:13:31 PrefOwners = NPBSQL6,NPBSQL7,NPBSQL8, NumIp = 3
16:13:31 Begin Action : ValidateNodeActions
16:13:31 Begin Action : ValidateNodeActions
16:13:31 End Action : ValidateNodeActions
16:13:31 End Action : ValidateNodeActions
16:13:31 End Action DialogShowSdClusterDef
16:13:31 begin ShowDialogsUpdateMask
16:13:31 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
16:13:31 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:31 Dialog 0x10000 returned: 1
16:13:31 End Action ShowDialogsHlpr
16:13:31 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
16:13:31 Begin Action ShowDialogsHlpr: 0x20000
16:13:31 Begin Action : Cluster Security - DlgAcct
16:13:39 ShowDlgAcct returned: 1
16:13:39 [DlgAccount]
16:13:39 Domain = <Removed>
16:13:40 DomainAcct = <Removed>
16:13:40 DomainPwd
16:13:40 Result = 1
16:13:40 End Action : Cluster Security - DlgAcct
16:13:40 begin ShowDialogsUpdateMask
16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
16:13:40 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:40 Dialog 0x20000 returned: 1
16:13:40 End Action ShowDialogsHlpr
16:13:40 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
16:13:40 Begin Action ShowDialogsHlpr: 0x40000
16:13:40 Begin Action: DialogShowSdCliSvr
16:13:40 DisplaySystemPreReq
16:13:40 ShowDlgClientServerSelect returned: 1
16:13:40 Type : 0x2
16:13:40 End Action DialogShowSdCliSvr
16:13:40 begin ShowDialogsUpdateMask
16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
16:13:40 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:40 Dialog 0x40000 returned: 1
16:13:40 End Action ShowDialogsHlpr
16:13:40 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
16:13:40 Begin Action ShowDialogsHlpr: 0x80000
16:13:40 Begin Action: DialogShowSdInstanceName
16:13:40 Begin Action: ShowDlgInstanceName
16:13:46 End Action: ShowDlgInstanceName
16:13:46 ShowDlgInstanceName returned : 1
16:13:46 InstanceName : INSTANCEC7
16:13:46 End Action DialogShowSdInstanceName
16:13:46 begin ShowDialogsUpdateMask
16:13:46 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
16:13:46 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:46 Dialog 0x80000 returned: 1
16:13:46 End Action ShowDialogsHlpr
16:13:46 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
16:13:46 Begin Action ShowDialogsHlpr: 0x100000
16:13:46 Begin Action: DialogShowSdSetupType
16:13:46 Begin Action: Setup Type
16:13:50 [SetupTypeSQL]
16:13:50 szDir = C:\Program Files\Microsoft SQL Server
16:13:50 szDir = C:\Program Files\Microsoft SQL Server
16:13:50 Result = 303
16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
16:13:50 End Action: Setup Type
16:13:50 Setup Type: Custom (303)
16:13:50 End Action DialogShowSdSetupType
16:13:50 begin ShowDialogsUpdateMask
16:13:50 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
16:13:50 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:50 Dialog 0x100000 returned: 303
16:13:50 End Action ShowDialogsHlpr
16:13:50 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
16:13:50 Begin Action ShowDialogsHlpr: 0x200000
16:13:50 Begin Action: DialogShowSdComponentMult
16:13:50 basesys = 0, baseinst = 0, basedata = 0
16:13:50 Begin Action: Component Handler
16:13:54 SQL program folder: C:\Program Files\Microsoft SQL
Server\MSSQL$INSTANCEC7
16:13:54 SQL data folder: R:\Program Files\Microsoft SQL
Server\MSSQL$INSTANCEC7
16:13:54 Windows system folder: C:\WINDOWS\system32\
16:13:54 Prog req: 22162, Data req: 34432, Sys req: 181286
16:13:54 Prog avail: 28555808, Data avail: 61083436, Sys avail: 28555808
16:13:54 Prog req vs. avail, 203448, 28555808
16:13:54 Data req vs. avail, 34432, 61083436
16:13:54 Sys req vs. avail, 181286, 28555808
16:13:54 DisplaySystemPreReq
16:13:54 [SQLComponentMult]
16:13:56 Component =
16:13:56 Result = 1
16:13:56 End Action: Component Handler
16:13:56 End Action DialogShowSdComponentMult
16:13:56 begin ShowDialogsUpdateMask
16:13:56 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
16:13:56 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:56 Dialog 0x200000 returned: 1
16:13:56 End Action ShowDialogsHlpr
16:13:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
16:13:56 Begin Action ShowDialogsHlpr: 0x400000
16:13:56 Begin Action: DlgServices
16:14:15 ShowDlgServices returned: 1
16:14:15 [DlgServices]
16:14:15 Local-Domain= 61680
16:14:15 AutoStart= 0
16:14:15 SQLDomain= <Removed>
16:14:15 SQLDomainAcct= <Removed>
16:14:15 SQLDomainPwd
16:14:15 AgtDomain= <Removed>
16:14:15 AgtDomainAcct= <Removed>
16:14:15 AgtDomainPwd
16:14:15 Result= 1
16:14:15 End Action DlgServices
16:14:15 begin ShowDialogsUpdateMask
16:14:15 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
16:14:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:15 Dialog 0x400000 returned: 1
16:14:15 End Action ShowDialogsHlpr
16:14:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
16:14:15 Begin Action ShowDialogsHlpr: 0x800000
16:14:15 Begin Action: DlgSQLSecurity
16:14:19 ShowDlgSQLSecurity returned: 1
16:14:19 LoginMode = 1,szPwd
16:14:19 End Action DlgSQLSecurity
16:14:19 begin ShowDialogsUpdateMask
16:14:19 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
16:14:19 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:19 Dialog 0x800000 returned: 1
16:14:19 End Action ShowDialogsHlpr
16:14:19 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
16:14:19 Begin Action ShowDialogsHlpr: 0x1000000
16:14:19 Begin Action: DlgCollation
16:14:24 ShowDlgCollation returned: 1
16:14:24 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid =
0x409,SortId = 52,dwCompFlags = 0x30001
16:14:24 End Action DlgCollation
16:14:24 begin ShowDialogsUpdateMask
16:14:24 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
16:14:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:24 Dialog 0x1000000 returned: 1
16:14:24 End Action ShowDialogsHlpr
16:14:24 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
16:14:24 Begin Action ShowDialogsHlpr: 0x2000000
16:14:24 Begin Action: DlgNetwork
16:14:29 ShowDlgNetwork returned: 1
16:14:29 [DlgServerNetwork]
16:14:29 NetworkLibs = 255
16:14:29 TCPPort = 0
16:14:29 TCPPrxy = Default
16:14:29 NMPPipeName = \\.\pipe\MSSQL$INSTANCEC7\sql\query
16:14:29 Result = 1
16:14:29 End Action DlgNetwork
16:14:29 begin ShowDialogsUpdateMask
16:14:29 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
16:14:29 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:29 Dialog 0x2000000 returned: 1
16:14:29 End Action ShowDialogsHlpr
16:14:29 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
16:14:29 Begin Action ShowDialogsHlpr: 0x8000000
16:14:29 Begin Action: DialogShowSdStartCopy
16:14:30 End Action DialogShowSdStartCopy
16:14:30 begin ShowDialogsUpdateMask
16:14:30 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
16:14:30 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:30 Dialog 0x8000000 returned: 1
16:14:30 End Action ShowDialogsHlpr
16:14:30 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
16:14:30 Begin Action ShowDialogsHlpr: 0x10000000
16:14:30 Begin Action: DialogShowSdLicenseMode
16:14:34 ShowDlgLicense returned: 1
16:14:34 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 999
16:14:34 End Action DialogShowSdLicenseMode
16:14:34 Dialog 0x10000000 returned: 1
16:14:34 End Action ShowDialogsHlpr
16:14:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
16:14:34 End Action ShowDialogs
16:14:34 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log" -CtxAcct "<Removed>" -<Removed>
16:14:34 Process Exit Code: (0)
16:14:34 Begin Action : ClusterSetupHelper
16:14:34 Begin Action : CreateClustISSFiles
16:14:34 End Action : CreateClustISSFiles
16:14:34 Begin Action : ClusterWriteRemIni
16:14:34 End Action : ClusterWriteRemIni
16:14:34 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=3
Server.1=NPBSQL6
Server.2=NPBSQL7
Server.3=NPBSQL8
[Server.1]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL6
1.script=\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL6\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"
1.user=<Removed>
1.password=<Removed>
1.name=<Removed>
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL7
1.script=\\NPBSQL6\admin$\NPBSQL7_INSTANCEC7.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL7\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=<Removed>
1.password=095b2c9b3941a75cd961
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
[Server.3]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL8
1.script=\\NPBSQL6\admin$\NPBSQL8_INSTANCEC7.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL8\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=<Removed>
1.password=095b2c9b3941a75cd961
1.name=SQLSetup3
1.sqlsetup=Y
1.copyexe=cnvsvc3.exe
16:14:34 Setup is performing required operations on cluster nodes. This may
take a few minutes...
16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
16:16:41 Process Exit Code: (0)
16:16:41 Begin Action : GetRemsetupRetCode
16:16:41 Installation return status on NPBSQL6 : 0
16:16:41 Installation return status on NPBSQL7 : 0
16:16:41 Installation return status on NPBSQL8 : 0
16:16:41 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/18/05 16:14:34 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x78] created for execution.
CThread::Process [0x78]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe k=Nb
k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss -f2 "\\NPBSQL6\admin$\setup.log" -e
"stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"' (NPBSQL6) ...
CThread::Run thread [0x80] created for execution.
CThread::Process [0x80]
CThreadPool::RunUntilCompleteHlpr create thread, index=2
CThread::Run thread [0x84] created for execution.
CThread::Process [0x84]
CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=0
CThreadPool::RunUntilCompleteHlpr start thread [0x80],index=1
CThreadPool::RunUntilCompleteHlpr start thread [0x84],index=2
Script file copied to '\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss' successfully.
Script file copied to '\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss' successfully.
Installing remote service (NPBSQL8)...
Installing remote service (NPBSQL7)...
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss -f2 "\\NPBSQL8\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (NPBSQL8) ...
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss -f2 "\\NPBSQL7\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (NPBSQL7) ...
CRemoteProcess::RunUntilComplete [0x84] exit code: 0
Remote process exit code was '0' (NPBSQL8).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x84]
Thread [0x84] exit code: [0x0]
CRemoteProcess::RunUntilComplete [0x80] exit code: 0
Remote process exit code was '0' (NPBSQL7).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x80]
Thread [0x80] exit code: [0x0]
CProcess::RunUntilComplete [0x78] exit code: 0
Remote process exit code was '0' (NPBSQL6).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
Thread [0x78] exit code: [0x0]
CThreadPool::RunUntilComplete returned 0
CThreadPool::RunUntilComplete execution level=1, need execution: 0
Disconnecting from remote machine (NPBSQL6)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:07 ####
Disconnecting from remote machine (NPBSQL7)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:24 ####
Disconnecting from remote machine (NPBSQL8)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:41 ####
16:16:41 End Action : Run setup on cluster nodes
16:16:41 SetClusterSecuritySQL (<Removed>) and (<Removed>) returned: 0
16:16:41 Begin Action : CreateVirtualServerResources
16:16:49 End Action : CreateVirtualServerResources
16:16:49 CreateVirtualServerResources returned: 2
SQL Clusters sometimes don't like installing from a network share. Burn a
CD and physically place it in the node you are running install on.
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:22BF14DE-8ECE-48FD-BCF9-6D811C6F8277@.microsoft.com...
> Building an Active/Active/Passive SQL 2000 cluster on top of a 3 node 2003
> server cluster. As I go to install I end up getting a "An error occured
> while creating virtual server resources for clustering. The system cannot
> find the file specified."
> I've gone through KB 815431 and made sure the named piped alias is
> configured properly and it appears to be working correctly. Let me know
> if
> anyone has any ideas. Here's my sqlstp.log up to the point of the error.
> 16:12:58 Begin Setup
> 16:12:58 8.00.194
> 16:12:58 Mode = Normal
> 16:12:58 ModeType = NORMAL
> 16:12:58 GetDefinitionEx returned: 0, Extended: 0x0
> 16:12:58 ValueFTS returned: 1
> 16:12:58 ValuePID returned: 1
> 16:12:58 ValueLic returned: 1
> 16:12:58 System: Windows NT Enterprise Server
> 16:12:58 SQL Server ProductType: Enterprise Edition [0x3]
> 16:12:58 IsNTCluster returned: 1
> 16:12:58 Begin Action: SetupInitialize
> 16:12:58 End Action SetupInitialize
> 16:12:58 Begin Action: SetupInstall
> 16:12:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
> ...
> 16:12:58 CommonFilesDir=C:\Program Files\Common Files
> 16:12:58 Windows Directory=C:\WINDOWS\
> 16:12:58 Program Files=C:\Program Files\
> 16:12:58 TEMPDIR=C:\WINDOWS\TEMP\
> 16:12:58 Begin Action: SetupInstall
> 16:12:58 digpid size : 256
> 16:12:58 digpid size : 164
> 16:12:58 Begin Action: CheckFixedRequirements
> 16:12:58 Platform ID: 0xf00000
> 16:12:58 Version: 5.2.3790
> 16:12:58 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.279
> 16:12:58 End Action: CheckFixedRequirements
> 16:12:58 Begin Action: ShowDialogs
> 16:12:58 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 16:12:58 Begin Action ShowDialogsHlpr: 0x1
> 16:12:58 Begin Action: DialogShowSdWelcome
> 16:13:01 End Action DialogShowSdWelcome
> 16:13:01 Dialog 0x1 returned: 1
> 16:13:01 End Action ShowDialogsHlpr
> 16:13:01 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 16:13:01 Begin Action ShowDialogsHlpr: 0x2
> 16:13:01 Begin Action: DialogShowSdMachineName
> 16:13:15 ShowDlgMachine returned: 1
> 16:13:15 Name = NPBSQLC7, Type = 0x10000008
> 16:13:15 Begin Action: CheckRequirements
> 16:13:15 Processor Architecture: x86 (Pentium)
> 16:13:15 ComputerName: NPBSQL6
> 16:13:15 User Name: <Removed>
> 16:13:15 IsAllAccessAllowed returned: 1
> 16:13:15 OS Language: 0x409
> 16:13:15 End Action CheckRequirements
> 16:13:15 This combination of Package and Operating System allows a full
> product install.
> 16:13:15 End Action DialogShowSdMachineName
> 16:13:15 begin ShowDialogsUpdateMask
> 16:13:15 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
> 16:13:15 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
> 16:13:15 Dialog 0x2 returned: 0
> 16:13:15 End Action ShowDialogsHlpr
> 16:13:15 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 16:13:15 Begin Action ShowDialogsHlpr: 0x4
> 16:13:15 Begin Action: DialogShowSdInstallMode
> 16:13:15 InstallMode : 0x1
> 16:13:15 End Action DialogShowSdInstallMode
> 16:13:15 begin ShowDialogsUpdateMask
> 16:13:15 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
> 16:13:15 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:15 Dialog 0x4 returned: 1
> 16:13:15 End Action ShowDialogsHlpr
> 16:13:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 16:13:15 Begin Action ShowDialogsHlpr: 0x10
> 16:13:15 Begin Action: DialogShowSdRegisterUserEx
> 16:13:17 End Action DialogShowSdRegisterUserEx
> 16:13:17 begin ShowDialogsUpdateMask
> 16:13:17 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
> 16:13:17 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:17 Dialog 0x10 returned: 1
> 16:13:17 End Action ShowDialogsHlpr
> 16:13:17 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 16:13:17 Begin Action ShowDialogsHlpr: 0x20
> 16:13:17 Begin Action: DialogShowSdLicense
> 16:13:17 End Action DialogShowSdLicense
> 16:13:17 Dialog 0x20 returned: 1
> 16:13:17 End Action ShowDialogsHlpr
> 16:13:17 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
> 16:13:17 Begin Action ShowDialogsHlpr: 0x4000
> 16:13:17 Begin Action: DialogShowSdVirtualServer
> 16:13:27 ShowDlgVirtualServer returned: 0
> 16:13:27 Ipaddress = 10.10.0.58,255.255.252.0,SQL2 Public Team
> 16:13:27 szNewList = 10.10.0.58,255.255.252.0,SQL2 Public Team
> 16:13:27 szModifiedList =
> 16:13:27 szRemovedList =
> 16:13:27 End Action DialogShowSdVirtualServer
> 16:13:27 begin ShowDialogsUpdateMask
> 16:13:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
> 16:13:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:27 Dialog 0x4000 returned: 1
> 16:13:27 End Action ShowDialogsHlpr
> 16:13:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
> 16:13:27 Begin Action ShowDialogsHlpr: 0x8000
> 16:13:27 Begin Action : DialogShowSdDiskGroups
> 16:13:30 ShowDlgDiskGroups returned: 1
> 16:13:30 Disk Group = NPBSQLC7
> 16:13:30 End Action : DialogShowSdDiskGroups
> 16:13:30 begin ShowDialogsUpdateMask
> 16:13:30 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
> 16:13:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:30 Dialog 0x8000 returned: 1
> 16:13:30 End Action ShowDialogsHlpr
> 16:13:30 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
> 16:13:30 Begin Action ShowDialogsHlpr: 0x10000
> 16:13:30 Begin Action: DialogShowSdClusterDef
> 16:13:31 ShowDlgClusterDef returned: 1
> 16:13:31 PrefOwners = NPBSQL6,NPBSQL7,NPBSQL8, NumIp = 3
> 16:13:31 Begin Action : ValidateNodeActions
> 16:13:31 Begin Action : ValidateNodeActions
> 16:13:31 End Action : ValidateNodeActions
> 16:13:31 End Action : ValidateNodeActions
> 16:13:31 End Action DialogShowSdClusterDef
> 16:13:31 begin ShowDialogsUpdateMask
> 16:13:31 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
> 16:13:31 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:31 Dialog 0x10000 returned: 1
> 16:13:31 End Action ShowDialogsHlpr
> 16:13:31 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
> 16:13:31 Begin Action ShowDialogsHlpr: 0x20000
> 16:13:31 Begin Action : Cluster Security - DlgAcct
> 16:13:39 ShowDlgAcct returned: 1
> 16:13:39 [DlgAccount]
> 16:13:39 Domain = <Removed>
> 16:13:40 DomainAcct = <Removed>
> 16:13:40 DomainPwd
> 16:13:40 Result = 1
> 16:13:40 End Action : Cluster Security - DlgAcct
> 16:13:40 begin ShowDialogsUpdateMask
> 16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
> 16:13:40 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:40 Dialog 0x20000 returned: 1
> 16:13:40 End Action ShowDialogsHlpr
> 16:13:40 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 16:13:40 Begin Action ShowDialogsHlpr: 0x40000
> 16:13:40 Begin Action: DialogShowSdCliSvr
> 16:13:40 DisplaySystemPreReq
> 16:13:40 ShowDlgClientServerSelect returned: 1
> 16:13:40 Type : 0x2
> 16:13:40 End Action DialogShowSdCliSvr
> 16:13:40 begin ShowDialogsUpdateMask
> 16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
> 16:13:40 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:40 Dialog 0x40000 returned: 1
> 16:13:40 End Action ShowDialogsHlpr
> 16:13:40 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 16:13:40 Begin Action ShowDialogsHlpr: 0x80000
> 16:13:40 Begin Action: DialogShowSdInstanceName
> 16:13:40 Begin Action: ShowDlgInstanceName
> 16:13:46 End Action: ShowDlgInstanceName
> 16:13:46 ShowDlgInstanceName returned : 1
> 16:13:46 InstanceName : INSTANCEC7
> 16:13:46 End Action DialogShowSdInstanceName
> 16:13:46 begin ShowDialogsUpdateMask
> 16:13:46 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
> 16:13:46 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:46 Dialog 0x80000 returned: 1
> 16:13:46 End Action ShowDialogsHlpr
> 16:13:46 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
> 16:13:46 Begin Action ShowDialogsHlpr: 0x100000
> 16:13:46 Begin Action: DialogShowSdSetupType
> 16:13:46 Begin Action: Setup Type
> 16:13:50 [SetupTypeSQL]
> 16:13:50 szDir = C:\Program Files\Microsoft SQL Server
> 16:13:50 szDir = C:\Program Files\Microsoft SQL Server
> 16:13:50 Result = 303
> 16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
> 16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
> 16:13:50 End Action: Setup Type
> 16:13:50 Setup Type: Custom (303)
> 16:13:50 End Action DialogShowSdSetupType
> 16:13:50 begin ShowDialogsUpdateMask
> 16:13:50 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
> 16:13:50 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:50 Dialog 0x100000 returned: 303
> 16:13:50 End Action ShowDialogsHlpr
> 16:13:50 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
> 16:13:50 Begin Action ShowDialogsHlpr: 0x200000
> 16:13:50 Begin Action: DialogShowSdComponentMult
> 16:13:50 basesys = 0, baseinst = 0, basedata = 0
> 16:13:50 Begin Action: Component Handler
> 16:13:54 SQL program folder: C:\Program Files\Microsoft SQL
> Server\MSSQL$INSTANCEC7
> 16:13:54 SQL data folder: R:\Program Files\Microsoft SQL
> Server\MSSQL$INSTANCEC7
> 16:13:54 Windows system folder: C:\WINDOWS\system32\
> 16:13:54 Prog req: 22162, Data req: 34432, Sys req: 181286
> 16:13:54 Prog avail: 28555808, Data avail: 61083436, Sys avail: 28555808
> 16:13:54 Prog req vs. avail, 203448, 28555808
> 16:13:54 Data req vs. avail, 34432, 61083436
> 16:13:54 Sys req vs. avail, 181286, 28555808
> 16:13:54 DisplaySystemPreReq
> 16:13:54 [SQLComponentMult]
> 16:13:56 Component =
> 16:13:56 Result = 1
> 16:13:56 End Action: Component Handler
> 16:13:56 End Action DialogShowSdComponentMult
> 16:13:56 begin ShowDialogsUpdateMask
> 16:13:56 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
> 16:13:56 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:56 Dialog 0x200000 returned: 1
> 16:13:56 End Action ShowDialogsHlpr
> 16:13:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 16:13:56 Begin Action ShowDialogsHlpr: 0x400000
> 16:13:56 Begin Action: DlgServices
> 16:14:15 ShowDlgServices returned: 1
> 16:14:15 [DlgServices]
> 16:14:15 Local-Domain = 61680
> 16:14:15 AutoStart = 0
> 16:14:15 SQLDomain = <Removed>
> 16:14:15 SQLDomainAcct = <Removed>
> 16:14:15 SQLDomainPwd
> 16:14:15 AgtDomain = <Removed>
> 16:14:15 AgtDomainAcct = <Removed>
> 16:14:15 AgtDomainPwd
> 16:14:15 Result = 1
> 16:14:15 End Action DlgServices
> 16:14:15 begin ShowDialogsUpdateMask
> 16:14:15 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
> 16:14:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:15 Dialog 0x400000 returned: 1
> 16:14:15 End Action ShowDialogsHlpr
> 16:14:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 16:14:15 Begin Action ShowDialogsHlpr: 0x800000
> 16:14:15 Begin Action: DlgSQLSecurity
> 16:14:19 ShowDlgSQLSecurity returned: 1
> 16:14:19 LoginMode = 1,szPwd
> 16:14:19 End Action DlgSQLSecurity
> 16:14:19 begin ShowDialogsUpdateMask
> 16:14:19 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
> 16:14:19 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:19 Dialog 0x800000 returned: 1
> 16:14:19 End Action ShowDialogsHlpr
> 16:14:19 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 16:14:19 Begin Action ShowDialogsHlpr: 0x1000000
> 16:14:19 Begin Action: DlgCollation
> 16:14:24 ShowDlgCollation returned: 1
> 16:14:24 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid
> =
> 0x409,SortId = 52,dwCompFlags = 0x30001
> 16:14:24 End Action DlgCollation
> 16:14:24 begin ShowDialogsUpdateMask
> 16:14:24 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
> 16:14:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:24 Dialog 0x1000000 returned: 1
> 16:14:24 End Action ShowDialogsHlpr
> 16:14:24 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 16:14:24 Begin Action ShowDialogsHlpr: 0x2000000
> 16:14:24 Begin Action: DlgNetwork
> 16:14:29 ShowDlgNetwork returned: 1
> 16:14:29 [DlgServerNetwork]
> 16:14:29 NetworkLibs = 255
> 16:14:29 TCPPort = 0
> 16:14:29 TCPPrxy = Default
> 16:14:29 NMPPipeName = \\.\pipe\MSSQL$INSTANCEC7\sql\query
> 16:14:29 Result = 1
> 16:14:29 End Action DlgNetwork
> 16:14:29 begin ShowDialogsUpdateMask
> 16:14:29 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
> 16:14:29 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:29 Dialog 0x2000000 returned: 1
> 16:14:29 End Action ShowDialogsHlpr
> 16:14:29 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 16:14:29 Begin Action ShowDialogsHlpr: 0x8000000
> 16:14:29 Begin Action: DialogShowSdStartCopy
> 16:14:30 End Action DialogShowSdStartCopy
> 16:14:30 begin ShowDialogsUpdateMask
> 16:14:30 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
> 16:14:30 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:30 Dialog 0x8000000 returned: 1
> 16:14:30 End Action ShowDialogsHlpr
> 16:14:30 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
> 16:14:30 Begin Action ShowDialogsHlpr: 0x10000000
> 16:14:30 Begin Action: DialogShowSdLicenseMode
> 16:14:34 ShowDlgLicense returned: 1
> 16:14:34 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 999
> 16:14:34 End Action DialogShowSdLicenseMode
> 16:14:34 Dialog 0x10000000 returned: 1
> 16:14:34 End Action ShowDialogsHlpr
> 16:14:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 16:14:34 End Action ShowDialogs
> 16:14:34 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\Other\dtcsetup.exe" -LogFile
> "C:\WINDOWS\sqlstp.log" -CtxAcct "<Removed>" -<Removed>
> 16:14:34 Process Exit Code: (0)
> 16:14:34 Begin Action : ClusterSetupHelper
> 16:14:34 Begin Action : CreateClustISSFiles
> 16:14:34 End Action : CreateClustISSFiles
> 16:14:34 Begin Action : ClusterWriteRemIni
> 16:14:34 End Action : ClusterWriteRemIni
> 16:14:34 Begin Action : Run setup on cluster nodes
> [args]
> NumRemoteServers=3
> Server.1=NPBSQL6
> Server.2=NPBSQL7
> Server.3=NPBSQL8
> [Server.1]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL6
> 1.script=\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss
> 1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL6\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"
> 1.user=<Removed>
> 1.password=<Removed>
> 1.name=<Removed>
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc1.exe
> [Server.2]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL7
> 1.script=\\NPBSQL6\admin$\NPBSQL7_INSTANCEC7.iss
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL7\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=<Removed>
> 1.password=095b2c9b3941a75cd961
> 1.name=SQLSetup2
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc2.exe
> [Server.3]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL8
> 1.script=\\NPBSQL6\admin$\NPBSQL8_INSTANCEC7.iss
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL8\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=<Removed>
> 1.password=095b2c9b3941a75cd961
> 1.name=SQLSetup3
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc3.exe
> 16:14:34 Setup is performing required operations on cluster nodes. This
> may
> take a few minutes...
> 16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
> C:\WINDOWS\remsetup.ini
> 16:16:41 Process Exit Code: (0)
> 16:16:41 Begin Action : GetRemsetupRetCode
> 16:16:41 Installation return status on NPBSQL6 : 0
> 16:16:41 Installation return status on NPBSQL7 : 0
> 16:16:41 Installation return status on NPBSQL8 : 0
> 16:16:41 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 05/18/05 16:14:34 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x78] created for execution.
> CThread::Process [0x78]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe k=Nb
> k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss -f2
> "\\NPBSQL6\admin$\setup.log" -e
> "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"' (NPBSQL6) ...
> CThread::Run thread [0x80] created for execution.
> CThread::Process [0x80]
> CThreadPool::RunUntilCompleteHlpr create thread, index=2
> CThread::Run thread [0x84] created for execution.
> CThread::Process [0x84]
> CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=0
> CThreadPool::RunUntilCompleteHlpr start thread [0x80],index=1
> CThreadPool::RunUntilCompleteHlpr start thread [0x84],index=2
> Script file copied to '\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss'
> successfully.
> Script file copied to '\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss'
> successfully.
> Installing remote service (NPBSQL8)...
> Installing remote service (NPBSQL7)...
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss -f2
> "\\NPBSQL8\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (NPBSQL8) ...
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss -f2
> "\\NPBSQL7\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (NPBSQL7) ...
> CRemoteProcess::RunUntilComplete [0x84] exit code: 0
> Remote process exit code was '0' (NPBSQL8).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x84]
> Thread [0x84] exit code: [0x0]
> CRemoteProcess::RunUntilComplete [0x80] exit code: 0
> Remote process exit code was '0' (NPBSQL7).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x80]
> Thread [0x80] exit code: [0x0]
> CProcess::RunUntilComplete [0x78] exit code: 0
> Remote process exit code was '0' (NPBSQL6).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
> Thread [0x78] exit code: [0x0]
> CThreadPool::RunUntilComplete returned 0
> CThreadPool::RunUntilComplete execution level=1, need execution: 0
> Disconnecting from remote machine (NPBSQL6)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:07 ####
> Disconnecting from remote machine (NPBSQL7)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:24 ####
> Disconnecting from remote machine (NPBSQL8)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:41 ####
>
> 16:16:41 End Action : Run setup on cluster nodes
> 16:16:41 SetClusterSecuritySQL (<Removed>) and (<Removed>) returned: 0
> 16:16:41 Begin Action : CreateVirtualServerResources
> 16:16:49 End Action : CreateVirtualServerResources
> 16:16:49 CreateVirtualServerResources returned: 2
>
>
|||Thanks for the quick reply. I did try copying the install folder over
locally and ended up with the same error message.
"Geoff N. Hiten" wrote:
> SQL Clusters sometimes don't like installing from a network share. Burn a
> CD and physically place it in the node you are running install on.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:22BF14DE-8ECE-48FD-BCF9-6D811C6F8277@.microsoft.com...
>
>
|||Make sure both the SQL Service account and the install account are domain
accounts with administrators group membership on all nodes. Check the TMP
and TEMP system variable paths on all nodes. Log in to each server with
each account at least once before installing.
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...[vbcol=seagreen]
> Thanks for the quick reply. I did try copying the install folder over
> locally and ended up with the same error message.
> "Geoff N. Hiten" wrote:
|||Thansk again for the response!
I have logged onto each machine previous with the install account. As for
the accounts. The install account I'm using is the Domain Admin account, so
that should be alright. Also, the network accounts I'm using for both the
SQLService and the Cluster service are in the node's Local Admins group.
On all the nodes the TEMP and TMP variables for the Install account is
listed as %USERPROFILE%\Local Settings\Temp. For the system it's
%SystemRoot%\TEMP
I changed them all to %SystemRoot%\TEMP (Replaced %systemroot% with the
actual path name as well.)
Still got the error message right after it tries to create the cluster
resources.
Now previously I had an install of SQL installed on these nodes that were
SP'd up to 3a. Could that be causing any of the issues?
"Geoff N. Hiten" wrote:
> Make sure both the SQL Service account and the install account are domain
> accounts with administrators group membership on all nodes. Check the TMP
> and TEMP system variable paths on all nodes. Log in to each server with
> each account at least once before installing.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...
>
>
|||Hmm, I'm wondering if it does have something to do with some SP3a files stuck
on that local machine. I attempted to install it to just a single node as
per http://support.microsoft.com/default...b;en-us;318672 and still
got the same error.
Not sure how I can dig out any files, at this point a full re-install may be
in order.
"Geoff N. Hiten" wrote:
> Make sure both the SQL Service account and the install account are domain
> accounts with administrators group membership on all nodes. Check the TMP
> and TEMP system variable paths on all nodes. Log in to each server with
> each account at least once before installing.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...
>
>
|||An old install with incomplete removal might cause some issues.
This article will help remove any trace of the old SQL installation:
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default...b;en-us;290991
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:E981A9F3-B54A-4D0A-AEEC-AA218EA2E717@.microsoft.com...[vbcol=seagreen]
> Thansk again for the response!
> I have logged onto each machine previous with the install account. As for
> the accounts. The install account I'm using is the Domain Admin account,
> so
> that should be alright. Also, the network accounts I'm using for both the
> SQLService and the Cluster service are in the node's Local Admins group.
> On all the nodes the TEMP and TMP variables for the Install account is
> listed as %USERPROFILE%\Local Settings\Temp. For the system it's
> %SystemRoot%\TEMP
> I changed them all to %SystemRoot%\TEMP (Replaced %systemroot% with the
> actual path name as well.)
> Still got the error message right after it tries to create the cluster
> resources.
> Now previously I had an install of SQL installed on these nodes that were
> SP'd up to 3a. Could that be causing any of the issues?
> "Geoff N. Hiten" wrote:
|||One other thing I once ran into:
Check C:\Documents and Settings
Maybe on one node you logged on locally before, and the other not. You might
have differences. e.g.:
Node A
Administrator
Administrator.domain
Node B
Administrator
The profile-directory for the account you are using has to be the same on
both nodes. It's kind of tricky ...
Chau chau,
Pascalos
"Chris" wrote:
[vbcol=seagreen]
> Hmm, I'm wondering if it does have something to do with some SP3a files stuck
> on that local machine. I attempted to install it to just a single node as
> per http://support.microsoft.com/default...b;en-us;318672 and still
> got the same error.
> Not sure how I can dig out any files, at this point a full re-install may be
> in order.
> "Geoff N. Hiten" wrote:
No comments:
Post a Comment