Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Location
    Hong Kong
    Posts
    10

    Unanswered: SQL Server 2000 installation hang

    Hi,

    I am using Windows 2003 Standard Server (stand alone) and trying to install SQL Server 2000 Enterprise edition. The installation stops whenever I have entered the sa password (the dialog box disappeared and then nothing happed, but the "setupsql" process (something like this) is still there).

    The same happened when I install SQL Server 2000 in Windows 2000 Server. For Win2K, I can first install SQL Server 7.0 and then upgrade to 2000 (same SQL Server 2000 installation CD!). However, Windows 2003 doesn't support SQL Server 7.0. So I can't use this method...

    Any idea?

    Thanks.

    Michael

    *I have turned off Norton already.

  2. #2
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    u can read sqlstp.log file from C:\windows for more informations.. or attach this file with your uery for us..
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  3. #3
    Join Date
    Sep 2004
    Location
    Hong Kong
    Posts
    10
    The content of sqlstp.log, hope it helps

    23:18:08 Begin Setup
    23:18:08 8.00.194
    23:18:08 Mode = Normal
    23:18:08 ModeType = NORMAL
    23:18:09 GetDefinitionEx returned: 0, Extended: 0x0
    23:18:09 ValueFTS returned: 1
    23:18:09 ValuePID returned: 1
    23:18:09 ValueLic returned: 1
    23:18:09 System: Windows NT Terminal Server
    23:18:09 SQL Server ProductType: Standard Edition [0x2]
    23:18:09 Begin Action: SetupInitialize
    23:18:09 End Action SetupInitialize
    23:18:09 Begin Action: SetupInstall
    23:18:09 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
    23:18:09 CommonFilesDir=E:\Program Files\Common Files
    23:18:09 Windows Directory=E:\WINDOWS\
    23:18:09 Program Files=E:\Program Files\
    23:18:09 TEMPDIR=E:\WINDOWS\TEMP\
    23:18:09 Begin Action: SetupInstall
    23:18:09 digpid size : 256
    23:18:09 digpid size : 164
    23:18:09 Begin Action: CheckFixedRequirements
    23:18:09 Platform ID: 0xf00
    23:18:09 Version: 5.2.3790
    23:18:09 File Version - E:\WINDOWS\system32\shdocvw.dll: 6.0.3790.186
    23:18:09 End Action: CheckFixedRequirements
    23:18:09 Begin Action: ShowDialogs
    23:18:09 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
    23:18:09 Begin Action ShowDialogsHlpr: 0x1
    23:18:09 Begin Action: DialogShowSdWelcome
    23:18:10 End Action DialogShowSdWelcome
    23:18:10 Dialog 0x1 returned: 1
    23:18:10 End Action ShowDialogsHlpr
    23:18:10 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
    23:18:10 Begin Action ShowDialogsHlpr: 0x2
    23:18:10 Begin Action: DialogShowSdMachineName
    23:19:07 ShowDlgMachine returned: 1
    23:19:07 Name = MATRIX, Type = 0x1
    23:19:07 Begin Action: CheckRequirements
    23:19:07 Processor Architecture: x86 (Pentium)
    23:19:07 ComputerName: MATRIX
    23:19:07 User Name: Administrator
    23:19:07 IsAllAccessAllowed returned: 1
    23:19:07 OS Language: 0xc04
    23:19:07 End Action CheckRequirements
    23:19:07 This combination of Package and Operating System allows a full product install.
    23:19:07 CreateSetupTopology(MATRIX), Handle : 0x1504008, returned : 0
    23:19:07 CreateSetupTopology returned : 0, Handle : 0x1504008
    23:19:07 Topology Type : 1, Return Value : 0
    23:19:07 ST_GetPhysicalNode returned : 0, PNHandle : 0x1504030
    23:19:07 PN_EnumerateEx returned : 0
    23:19:07 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
    23:19:07 PN_StartScan [0x1504030] returned : 0
    23:19:07 PN_GetNext [0x1504030] returned : 18, Handle: [0x0]
    23:19:07 No more items in enumeration.
    23:19:07 ReleaseSetupTopology
    23:19:07 Named instance limit: 100, quota: 0
    23:19:07 End Action DialogShowSdMachineName
    23:19:07 begin ShowDialogsUpdateMask
    23:19:07 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
    23:19:07 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
    23:19:07 Dialog 0x2 returned: 0
    23:19:07 End Action ShowDialogsHlpr
    23:19:07 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
    23:19:07 Begin Action ShowDialogsHlpr: 0x4
    23:19:07 Begin Action: DialogShowSdInstallMode
    23:19:08 ShowDlgInstallMode returned: 1
    23:19:08 InstallMode : 0x1
    23:19:08 End Action DialogShowSdInstallMode
    23:19:08 begin ShowDialogsUpdateMask
    23:19:08 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
    23:19:08 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
    23:19:08 Dialog 0x4 returned: 1
    23:19:08 End Action ShowDialogsHlpr
    23:19:08 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
    23:19:08 Begin Action ShowDialogsHlpr: 0x10
    23:19:08 Begin Action: DialogShowSdRegisterUserEx
    23:19:09 End Action DialogShowSdRegisterUserEx
    23:19:09 Dialog 0x10 returned: 1
    23:19:09 End Action ShowDialogsHlpr
    23:19:09 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
    23:19:09 Begin Action ShowDialogsHlpr: 0x20
    23:19:09 Begin Action: DialogShowSdLicense
    23:19:10 End Action DialogShowSdLicense
    23:19:10 Dialog 0x20 returned: 1
    23:19:10 End Action ShowDialogsHlpr
    23:19:10 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
    23:19:10 Begin Action ShowDialogsHlpr: 0x40000
    23:19:10 Begin Action: DialogShowSdCliSvr
    23:19:10 DisplaySystemPreReq
    23:19:11 ShowDlgClientServerSelect returned: 1
    23:19:11 Type : 0x2
    23:19:11 End Action DialogShowSdCliSvr
    23:19:11 begin ShowDialogsUpdateMask
    23:19:11 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
    23:19:11 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
    23:19:11 Dialog 0x40000 returned: 1
    23:19:11 End Action ShowDialogsHlpr
    23:19:11 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
    23:19:11 Begin Action ShowDialogsHlpr: 0x80000
    23:19:11 Begin Action: DialogShowSdInstanceName
    23:19:11 Begin Action: ShowDlgInstanceName
    23:19:12 End Action: ShowDlgInstanceName
    23:19:12 ShowDlgInstanceName returned : 1
    23:19:12 InstanceName : MSSQLSERVER
    23:19:12 CreateSetupTopology(MATRIX), Handle : 0x1504008, returned : 0
    23:19:12 CreateSetupTopology returned : 0, Handle : 0x1504008
    23:19:12 Topology Type : 1, Return Value : 0
    23:19:12 ST_GetPhysicalNode returned : 0, PNHandle : 0x1504030
    23:19:12 PN_EnumerateEx returned : 0
    23:19:12 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
    23:19:12 PN_StartScan [0x1504030] returned : 0
    23:19:12 PN_GetNext [0x1504030] returned : 18, Handle: [0x0]
    23:19:12 No more items in enumeration.
    23:19:12 ReleaseSetupTopology
    23:19:12 End Action DialogShowSdInstanceName
    23:19:12 begin ShowDialogsUpdateMask
    23:19:12 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
    23:19:12 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
    23:19:12 Dialog 0x80000 returned: 1
    23:19:12 End Action ShowDialogsHlpr
    23:19:12 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
    23:19:12 Begin Action ShowDialogsHlpr: 0x100000
    23:19:12 Begin Action: DialogShowSdSetupType
    23:19:12 Begin Action: Setup Type
    23:19:13 SQL program folder: E:\Program Files\Microsoft SQL Server
    23:19:13 SQL data folder: E:\Program Files\Microsoft SQL Server
    23:19:13 Windows system folder: E:\WINDOWS\system32\
    23:19:13 Prog req: 38205, Data req: 34432, Sys req: 182917
    23:19:13 Prog avail: 20881712, Data avail: 20881712, Sys avail: 20881712
    23:19:13 Prog req vs. avail, 255554, 20881712
    23:19:13 Data req vs. avail, 34432, 20881712
    23:19:13 Sys req vs. avail, 217349, 20881712
    23:19:13 DisplaySystemPreReq
    23:19:13 [SetupTypeSQL]
    23:19:13 szDir = E:\Program Files\Microsoft SQL Server
    23:19:13 szDir = %PROGRAMFILES%\Microsoft SQL Server
    23:19:13 Result = 301
    23:19:13 szDataDir = E:\Program Files\Microsoft SQL Server
    23:19:13 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
    23:19:13 End Action: Setup Type
    23:19:13 Setup Type: Typical (301)
    23:19:13 End Action DialogShowSdSetupType
    23:19:13 begin ShowDialogsUpdateMask
    23:19:13 nFullMask = 0x1bfc0037, nCurrent = 0x100000, nDirection = 301
    23:19:13 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
    23:19:13 Dialog 0x100000 returned: 301
    23:19:13 End Action ShowDialogsHlpr
    23:19:13 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
    23:19:13 Begin Action ShowDialogsHlpr: 0x400000
    23:19:13 Begin Action: DlgServices
    23:19:17 ShowDlgServices returned: 1
    23:19:17 [DlgServices]
    23:19:17 Local-Domain = 3855
    23:19:17 AutoStart = 15
    23:19:17 Result = 1
    23:19:17 End Action DlgServices
    23:19:17 begin ShowDialogsUpdateMask
    23:19:17 nFullMask = 0x1bdc0037, nCurrent = 0x400000, nDirection = 1
    23:19:17 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
    23:19:17 Dialog 0x400000 returned: 1
    23:19:17 End Action ShowDialogsHlpr
    23:19:17 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
    23:19:17 Begin Action ShowDialogsHlpr: 0x800000
    23:19:17 Begin Action: DlgSQLSecurity
    23:19:27 ShowDlgSQLSecurity returned: 1
    23:19:27 LoginMode = 2,szPwd
    23:19:27 End Action DlgSQLSecurity
    23:19:27 begin ShowDialogsUpdateMask
    23:19:27 nFullMask = 0x1bdc0037, nCurrent = 0x800000, nDirection = 1
    23:19:28 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
    23:19:28 Dialog 0x800000 returned: 1
    23:19:28 End Action ShowDialogsHlpr
    23:19:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
    23:19:28 Begin Action ShowDialogsHlpr: 0x1000000
    23:19:28 Begin Action: DlgCollation

  4. #4
    Join Date
    Sep 2004
    Location
    Hong Kong
    Posts
    10

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •