Re: Unable to install SQL 2000 sp4 on Windows 2003 Cluster

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It sounds like the SP install is starting normally. It drops the resources
offline to update the binaries, then it brings them back online to update
the database internals via scripts. The .iss file is the installshield
driver file and is normal. I am surprised that there is no error log on the
remote server. That means the install never even started over there.

Here is a somewhat generic checklist:
Make sure the task scheduleer service is running on the remote node.
Make sure the install account is a domain account with local admin
membership on both servers.
If you are using AWE memory, reduce the memory footprint <2GB to decrease
startup time. Set it back when you are done.

If this doesn't work, you might think about investing into a call to CSS.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Paul_R_UK" <PaulRUK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C2A9DE13-B153-4BFE-B963-C775E403D2C8@xxxxxxxxxxxxxxxx
Just checked and I don't have any log files on the remote server on April
13th!

I just ran the SP4 setup again from my main server (cfsa9aaf) and when it
gets to the part about doing the Cluster operations, I went to my remote
server (cfsa9aae) to see what files it created in c:\windows...

The ONLY file it created was a file called CFSA9AAE_MSSQLSERVER.ISS & this
disappeared the moment the error message appeared on the main server.
There
is definitely no log file created on my remote server.

However, clustering is working as I can failover all groups no problem. I
can map network drives between both servers ok as well.

One last thing, not sure if this is of any use but when the error message
appears and I go into Cluster Administrator, I have 3 resources all
offline
(they were all online when I started the SP4 install). They are SQL
Server,
SQL Server Agent & SQL Server Fulltext.

I have also tried running the SP4 setup from the other server (cfsa9aae) &
I
get exactly the same result. The same error message, 3 offline cluster
resources & no log file on the remote server (it did create the ISS file
though).

Many thanks in advance for any help you guys can provide.


"Paul_R_UK" wrote:

Thanks Geoff for replying. I am back in work on Sunday. I shall post the
log
file from the remote server then.

"Geoff N. Hiten" wrote:

You need to look at the setup log on the remote node to find why it
failed.
This error log only reported that the remote node failed to upgrade.
It had
no further information.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"Paul_R_UK" <PaulRUK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A087EC9E-7BF9-49E6-A9A3-46588F0C22A9@xxxxxxxxxxxxxxxx
Sorry, I forgot to mention that the servers are currently at SP3.

Thanks

"Paul_R_UK" wrote:

I have entered the name of my virtual server, have then stated the
details of
the user that is a member of the administrators group on both nodes
then
I
get the 'Setup is performing required operations on cluster nodes.
This
may
take a few minutes' screen.

2 or 3 minutes later the setup fails with the following error
message:

SETUP FAILED TO PERFORM REQUIRED OPERATIONS ON THE CLUSTER NODES

Here is the contents of my sqlsp.log:

