March 30, 2004 at 6:59 am
Does any one know how to install SP3a on a SQL Server 2000 cluster.
I have read the readme but nothing special there but the installation kept failing, with the error that the operation can not be performed on the nodes.
Thanks
March 30, 2004 at 8:04 am
Here's what I did....
Make sure that the account you are logging into the machines as is an Admin on both boxes and the cluster so that it can access all resources.
Fail both nodes over to a single box (assuming active/active).
Install the service pack.
Reboot.
I've not experienced any problems related to this.
March 30, 2004 at 11:55 am
If you are installing from a network share make sure the NT account running the SQL Server service has read permissions to that share. SQL EE SP3 on a cluster is different since part of it runs unattended, and it will run in its default security context.
March 30, 2004 at 12:36 pm
Can you post the last few lines (20 or so) of the sqlsp.log file? You'll find it in %SYSTEMROOT% on the system you attempted the install from. Make sure you sanitize the entries so you don't reveal anything sensitive about your environment.
K. Brian Kelley
@kbriankelley
April 3, 2004 at 10:52 am
These are the last few lines of the sqlsp.log. The installaton is still failing with the same error.
Installing remote service ()...
CRemoteProcess::RunUntilComplete [0x8c] error code: 53
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 53
CThreadPool::RunUntilCompleteHlpr signaled thread [0x8c]
Thread [0x8c] exit code: [0x35]
CThreadPool::RunUntilComplete returned 53
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine ()...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 04/03/04 17:20:48 ####
Disconnecting from remote machine ( )...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 04/03/04 17:21:05 ####
17:21:06 End Action : Run setup on cluster nodes
17:21:06 One or more errors occurred while running remote setup on the clustered machines.
18:35:05 Setup failed to perform required operations on the cluster nodes.
18:35:05 End Action : ClusterSetupHelper
18:35:05 Begin Action : LogEvent
18:35:05 End Action : LogEvent
18:35:05 Begin Action : CloseEventLog
18:35:05 End Action : CloseEventLog
Thanks
April 3, 2004 at 11:01 am
Is there a sqlsp.log on the other node? If so, does it show an error in the last few lines?
K. Brian Kelley
@kbriankelley
April 4, 2004 at 10:42 am
Yes. The listing of what is on sqlsp.log on the second note is reproduced belwo. Thanks.
======================================
16:39:58 Begin Setup
16:39:58 Version on Media: 8.00.760
16:39:58 Mode = Normal
16:39:58 ModeType = NORMAL
16:39:58 Begin: SetupInitialize()
16:39:58 End: SetupInitialize()
16:39:58 Begin: CheckFixedRequirements()
16:39:58 Platform ID: 0xf00000
16:39:58 Version: 5.0.2195
16:39:58 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1400
16:39:58 End: CheckFixedRequirements()
16:39:58 Begin Action: CheckRequirements
16:39:58 Processor Architecture: x86 (Pentium)
16:39:58 Service Pack: 1024
16:39:58 ComputerName:
16:39:58 User Name:
16:39:59 IsAllAccessAllowed returned: 1
16:39:59 OS Language: 0x809
16:39:59 End Action CheckRequirements
16:39:59 CreateSetupTopology(), Handle : 0x18f4130, returned : 0
16:39:59 CreateSetupTopology returned : 0, Handle : 0x18f4130
16:39:59 Topology Type : 1, Return Value : 0
16:39:59 ST_GetPhysicalNode returned : 0, PNHandle : 0x18f4180
16:39:59 PN_EnumerateEx returned : 0
16:39:59 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
16:39:59 PN_StartScan [0x18f4180] returned : 0
16:39:59 PN_GetNext [0x18f4180] returned : 0, Handle: [0x18f4720]
16:39:59 SQLI_GetPackageId [0x18f4720] returned : 0, PackageId = 0x3
16:39:59 SQLI_GetVersion [0x18f4720] returned : 0, Version = 8.00.194
16:39:59 PN_GetNext [0x18f4180] returned : 18, Handle: [0x0]
16:39:59 ReleaseSetupTopology
16:39:59 This combination of Package and Operating System allows a full product install.
16:39:59 Begin: SetupInstall()
16:39:59 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
16:39:59 CommonFilesDir=C:\Program Files\Common Files
16:39:59 Windows Directory=C:\WINNT
16:39:59 Program Files=C:\Program Files
16:39:59 TEMPDIR=C:\DOCUME~1\LOCALS~1\Temp
16:39:59 End: SetupInstall()
16:39:59 Begin: ShowDialogs()
16:39:59 Initial Dialog Mask: 0x8300037, Disable Back=0x1
16:39:59 Begin Action ShowDialogsHlpr: 0x1
16:39:59 Begin Action: DialogShowSdWelcome
16:40:03 End Action DialogShowSdWelcome
16:40:03 Dialog 0x1 returned: 1
16:40:03 End Action ShowDialogsHlpr
16:40:03 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:40:03 Begin Action ShowDialogsHlpr: 0x2
16:40:03 Begin Action: DialogShowSdMachineName
16:40:04 ShowDlgMachine returned: -1
16:40:04 ShowDlgMachine: GetLastError returned: 50071
16:40:05 End Action DialogShowSdMachineName
16:40:05 End: ShowDialogs()
16:40:05 Action CleanUpInstall:
16:40:05 Installation Failed.
======================================
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply