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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 2000 SP4 Installation Hangs
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 06/22/2005 :  07:46:53  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

Constraint Violating Yak Guru

483 Posts

Posted - 06/22/2005 :  08:06:29  Show Profile  Reply with Quote
You might just want to go to sp 3a. There have been some problems with 4.

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.
Go to Top of Page

Posting Yak Master

198 Posts

Posted - 06/22/2005 :  11:34:30  Show Profile  Reply with Quote
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.

Edited by - TimS on 06/22/2005 13:21:27
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000