09:27:40 Begin Setup
09:27:40 Version on Media: 8.00.2039
09:27:40 Mode = Normal
09:27:40 ModeType = NORMAL
09:27:41 Loading library - sqlsut.dll (#L1)
09:27:41 Begin: SetupInitialize()
09:27:41 End: SetupInitialize()
09:27:41 Begin: CheckFixedRequirements()
09:27:41 Platform ID: 0xf00000
09:27:41 Version: 5.2.3790
09:27:41 File Version - C:\WINDOWS\system32\shdocvw.dll:
6.0.3790.2580
09:27:41 End: CheckFixedRequirements()
09:27:41 Processor Architecture: x86 (Pentium)
09:27:41 Service Pack: 256
09:27:41 ComputerName: CFSA9AAF
09:27:41 User Name: uscc16
09:27:41 IsAllAccessAllowed returned: 1
09:27:41 OS Language: 0x809
09:27:41 Begin: SetupInstall()
09:27:41 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
09:27:41 CommonFilesDir=C:\Program Files\Common Files
09:27:41 Windows Directory=C:\WINDOWS\
09:27:41 Program Files=C:\Program Files\
09:27:41 TEMPDIR=C:\TEMP\2\
09:27:41 End: SetupInstall()
09:27:41 Begin: ShowDialogs()
09:27:42 Initial Dialog Mask: 0x8300037, Disable Back=0x1
09:27:42 Begin Action ShowDialogsHlpr: 0x1
09:27:42 Begin Action: DialogShowSdWelcome
09:27:43 End Action DialogShowSdWelcome
09:27:43 Dialog 0x1 returned: 1
09:27:43 End Action ShowDialogsHlpr
09:27:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
09:27:43 Begin Action ShowDialogsHlpr: 0x2
09:27:43 Begin Action: DialogShowSdMachineName
09:27:48 ShowDlgMachine returned: 1
09:27:48 Name = M2MSQL1, Type = 0x20000008
09:27:48 End Action DialogShowSdMachineName
09:27:48 begin ShowDialogsUpdateMask
09:27:48 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
09:27:48 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
09:27:48 Dialog 0x2 returned: 1
09:27:48 End Action ShowDialogsHlpr
09:27:48 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
09:27:48 Begin Action ShowDialogsHlpr: 0x4
09:27:48 Begin Action: DialogShowSdInstallMode
09:27:48 ShowDlgInstallMode returned: 1
09:27:48 InstallMode : 0x2
09:27:48 End Action DialogShowSdInstallMode
09:27:48 begin ShowDialogsUpdateMask
09:27:48 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
09:27:48 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
09:27:48 Dialog 0x4 returned: 1
09:27:48 End Action ShowDialogsHlpr
09:27:48 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
09:27:48 Begin Action ShowDialogsHlpr: 0x200
09:27:48 Begin Action: DialogShowSdInstanceName
09:27:48 Begin Action: ShowDlgInstanceName
09:27:48 SKU is : Enterprise Edition
09:27:48 End Action: ShowDlgInstanceName
09:27:48 ShowDlgInstanceName returned : 0
09:27:48 InstanceName : MSSQLSERVER
09:27:48 End Action DialogShowSdInstanceName
09:27:48 begin ShowDialogsUpdateMask
09:27:48 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 0
09:27:48 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
09:27:48 Dialog 0x200 returned: 0
09:27:48 End Action ShowDialogsHlpr
09:27:48 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
09:27:48 Begin Action ShowDialogsHlpr: 0x400
09:27:48 Begin Action: DialogShowSdMaintain
09:27:48 ShowDlgMaintainInstall returned : 1
09:27:48 Type : 0xc
09:27:48 CreateSetupTopology(CFSA9AAF), Handle : 0x1224f68, returned
: 0
09:27:48 CreateSetupTopology returned : 0, Handle : 0x1224f68
09:27:48 Topology Type : 1, Return Value : 0
09:27:48 ST_GetPhysicalNode returned : 0, PNHandle : 0x1224090
09:27:48 PN_EnumerateEx returned : 0
09:27:48 PN_GetSQLStates returned : 0, SqlStates : 0x88008221
09:27:48 PN_GetInstance for MSSQLSERVER [0x1224090] returned : 0
09:27:48 SQLI_GetPackageId [0x1224600] returned : 0, PackageId = 0x3
09:27:48 SQLI_GetVersion [0x1224600] returned : 0, Version =
8.00.194
09:27:48 SQLI_GetSQLStates for MSSQLSERVER [0x1224600] returned : 0,
SQLStates: 0x400209
09:27:48 SQLI_GetInstallPath [0x1224600] returned : 0, Path =
C:\Program
Files\Microsoft SQL Server\MSSQL
09:27:48 SQLI_GetDataPath [0x1224600] returned : 0, DataPath =
z:\MSSQL
09:27:48 SQLI_GetVersion [0x1224600] returned : 0, Version =
8.00.194
09:27:48 SQLI_GetRegKeyRoot [0x1224600] returned : 0, RegKeyRoot =
Software\Microsoft\MSSQLServer
09:27:48 SQLI_GetPackageName [0x1224600] returned : 0, szPackage =
Enterprise Edition
09:27:48 SQLI_GetPackageId [0x1224600] returned : 0, PackageId = 0x3
09:27:48 Previous Install Path: C:\Program Files\Microsoft SQL
Server\MSSQL
09:27:48 Previous Install Data: z:\MSSQL
09:27:48 Previous Install Version: 8.00.194
09:27:48 ReleaseSetupTopology
09:27:48 End Action DialogShowSdMaintain
09:27:48 begin ShowDialogsUpdateMask
09:27:48 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
09:27:48 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
09:27:48 Dialog 0x400 returned: 1
09:27:48 End Action ShowDialogsHlpr
09:27:48 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
09:27:48 Begin Action ShowDialogsHlpr: 0x2000
09:27:48 Begin Action: DialogShowSdUpgrade
09:27:48 ShowDlgUpgrade returned : 1
09:27:48 Checking databases on instance 'MSSQLSERVER'
09:27:48 Begin Action: Check for VS Node
09:27:48 Begin Action: Check for VS Node
09:27:48 Begin Action: Cluster Resources Offline
09:27:53 End Action: Cluster Resources Offline
09:27:53 Authenticate access
09:27:53 Begin SDPassword Dialog
09:27:55 End SDPassword Dialog
09:27:55 C:\TEMP\2\SqlSetup\Bin\scm.exe -Silent 1 -Action
6 -Service
MSSQLSERVER
09:27:55 Process Exit Code: (0)
09:27:55 C:\TEMP\2\SqlSetup\Bin\scm.exe -Silent 1 -Action
1 -Service
MSSQLSERVER -StartupOptions \-T4022
09:28:01 Process Exit Code: (0)
09:28:01 N:\PR\x86\BINN\osql.exe -Slpc:M2MSQL1 -n -d master -Q
"exit" -o
"C:\TEMP\2\sqlsp.out" -E
09:28:01 Process Exit Code: (0)
09:28:01 Begin: CheckSAPassword
09:28:01 Begin: LogOnUsingBlankSA
09:28:01 N:\PR\x86\BINN\osql.exe -Slpc:M2MSQL1 -n -d master -o
"C:\TEMP\2\sqlsp.out" -Q"Exit(declare @ret int if (select count(*)
from
master..syslogins where name='sa' AND ( (1 = pwd
09:28:01 Process Exit Code: (0)
09:28:01 End: LogOnUsingBlankSA
09:28:01 Begin: SdBlankPwd
09:28:01 End: SdBlankPwd
09:28:01 End: CheckSAPassword
09:28:01 Begin : SdErrorReportingDlg
09:28:02 End: SdErrorReportingDlg
09:28:03 Access authenticated
09:28:03 N:\PR\x86\BINN\osql.exe -Slpc:M2MSQL1 -n -b -d master -o
"C:\TEMP\2\~sqldb0.txt" -i "C:\TEMP\2\SqlSetup\Bin\dbverify.sql" -E
09:28:03 Process Exit Code: (0)
09:28:03 C:\TEMP\2\SqlSetup\Bin\scm.exe -Silent 1 -Action
6 -Service
MSSQLSERVER
09:28:18 Process Exit Code: (0)
09:28:18 Setup Type: Custom (303)
09:28:18 WNetGetConnection returned: 0, \\1.1.79.89\d$, 255
09:28:18 Processing: SQLProg
09:28:18 Processing: SQLProg\SQLServr
09:28:18 Processing: SQLProg\UpgTools
09:28:18 Processing: SQLProg\ReplSupp
09:28:18 Processing: SQLProg\Install
09:28:18 Processing: SQLProg\System
09:28:18 Processing: SQLProg\SvrExt
09:28:18 Processing: SQLProg\Dat
09:28:18 Processing: SQLProg\DatSmpl
09:28:18 Processing: SQLProg\BaseSys
09:28:18 Processing: SQLProg\BaseBinn
09:28:18 Processing: SQLProg\MSSearch
09:28:18 Processing: SQLProg\BaseInst
09:28:18 Processing: SQLProg\UI
09:28:18 Processing: SQLProg\Symbols
09:28:18 Processing: SQLProg\Perfmon
09:28:18 Processing: SQLProg\Root
09:28:18 Processing: SQLProg\EXE
09:28:18 Processing: SQLProg\DLL
09:28:18 Processing: MgtTool
09:28:18 Processing: MgtTool\SEM
09:28:18 Processing: MgtTool\Profiler
09:28:18 Processing: MgtTool\Qryanlz
09:28:18 Processing: MgtTool\DTCCLi
09:28:18 Processing: MgtTool\Wzcnflct
09:28:18 Processing: MgtTool\UtilSys
09:28:18 Processing: MgtTool\UtilBinn
09:28:18 Processing: Connect
09:28:18 Processing: Connect\ConnSys
09:28:18 Processing: Books
09:28:18 Processing: Books\Bookso
09:28:18 Processing: DevTools
09:28:18 Processing: DevTools\Headers and Libraries
09:28:18 Processing: DevTools\MDAC SDKs
09:28:18 Processing: DevTools\VDI
09:28:18 Processing: DevTools\Dbg Int
09:28:18 Processing: Samples
09:28:18 Processing: Samples\ADO
09:28:18 Processing: Samples\DBLIB
09:28:18 Processing: Samples\Desktop
09:28:18 Processing: Samples\DTS
09:28:18 Processing: Samples\ESQLC
09:28:18 Processing: Samples\Misc
09:28:18 Processing: Samples\MSDTC
09:28:18 Processing: Samples\ODBC
09:28:18 Processing: Samples\ODS
09:28:18 Processing: Samples\OLEAut
09:28:18 Processing: Samples\Repl
09:28:18 Processing: Samples\SilverstoneDB
09:28:18 Processing: Samples\SQLDMO
09:28:18 Processing: Samples\SQLNS
09:28:18 Processing: Samples\Utils
09:28:18 Processing: Samples\XML
09:28:18 Processing: CoreRepl
09:28:18 Processing: CoreRepl\Res1033
09:28:18 Processing: CoreRepl\ResIntl
09:28:18 Processing: Core
09:28:18 Processing: Core\Res1033
09:28:18 Processing: Core\ResOther
09:28:18 Processing: Repostry
09:28:18 Processing: Repostry\RepstSys
09:28:18 Processing: Repostry\Res1033
09:28:18 Processing: Repostry\ResIntl
09:28:18 Processing: CoreMisc
09:28:18 Processing: CoreMisc\ActiveX
09:28:18 Processing: CoreMisc\Res1033
09:28:18 Processing: Monarch
09:28:18 Processing: Monarch\Monr1033
09:28:18 Processing: Monarch\MonrIntl
09:28:18 Processing: Jet
09:28:18 Processing: CoreInst
09:28:18 Processing: CoreCOM
09:28:18 Processing: CoreCOM\Res1033
09:28:18 Processing: CoreCOM\ResIntl
09:28:18 Processing: CoreTool
09:28:18 Processing: CoreTool\Res1033
09:28:18 Processing: CoreTool\ResOther
09:28:18 Processing: DBLibCli
09:28:18 Processing: SFExt
09:28:18 Processing: SFExt\ActiveX
09:28:18 Processing: SFExt\Res1033
09:28:18 Processing: SFExt\ResIntl
09:28:18 Processing: Trace
09:28:18 Processing: Trace\Res1033
09:28:18 Processing: Trace\ResOther
09:28:18 Processing: CnctBinn
09:28:18 Processing: MiscCore
09:28:18 Processing: MC
09:28:18 Processing: MC\MC1033
09:28:18 Processing: MC\MCIntl
09:28:18 Processing: MC\Help
09:28:18 Processing: UI
09:28:18 Processing: UI\UIHlp
09:28:18 Processing: UI\UI1033
09:28:18 Processing: UI\UIIntl
09:28:18 Processing: ClstSys
09:28:18 Processing: SQLMgr
09:28:18 Processing: SQLMgr\Res1033
09:28:18 Processing: SQLMgr\ResIntl
09:28:18 Processing: SvrTool
09:28:18 Processing: SvrTool\Res1033
09:28:18 Processing: SvrTool\ResIntl
09:28:18 Processing: DTSUI
09:28:18 Processing: DTSUI\Res1033
09:28:18 Processing: DTSUI\ResIntl
09:28:18 Processing: ClFTSys
09:28:18 Processing: ClFtdata
09:28:18 Processing: MSOlap
09:28:18 Processing: MSOlap\Res1033
09:28:18 Processing: MSOlap\ResIntl
09:28:18 Processing: ATL
09:28:18 Processing: ATL\winnt
09:28:18 Processing: ATL\win9x
09:28:18 Processing: MFC42U
09:28:18 Processing: VC
09:28:18 Processing: VB


.

Relevant Pages

  • Re: SQL2000 Install on Win2k3SP1 Active/Passive Failure...HELP!!
    ... Installation of a named instance of SQL Server 2000 virtual server on a ... appeared it couldn't complete the install on NODEB it backed it all out ... 14:28:30 End Action DialogShowSdWelcome ... 14:28:30 End Action ShowDialogsHlpr ...
    (microsoft.public.sqlserver.clustering)
  • Re: Installing SQL2000 on Server 2003
    ... When you install SQL on Windows 2003, you'll get a message that it won't run ... unless you install at least SQL Server 2000 SP3a. ... 10:18:47 End Action DialogShowSdWelcome ... 10:18:47 End Action ShowDialogsHlpr ...
    (microsoft.public.sqlserver.setup)
  • SP4 Unattended Setup
    ... install SP4 on a virgin SQL2000 installation. ... 09:24:12 End Action DialogShowSdWelcome ... 09:24:12 End Action ShowDialogsHlpr ... 09:24:28 Process Exit Code: ...
    (microsoft.public.sqlserver.setup)
  • Re: Unable to install SQL 2000 sp4 on Windows 2003 Cluster
    ... Just checked and I don't have any log files on the remote server on April 13th! ... I just ran the SP4 setup again from my main server and when it ... 09:27:43 End Action DialogShowSdWelcome ... 09:27:43 End Action ShowDialogsHlpr ...
    (microsoft.public.sqlserver.clustering)
  • Re: URGENT: Issue Installing Sql 2000 SP3a in Windows 2000 SP4
    ... I have named pipes configured on the server, the client also has been set to ... 09:07:45 End Action DialogShowSdWelcome ... 09:07:45 End Action ShowDialogsHlpr ... 09:07:48 Previous Install Version: 8.00.194 ...
    (microsoft.public.sqlserver.setup)