SQL 2000 SP4 Installation Hangs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL 2000 SP4 Installation Hangs

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-22 : 07:46:53

Sujit writes "Hi All,
I am having a weird problem installing SQL Service Pack4 on a machine that has just SQL Server 2000 Standard edition.

The issue is: I have a clean machine on which I had SQL Server 2000 (no service pack installed) on it. For some reason, I uninstalled SQL Server 2000 and then restarted the machine.
After restarting I installed SQL Server 2000 and restarted. Now when I am trying to install the recently released (12th May 2005) Service Pack 4, the Installation is hanging at this point.
From the log file : (I opened the SQLSP.log file from Windows folder)
*****************************************************************
16:35:08 Begin Setup
16:35:08 Version on Media: 8.00.2039
16:35:08 Mode = Normal
16:35:08 ModeType = NORMAL
16:35:09 Loading library - sqlsut.dll (#L1)
16:35:09 Begin: SetupInitialize()
16:35:09 End: SetupInitialize()
16:35:09 Begin: CheckFixedRequirements()
16:35:09 Platform ID: 0xf0000000
16:35:09 Version: 5.0.2195
16:35:09 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1106
16:35:09 End: CheckFixedRequirements()
16:35:09 Begin Action: CheckRequirements
16:35:09 Processor Architecture: x86 (Pentium)
16:35:09 Service Pack: 1024
16:35:09 ComputerName: EAF-INSTALL
16:35:09 User Name: Administrator
16:35:09 IsAllAccessAllowed returned: 1
16:35:09 OS Language: 0x409
16:35:09 End Action CheckRequirements
16:35:09 CreateSetupTopology(EAF-INSTALL), Handle : 0x18d3a00, returned : 0
16:35:09 CreateSetupTopology returned : 0, Handle : 0x18d3a00
16:35:09 Topology Type : 1, Return Value : 0
16:35:09 ST_GetPhysicalNode returned : 0, PNHandle : 0x18d4358
16:35:09 PN_EnumerateEx returned : 0
16:35:09 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
16:35:09 PN_StartScan [0x18d4358] returned : 0
16:35:09 PN_GetNext [0x18d4358] returned : 0, Handle: [0x18d48e8]
16:35:09 SQLI_GetPackageId [0x18d48e8] returned : 0, PackageId = 0x3
16:35:09 SQLI_GetVersion [0x18d48e8] returned : 0, Version = 8.00.194
16:35:09 PN_GetNext [0x18d4358] returned : 18, Handle: [0x0]
16:35:09 ReleaseSetupTopology
16:35:09 This combination of Package and Operating System allows a full product install.
16:35:09 Begin: SetupInstall()
16:35:09 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
16:35:09 CommonFilesDir=C:\Program Files\Common Files
16:35:09 Windows Directory=C:\WINNT16:35:09 Program Files=C:\Program Files16:35:09 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp16:35:09 End: SetupInstall()
16:35:09 Begin: ShowDialogs()
16:35:09 Initial Dialog Mask: 0x8300037, Disable Back=0x1
16:35:09 Begin Action ShowDialogsHlpr: 0x1
16:35:09 Begin Action: DialogShowSdWelcome
16:35:17 End Action DialogShowSdWelcome
16:35:17 Dialog 0x1 returned: 1
16:35:17 End Action ShowDialogsHlpr
16:35:17 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:35:17 Begin Action ShowDialogsHlpr: 0x2
16:35:17 Begin Action: DialogShowSdMachineName
16:35:17 ShowDlgMachine returned: 1
16:35:17 Name = EAF-INSTALL, Type = 0x1
16:35:17 End Action DialogShowSdMachineName
16:35:17 begin ShowDialogsUpdateMask
16:35:17 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 0
16:35:17 Updated Dialog Mask: 0xbf00035, Disable Back = 0x1
16:35:17 Dialog 0x2 returned: 0
16:35:17 End Action ShowDialogsHlpr
16:35:17 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:35:17 Begin Action ShowDialogsHlpr: 0x4
16:35:17 Begin Action: DialogShowSdInstallMode
16:35:17 ShowDlgInstallMode returned: 1
16:35:17 InstallMode : 0x2
16:35:17 End Action DialogShowSdInstallMode
16:35:17 begin ShowDialogsUpdateMask
16:35:17 nFullMask = 0xbf00035, nCurrent = 0x4, nDirection = 1
16:35:17 Updated Dialog Mask: 0xb000627, Disable Back = 0x1
16:35:17 Dialog 0x4 returned: 1
16:35:17 End Action ShowDialogsHlpr
16:35:17 ShowDialogs

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-06-22 : 08:06:29

You might just want to go to sp 3a. There have been some problems with 4.

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1883.aspx

Sean Roussy

Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.

I am available for consulting work. Just email me though the forum.

TimS
Posting Yak Master

198 Posts

Posted - 2005-06-22 : 11:34:30

If its on Windows 2000 OS may wish to install MDAC 2.8 SP1 on it in case that is where it is hanging.

Also, may wish to set TEMPDIR to a value like C:\TEMP some installs have problems with TEMPDIR set to a long file name folder.
Note: I ran SQL SP4 on a machine with long file name with no problem, but it is something to try.

Edit: A random guess based on other post on different site; make sure you are installing the SP off of a local drive or at least a mapped drive. DO NOT try it off of a UNC share.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources