August 1, 2006 at 7:48 am
I am attempting to set up SQL2K EE on Win2003 cluster
(active/passive).
I get this error msg "Setup failed to perform required
operations on the cluster nodes." during the install
process. I have looked through the newsgroups and
knowledge base for info on this error and have seen some
replies/articles however none of them seem to fix our
issue.
I have attached the sqlstp.log and sqlstp0.logs (from 1st
node). The only issues I could see in sqlstp.log are
listed below. As far as I could tell the install on the
2nd node when ok. No errors in its log.
I've verified the user id I'm using to run SQL Server services
is a member of the Administrators group on all nodes of the cluster
- I've copied the software onto the local drive of the primary node and shared it out
- 've created a separate resource group for the MS-DTC in cluster administrator
I'm out of ideas guys
-----------------------------------SQLSTP.LOG---------------------------
09:23:40 Begin Setup
09:23:40 8.00.194
09:23:40 Mode = Normal
09:23:40 ModeType = NORMAL
09:23:40 GetDefinitionEx returned: 0, Extended: 0x0
09:23:40 ValueFTS returned: 1
09:23:40 ValuePID returned: 1
09:23:40 ValueLic returned: 1
09:23:40 System: Windows NT Enterprise Server
09:23:40 SQL Server ProductType: Enterprise Edition [0x3]
09:23:40 IsNTCluster returned: 1
09:23:40 Begin Action: SetupInitialize
09:23:40 End Action SetupInitialize
09:23:40 Begin Action: SetupInstall
09:23:40 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
09:23:40 CommonFilesDir=C:\Program Files\Common Files
09:23:40 Windows Directory=C:\Documents and Settings\cluster_admin\WINDOWS\
09:23:40 Program Files=C:\Program Files\
09:23:40 TEMPDIR=C:\DOCUME~1\CLUSTE~1\LOCALS~1\Temp\2\
09:23:40 Begin Action: SetupInstall
09:23:40 Begin Action: CheckFixedRequirements
09:23:40 Platform ID: 0xf00000
09:23:40 Version: 5.2.3790
09:23:40 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2712
09:23:40 End Action: CheckFixedRequirements
09:23:43 Begin Action: ShowDialogs
09:23:43 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
09:23:43 Begin Action ShowDialogsHlpr: 0x1
09:23:43 Begin Action: DialogShowSdWelcome
09:23:46 End Action DialogShowSdWelcome
09:23:46 Dialog 0x1 returned: 1
09:23:46 End Action ShowDialogsHlpr
09:23:46 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
09:23:46 Begin Action ShowDialogsHlpr: 0x2
09:23:46 Begin Action: DialogShowSdMachineName
09:24:03 ShowDlgMachine returned: 1
09:24:03 Name = SQLNODE1, Type = 0x10000008
09:24:03 Begin Action: CheckRequirements
09:24:03 Processor Architecture: x86 (Pentium)
09:24:03 Service Pack: 256
09:24:03 ComputerName: ZGA114A479R4451
09:24:03 User Name: cluster_admin
09:24:03 IsAllAccessAllowed returned: 1
09:24:03 OS Language: 0x409
09:24:03 End Action CheckRequirements
09:24:03 This combination of Package and Operating System allows a full product install.
09:24:03 End Action DialogShowSdMachineName
09:24:03 begin ShowDialogsUpdateMask
09:24:03 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
09:24:03 Updated Dialog Mask: 0xbf3c0f7, Disable Back = 0x1
09:24:03 Dialog 0x2 returned: 0
09:24:03 End Action ShowDialogsHlpr
09:24:03 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
09:24:03 Begin Action ShowDialogsHlpr: 0x4
09:24:03 Begin Action: DialogShowSdInstallMode
09:24:03 InstallMode : 0x1
09:24:03 End Action DialogShowSdInstallMode
09:24:03 begin ShowDialogsUpdateMask
09:24:03 nFullMask = 0xbf3c0f7, nCurrent = 0x4, nDirection = 1
09:24:03 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:24:03 Dialog 0x4 returned: 1
09:24:03 End Action ShowDialogsHlpr
09:24:03 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
09:24:03 Begin Action ShowDialogsHlpr: 0x10
09:24:03 Begin Action: DialogShowSdRegisterUserEx
09:24:04 End Action DialogShowSdRegisterUserEx
09:24:04 begin ShowDialogsUpdateMask
09:24:04 nFullMask = 0x1bf7c0f7, nCurrent = 0x10, nDirection = 1
09:24:04 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:24:04 Dialog 0x10 returned: 1
09:24:04 End Action ShowDialogsHlpr
09:24:04 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
09:24:04 Begin Action ShowDialogsHlpr: 0x20
09:24:04 Begin Action: DialogShowSdLicense
09:24:05 End Action DialogShowSdLicense
09:24:05 Dialog 0x20 returned: 1
09:24:05 End Action ShowDialogsHlpr
09:24:05 ShowDialogsGetDialog returned: nCurrent=0x40,index=6
09:24:05 Begin Action ShowDialogsHlpr: 0x40
09:24:05 Begin Action: DialogShowSdCDKey
09:24:05 digpid size : 256
09:24:50 ShowDlgCDKeyreturned: 1
09:24:50 digpid size : 164
09:24:50 CDKey = GD4M4-G6KGD-DT7X9-QQJJ4-KHRPB, 20 digit Product ID = 53934-400-5918203-05381
09:24:50 End Action DialogShowSdCDKey
09:24:50 begin ShowDialogsUpdateMask
09:24:50 nFullMask = 0x1bf7c0f7, nCurrent = 0x40, nDirection = 1
09:24:50 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:24:50 Dialog 0x40 returned: 1
09:24:50 End Action ShowDialogsHlpr
09:24:50 ShowDialogsGetDialog returned: nCurrent=0x80,index=7
09:24:50 Begin Action ShowDialogsHlpr: 0x80
09:24:50 Dialog 0x80 returned: 1
09:24:50 End Action ShowDialogsHlpr
09:24:50 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
09:24:50 Begin Action ShowDialogsHlpr: 0x4000
09:24:50 Begin Action: DialogShowSdVirtualServer
09:25:09 ShowDlgVirtualServer returned: 0
09:25:09 Ipaddress = 55.179.128.123,255.255.255.0,Local Area Connection
09:25:09 szNewList = 55.179.128.123,255.255.255.0,Local Area Connection
09:25:09 szModifiedList =
09:25:09 szRemovedList =
09:25:09 End Action DialogShowSdVirtualServer
09:25:09 begin ShowDialogsUpdateMask
09:25:09 nFullMask = 0x1bf7c0f7, nCurrent = 0x4000, nDirection = 1
09:25:09 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:25:09 Dialog 0x4000 returned: 1
09:25:09 End Action ShowDialogsHlpr
09:25:09 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
09:25:09 Begin Action ShowDialogsHlpr: 0x8000
09:25:09 Begin Action : DialogShowSdDiskGroups
09:25:17 ShowDlgDiskGroups returned: 1
09:25:17 Disk Group = SQLNODE1
09:25:17 End Action : DialogShowSdDiskGroups
09:25:17 begin ShowDialogsUpdateMask
09:25:17 nFullMask = 0x1bf7c0f7, nCurrent = 0x8000, nDirection = 1
09:25:17 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:25:17 Dialog 0x8000 returned: 1
09:25:17 End Action ShowDialogsHlpr
09:25:17 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
09:25:17 Begin Action ShowDialogsHlpr: 0x10000
09:25:17 Begin Action: DialogShowSdClusterDef
09:25:19 ShowDlgClusterDef returned: 1
09:25:19 PrefOwners = ZGA114A479R4451,ZGA114A4J9N4451, NumIp = 2
09:25:19 Begin Action : ValidateNodeActions
09:25:19 Begin Action : ValidateNodeActions
09:25:19 End Action : ValidateNodeActions
09:25:19 End Action : ValidateNodeActions
09:25:19 End Action DialogShowSdClusterDef
09:25:19 begin ShowDialogsUpdateMask
09:25:19 nFullMask = 0x1bf7c0f7, nCurrent = 0x10000, nDirection = 1
09:25:19 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:25:19 Dialog 0x10000 returned: 1
09:25:19 End Action ShowDialogsHlpr
09:25:19 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
09:25:19 Begin Action ShowDialogsHlpr: 0x20000
09:25:19 Begin Action : Cluster Security - DlgAcct
09:25:26 ShowDlgAcct returned: 1
09:25:26 [DlgAccount]
09:25:26 Domain = AR
09:25:26 DomainAcct = cluster_admin
09:25:26 DomainPwd
09:25:26 Result = 1
09:25:26 End Action : Cluster Security - DlgAcct
09:25:26 begin ShowDialogsUpdateMask
09:25:26 nFullMask = 0x1bf7c0f7, nCurrent = 0x20000, nDirection = 1
09:25:26 Updated Dialog Mask: 0x1bf7c0f7, Disable Back = 0x1
09:25:26 Dialog 0x20000 returned: 1
09:25:26 End Action ShowDialogsHlpr
09:25:26 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
09:25:26 Begin Action ShowDialogsHlpr: 0x40000
09:25:26 Begin Action: DialogShowSdCliSvr
09:25:26 DisplaySystemPreReq
09:25:26 ShowDlgClientServerSelect returned: 1
09:25:26 Type : 0x2
09:25:26 End Action DialogShowSdCliSvr
09:25:26 begin ShowDialogsUpdateMask
09:25:26 nFullMask = 0x1bf7c0f7, nCurrent = 0x40000, nDirection = 1
09:25:26 Updated Dialog Mask: 0x1bffc0f7, Disable Back = 0x1
09:25:26 Dialog 0x40000 returned: 1
09:25:26 End Action ShowDialogsHlpr
09:25:26 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
09:25:26 Begin Action ShowDialogsHlpr: 0x80000
09:25:26 Begin Action: DialogShowSdInstanceName
09:25:26 Begin Action: ShowDlgInstanceName
09:25:37 End Action: ShowDlgInstanceName
09:25:37 ShowDlgInstanceName returned : 1
09:25:37 InstanceName : SQLNODE1
09:25:37 End Action DialogShowSdInstanceName
09:25:37 begin ShowDialogsUpdateMask
09:25:37 nFullMask = 0x1bffc0f7, nCurrent = 0x80000, nDirection = 1
09:25:37 Updated Dialog Mask: 0x1bffc0f7, Disable Back = 0x1
09:25:37 Dialog 0x80000 returned: 1
09:25:37 End Action ShowDialogsHlpr
09:25:37 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
09:25:37 Begin Action ShowDialogsHlpr: 0x100000
09:25:37 Begin Action: DialogShowSdSetupType
09:25:37 Begin Action: Setup Type
09:25:42 SQL program folder: C:\Program Files\Microsoft SQL Server
09:25:42 SQL data folder: T:\Program Files\Microsoft SQL Server
09:25:42 Windows system folder: C:\WINDOWS\system32\
09:25:42 Prog req: 34789, Data req: 34432, Sys req: 181308
09:25:42 Prog avail: 35791595, Data avail: 35283904, Sys avail: 35791595
09:25:42 Prog req vs. avail, 216097, 35791595
09:25:42 Data req vs. avail, 34432, 35283904
09:25:42 Sys req vs. avail, 181308, 35791595
09:25:42 DisplaySystemPreReq
09:25:42 [SetupTypeSQL]
09:25:42 szDir = C:\Program Files\Microsoft SQL Server
09:25:42 szDir = C:\Program Files\Microsoft SQL Server
09:25:42 Result = 301
09:25:42 szDataDir = T:\Program Files\Microsoft SQL Server
09:25:42 szDataDir = T:\Program Files\Microsoft SQL Server
09:25:42 End Action: Setup Type
09:25:42 Setup Type: Typical (301)
09:25:42 End Action DialogShowSdSetupType
09:25:42 begin ShowDialogsUpdateMask
09:25:42 nFullMask = 0x1bffc0f7, nCurrent = 0x100000, nDirection = 301
09:25:42 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:42 Dialog 0x100000 returned: 301
09:25:42 End Action ShowDialogsHlpr
09:25:42 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
09:25:42 Begin Action ShowDialogsHlpr: 0x400000
09:25:42 Begin Action: DlgServices
09:25:48 ShowDlgServices returned: 1
09:25:48 [DlgServices]
09:25:48 Local-Domain = 61680
09:25:48 AutoStart = 0
09:25:48 SQLDomain = AR
09:25:48 SQLDomainAcct = cluster_admin
09:25:48 SQLDomainPwd
09:25:48 AgtDomain = AR
09:25:48 AgtDomainAcct = cluster_admin
09:25:48 AgtDomainPwd
09:25:48 Result = 1
09:25:48 End Action DlgServices
09:25:48 begin ShowDialogsUpdateMask
09:25:48 nFullMask = 0x1bdfc0f7, nCurrent = 0x400000, nDirection = 1
09:25:48 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:48 Dialog 0x400000 returned: 1
09:25:48 End Action ShowDialogsHlpr
09:25:48 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
09:25:48 Begin Action ShowDialogsHlpr: 0x800000
09:25:48 Begin Action: DlgSQLSecurity
09:25:54 ShowDlgSQLSecurity returned: 1
09:25:54 LoginMode = 2,szPwd
09:25:54 End Action DlgSQLSecurity
09:25:54 begin ShowDialogsUpdateMask
09:25:54 nFullMask = 0x1bdfc0f7, nCurrent = 0x800000, nDirection = 1
09:25:54 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:54 Dialog 0x800000 returned: 1
09:25:54 End Action ShowDialogsHlpr
09:25:54 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
09:25:54 Begin Action ShowDialogsHlpr: 0x1000000
09:25:54 Begin Action: DlgCollation
09:25:54 ShowDlgCollation returned: 1
09:25:54 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags = 0x30001
09:25:54 End Action DlgCollation
09:25:54 begin ShowDialogsUpdateMask
09:25:54 nFullMask = 0x1bdfc0f7, nCurrent = 0x1000000, nDirection = 1
09:25:55 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:55 Dialog 0x1000000 returned: 1
09:25:55 End Action ShowDialogsHlpr
09:25:55 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
09:25:55 Begin Action ShowDialogsHlpr: 0x2000000
09:25:55 Begin Action: DlgNetwork
09:25:55 ShowDlgNetwork returned: 1
09:25:55 [DlgServerNetwork]
09:25:55 NetworkLibs = 255
09:25:55 TCPPort = 0
09:25:55 TCPPrxy = Default
09:25:55 NMPPipeName = \\.\pipe\MSSQL$SQLNODE1\sql\query
09:25:55 Result = 1
09:25:55 End Action DlgNetwork
09:25:55 begin ShowDialogsUpdateMask
09:25:55 nFullMask = 0x1bdfc0f7, nCurrent = 0x2000000, nDirection = 1
09:25:55 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:55 Dialog 0x2000000 returned: 1
09:25:55 End Action ShowDialogsHlpr
09:25:55 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
09:25:55 Begin Action ShowDialogsHlpr: 0x8000000
09:25:55 Begin Action: DialogShowSdStartCopy
09:25:56 End Action DialogShowSdStartCopy
09:25:56 begin ShowDialogsUpdateMask
09:25:56 nFullMask = 0x1bdfc0f7, nCurrent = 0x8000000, nDirection = 1
09:25:56 Updated Dialog Mask: 0x1bdfc0f7, Disable Back = 0x1
09:25:56 Dialog 0x8000000 returned: 1
09:25:56 End Action ShowDialogsHlpr
09:25:56 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
09:25:56 Begin Action ShowDialogsHlpr: 0x10000000
09:25:56 Begin Action: DialogShowSdLicenseMode
09:25:57 ShowDlgLicense returned: 1
09:25:57 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 100
09:25:57 End Action DialogShowSdLicenseMode
09:25:57 Dialog 0x10000000 returned: 1
09:25:57 End Action ShowDialogsHlpr
09:25:57 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
09:25:57 End Action ShowDialogs
09:25:58 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
09:25:58 C:\DOCUME~1\CLUSTE~1\LOCALS~1\Temp\2\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\DOCUME~1\CLUSTE~1\LOCALS~1\Temp\2\SqlSetup\Bin" -DTCPkg "D:\SQL200~3\x86\Other\dtcsetup.exe" -LogFile "C:\Documents and Settings\cluster_admin\WINDOWS\sqlstp.log" -CtxAcct "AR\cluster_admin" -CtxEPwd
09:26:00 Process Exit Code: (0)
09:26:00 Begin Action : ClusterSetupHelper
09:26:00 Begin Action : CreateClustISSFiles
09:26:00 End Action : CreateClustISSFiles
09:26:00 Begin Action : ClusterWriteRemIni
09:26:00 End Action : ClusterWriteRemIni
09:26:00 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=2
Server.1=ZGA114A479R4451
Server.2=ZGA114A4J9N4451
[Server.1]
NumRemoteServices=1
1.app=\\ZGA114A479R4451\D$\SQL200~3\x86\setup\setupsql.exe
1.server=ZGA114A479R4451
1.script=\\ZGA114A479R4451\admin$\ZGA114A479R4451_SQLNODE1.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\ZGA114A479R4451\D$\SQL200~3\x86\setup\setup.ins" -f1 %s -f2 "\\ZGA114A479R4451\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\DOCUME~1\CLUSTE~1\LOCALS~1\Temp\2\"
1.user=AR\cluster_admin
1.password=105541f34797a887e5c844
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app=\\ZGA114A479R4451\D$\SQL200~3\x86\setup\setupsql.exe
1.server=ZGA114A4J9N4451
1.script=\\ZGA114A479R4451\admin$\ZGA114A4J9N4451_SQLNODE1.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\ZGA114A479R4451\D$\SQL200~3\x86\setup\setup.ins" -f1 %s -f2 "\\ZGA114A4J9N4451\admin$\setup.log" -e "stpsilnt._ex" -x "C:\Documents and Settings\cluster_admin\"
1.user=AR\cluster_admin
1.password=105541f34797a887e5c844
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
09:26:00 Setup is performing required operations on cluster nodes. This may take a few minutes...
09:26:00 C:\DOCUME~1\CLUSTE~1\LOCALS~1\Temp\2\SqlSetup\Bin\remsetup.exe C:\Documents and Settings\cluster_admin\WINDOWS\remsetup.ini
09:26:00 Process Exit Code: (-1)
09:26:00 Begin Action : GetRemsetupRetCode
09:26:00 Installation return status on ZGA114A479R4451 : -1
09:26:00 Installation return status on ZGA114A4J9N4451 : -1
09:26:00 End Action : GetRemsetupRetCode
09:26:00 End Action : Run setup on cluster nodes
09:26:00 One or more errors occurred while running remote setup on the clustered machines.
09:26:05 Setup failed to perform required operations on the cluster nodes.
09:26:05 Begin Action : ClusterErrorCleanup
09:26:05 End Action : ClusterErrorCleanup
09:26:05 End Action : ClusterSetupHelper
Any help would be greatly appreciated.
August 2, 2006 at 8:54 am
Ted,
Do you have Terminal Services installed on your cluster? SQL won't work on a cluster that has that component installed. Remote Administration is fine, but not terminal services.
See http://support.microsoft.com/kb/301520/
hth jg
August 2, 2006 at 10:33 am
I've seen this type of failure a couple fo times. Both were related to the AD account used in the cluster installation. In your case chedk out cluster_admin in AD. It should be allowed 'interactive login' to both nodes of the cluster. Additionally cluster_admin should be in the LocalAdmins group on each node as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 2, 2006 at 11:01 am
have you run cliconfg and created named pipes aliases on BOTH nodes of your cluster? There's a KB article on this, but I can't remember it offhand.
w2k3 disables named pipes by default, and without the aliases, SQL enterprise edition install will fail with the error you're seeing.
run cliconfg
click alias tab
click add button
make sure named pipes is selected and put your virtual servername\instancename in the server alias box. the others should autopopulate from that.
Remember to remove the alias after the install / sp installations.
If this still fails:
best alternative is to install on Node A as a stand alone (AKA LONE WOLF cluster node... NOT a local instance) and then later install on Node B adding B into A.
August 30, 2006 at 5:39 am
hi, i've run into the same problem and after some days of setting up nodes, stopping/starting services and following instructions in similar posts worked one thing - not installing from the primary node (as stated probably in every step-by-step guide) but instead from the mscs virtual server - in five minutes is your sql cluster up and running 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply