SQL 2K install fails error 1503 on win 2003

[moonshadow]

We're trying to install SQL 2000 (no SP) and then SP4 on Windows 2003 SP1. This is being installed automatically. However, the initial SQL 2K install is failing. The sqlstp.log has the following error message:
14:18:35 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 196814 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1053)

SQL Server configuration failed.

###############################################################################

14:23:31 Process Exit Code: (-1)
14:23:31 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.

The error log for SQL is thus:
2005-09-05 14:18:35.67 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2005-09-05 14:18:35.68 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-09-05 14:18:35.68 server All rights reserved.
2005-09-05 14:18:35.68 server Server Process ID is 3412.
2005-09-05 14:18:35.68 server Logging SQL Server messages in file 'E:\MSSQL\log\ERRORLOG'.
2005-09-05 14:18:35.69 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-09-05 14:18:35.75 server SQL Server configured for thread mode processing.
2005-09-05 14:18:35.76 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2005-09-05 14:18:35.78 server Attempting to initialize Distributed Transaction Coordinator.
2005-09-05 14:18:37.23 spid3 Warning ******************
2005-09-05 14:18:37.23 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2005-09-05 14:18:37.25 spid3 Starting up database 'master'.
2005-09-05 14:18:37.73 spid3 Server name is 'SBN023770'.
2005-09-05 14:18:37.74 server Using 'SSNETLIB.DLL' version '8.0.311'.
2005-09-05 14:18:37.74 spid5 Starting up database 'model'.
2005-09-05 14:18:37.74 spid7 Starting up database 'msdb'.
2005-09-05 14:18:37.74 spid8 Starting up database 'pubs'.
2005-09-05 14:18:37.74 spid9 Starting up database 'Northwind'.
2005-09-05 14:18:38.07 spid5 Clearing tempdb database.
2005-09-05 14:18:38.15 server SQL server listening on 10.30.237.70: 1433.
2005-09-05 14:18:38.15 server SQL server listening on 127.0.0.1: 1433.
2005-09-05 14:18:38.61 spid5 Starting up database 'tempdb'.
2005-09-05 14:18:38.71 spid3 Recovery complete.
2005-09-05 14:18:38.72 spid3 Warning: override, autoexec procedures skipped.
2005-09-05 14:23:32.16 server SQL server listening on TCP, Shared Memory, Named Pipes.
2005-09-05 14:23:32.16 server SQL Server is ready for client connections
2005-09-05 14:23:37.04 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

As you see, there's a 5 minute delay from 14:18:38.72 to 14:23:32.16 before SQL Server is eventually listening. I believe the SQL configuration utility is meanwhile trying to start the SQL Agent service, and this is failing with a time out (1053).
We have a 120 of these remote servers to build, and quite a few are failing.
Anyone any ideas?

 

[mrdenny]

What is in "C:\WINDOWS\sqlstp.log"?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[SQLBill]

Does your unattended install provide a 'strong' password for the SA account?

Windows 2003 requires that any SQL Server account have SP3a and a strong password on SA account and it will popup a warning box for at least the password. If you are doing it manually, you can continue and provide a strong password later. But with an unattended install, I don't know if it would fail or have a delay.

Also, which version of SQL Server 2000 are you installing and is the OS Windows 2003 SERVER?

-SQLBill

Posting advice: FAQ481-4875

 

[moonshadow]

We have a strong password. The automatic install does SQL 2000 RTM first, and then SP4 after.
The thing is, it's working on about 50% of the machines - which are all identical specification. In fact, the installation etc. is on pre-built hard disks, with identical software, and these are just swapped for the existing disks in each server.
We had one server yesterday when the first 2 set of disks failed, but the third attempt succeeded !!
Is it possible that there's some sort of network issue causing the 5 minute delay in the start up of SQL Server?
Any help would be most welcome.

sqlstp.log is the installation log file for the install of SQL Server 2000

 

[mrdenny]

I know what it is.

What I was trying to get you to do was post it, but apparently I was an idiot that day and expected you to read my mind.

Can you post it please?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[moonshadow]

I've posted the relevant section (I believe). But here's the whole lot:
14:17:26 Begin Setup
14:17:26 8.00.194
14:17:26 Mode = Silent
14:17:26 ModeType = NORMAL
14:17:26 g_szIssPath=C:\WINDOWS\setup~0.iss
14:17:26 GetDefinitionEx returned: 0, Extended: 0x0
14:17:26 ValueFTS returned: 1
14:17:26 ValuePID returned: 1
14:17:26 ValueLic returned: 1
14:17:26 System: Windows NT Terminal Server
14:17:26 SQL Server ProductType: Standard Edition [0x2]
14:17:26 Begin Action: SetupInitialize
14:17:26 End Action SetupInitialize
14:17:26 Begin Action: SetupInstall
14:17:26 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
14:17:26 CommonFilesDir=C:\Program Files\Common Files
14:17:26 Windows Directory=C:\WINDOWS\
14:17:26 Program Files=C:\Program Files\
14:17:26 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\
14:17:26 Begin Action: SetupInstall
14:17:26 digpid size : 256
14:17:27 digpid size : 164
14:17:27 Begin Action: CheckFixedRequirements
14:17:27 Platform ID: 0xf00
14:17:27 Version: 5.2.3790
14:17:27 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.1830
14:17:27 End Action: CheckFixedRequirements
14:17:27 Begin Action: ShowDialogs
14:17:27 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
14:17:27 Begin Action ShowDialogsHlpr: 0x1
14:17:27 Begin Action: DialogShowSdWelcome
14:17:27 End Action DialogShowSdWelcome
14:17:27 Dialog 0x1 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:17:27 Begin Action ShowDialogsHlpr: 0x2
14:17:27 Begin Action: DialogShowSdMachineName
14:17:27 [DlgMachine]
14:17:27 Result = 1
14:17:27 Type = 1
14:17:27 Name = SBN023770
14:17:27 ShowDlgMachine returned: 1
14:17:27 Name = SBN023770, Type = 0x1
14:17:27 Begin Action: CheckRequirements
14:17:27 Processor Architecture: x86 (Pentium)
14:17:27 Service Pack: 256
14:17:27 ComputerName: SBN023770
14:17:27 User Name: Administrator
14:17:27 IsAllAccessAllowed returned: 1
14:17:27 OS Language: 0x809
14:17:27 End Action CheckRequirements
14:17:27 This combination of Package and Operating System allows a full product install.
14:17:27 CreateSetupTopology(SBN023770), Handle : 0x10d3e88, returned : 0
14:17:27 CreateSetupTopology returned : 0, Handle : 0x10d3e88
14:17:27 Topology Type : 1, Return Value : 0
14:17:27 ST_GetPhysicalNode returned : 0, PNHandle : 0x10d3ed8
14:17:27 PN_EnumerateEx returned : 0
14:17:27 PN_GetSQLStates returned : 0, SqlStates : 0x0
14:17:27 PN_StartScan [0x10d3ed8] returned : 0
14:17:27 PN_GetNext [0x10d3ed8] returned : 18, Handle: [0x0]
14:17:27 No more items in enumeration.
14:17:27 ReleaseSetupTopology
14:17:27 Named instance limit: 100, quota: 0
14:17:27 End Action DialogShowSdMachineName
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
14:17:27 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
14:17:27 Dialog 0x2 returned: 0
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:17:27 Begin Action ShowDialogsHlpr: 0x4
14:17:27 Begin Action: DialogShowSdInstallMode
14:17:27 [DlgInstallMode]
14:17:27 Result = 1
14:17:27 Type = 32
14:17:27 ShowDlgInstallMode returned: 1
14:17:27 InstallMode : 0x20
14:17:27 End Action DialogShowSdInstallMode
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
14:17:27 Updated Dialog Mask: 0xbf0003f, Disable Back = 0x1
14:17:27 Dialog 0x4 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x8,index=3
14:17:27 Begin Action ShowDialogsHlpr: 0x8
14:17:27 Begin Action : DialogShowSdAdvanced
14:17:27 [DlgAdvanced]
14:17:27 Result = 1
14:17:27 AdvType = 4
14:17:27 ShowDlgAdvanced returned: 1
14:17:27 Adv Install Mode = 4
14:17:27 End Action : DialogShowSdAdvanced
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0xbf0003f, nCurrent = 0x8, nDirection = 1
14:17:27 Updated Dialog Mask: 0x1bf4013f, Disable Back = 0x1
14:17:27 Dialog 0x8 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
14:17:27 Begin Action ShowDialogsHlpr: 0x10
14:17:27 Begin Action: DialogShowSdRegisterUserEx
14:17:27 End Action DialogShowSdRegisterUserEx
14:17:27 Dialog 0x10 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:17:27 Begin Action ShowDialogsHlpr: 0x20
14:17:27 Begin Action: DialogShowSdLicense
14:17:27 End Action DialogShowSdLicense
14:17:27 Dialog 0x20 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x100,index=8
14:17:27 Begin Action ShowDialogsHlpr: 0x100
14:17:27 Begin Action : _ShowObtainRemoteInfo
14:17:27 End Action : _ShowObtainRemoteInfo
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x1bf4013f, nCurrent = 0x100, nDirection = 0
14:17:27 Updated Dialog Mask: 0x1bf4013f, Disable Back = 0x1
14:17:27 Dialog 0x100 returned: 0
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
14:17:27 Begin Action ShowDialogsHlpr: 0x40000
14:17:27 Begin Action: DialogShowSdCliSvr
14:17:27 DisplaySystemPreReq
14:17:27 [DlgClientServer]
14:17:27 Result = 1
14:17:27 Type = 2
14:17:27 ShowDlgClientServerSelect returned: 1
14:17:27 Type : 0x2
14:17:27 End Action DialogShowSdCliSvr
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x1bf4013f, nCurrent = 0x40000, nDirection = 1
14:17:27 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:27 Dialog 0x40000 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
14:17:27 Begin Action ShowDialogsHlpr: 0x80000
14:17:27 Begin Action: DialogShowSdInstanceName
14:17:27 [DlgInstanceName]
14:17:27 Result = 1
14:17:27 InstanceName = MSSQLSERVER
14:17:27 Begin Action: ShowDlgInstanceName
14:17:27 End Action: ShowDlgInstanceName
14:17:27 ShowDlgInstanceName returned : 1
14:17:27 InstanceName : MSSQLSERVER
14:17:27 CreateSetupTopology(SBN023770), Handle : 0x10d3e88, returned : 0
14:17:27 CreateSetupTopology returned : 0, Handle : 0x10d3e88
14:17:27 Topology Type : 1, Return Value : 0
14:17:27 ST_GetPhysicalNode returned : 0, PNHandle : 0x10d3ed8
14:17:27 PN_EnumerateEx returned : 0
14:17:27 PN_GetSQLStates returned : 0, SqlStates : 0x0
14:17:27 PN_StartScan [0x10d3ed8] returned : 0
14:17:27 PN_GetNext [0x10d3ed8] returned : 18, Handle: [0x0]
14:17:27 No more items in enumeration.
14:17:27 ReleaseSetupTopology
14:17:27 End Action DialogShowSdInstanceName
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x1bfc013f, nCurrent = 0x80000, nDirection = 1
14:17:27 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:27 Dialog 0x80000 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
14:17:27 Begin Action ShowDialogsHlpr: 0x100000
14:17:27 Begin Action: DialogShowSdSetupType
14:17:27 Begin Action: Setup Type
14:17:27 [SetupTypeSQL]
14:17:27 Result = 303
14:17:27 szDir = %PROGRAMFILES%\Microsoft SQL Server
14:17:27 final szDir = C:\Program Files\Microsoft SQL Server
14:17:27 szDataDir = E:\
14:17:27 final szDataDir = E:\
14:17:27 End Action: Setup Type
14:17:27 Setup Type: Custom (303)
14:17:27 End Action DialogShowSdSetupType
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x1bfc013f, nCurrent = 0x100000, nDirection = 303
14:17:27 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:27 Dialog 0x100000 returned: 303
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
14:17:27 Begin Action ShowDialogsHlpr: 0x200000
14:17:27 Begin Action: DialogShowSdComponentMult
14:17:27 basesys = 0, baseinst = 0, basedata = 0
14:17:27 Begin Action: Component Handler
14:17:27 ***** Silent Mode in Multi comps
14:17:27 [SQLComponentMult]
14:17:27 Result = 1
14:17:27 ComponentSelectItem(MgtTool\Wzcnflct): -103
14:17:27 End Action: Component Handler
14:17:27 End Action DialogShowSdComponentMult
14:17:27 begin ShowDialogsUpdateMask
14:17:27 nFullMask = 0x1bfc013f, nCurrent = 0x200000, nDirection = 1
14:17:27 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:27 Dialog 0x200000 returned: 1
14:17:27 End Action ShowDialogsHlpr
14:17:27 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
14:17:27 Begin Action ShowDialogsHlpr: 0x400000
14:17:27 Begin Action: DlgServices
14:17:27 [DlgServices]
14:17:27 Result = 1
14:17:27 Local-Domain = 61680
14:17:27 AutoStart = 255
14:17:27 SQLDomain = MUTUAL
14:17:27 SQLDomainAcct = SV-branchsql
14:17:27 SQLDomainPwd
14:17:27 ValidateUser returned: 1, 0, 0x178
14:17:28 GrantRightAsService returned : 1, 0
14:17:28 AgtDomain = MUTUAL
14:17:28 AgtDomainAcct = SV-branchsqlagent
14:17:28 AgtDomainPwd
14:17:28 ValidateUser returned: 1, 0, 0x174
14:17:28 GrantRightAsService returned : 1, 0
14:17:28 End Action DlgServices
14:17:28 begin ShowDialogsUpdateMask
14:17:28 nFullMask = 0x1bfc013f, nCurrent = 0x400000, nDirection = 1
14:17:28 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:28 Dialog 0x400000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
14:17:28 Begin Action ShowDialogsHlpr: 0x800000
14:17:28 Begin Action: DlgSQLSecurity
14:17:28 [DlgSQLSecurity]
14:17:28 Result = 1
14:17:28 szPwd
14:17:28 ShowDlgSQLSecurity returned: 1
14:17:28 LoginMode = 2,szPwd
14:17:28 End Action DlgSQLSecurity
14:17:28 begin ShowDialogsUpdateMask
14:17:28 nFullMask = 0x1bfc013f, nCurrent = 0x800000, nDirection = 1
14:17:28 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:28 Dialog 0x800000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:17:28 Begin Action ShowDialogsHlpr: 0x1000000
14:17:28 Begin Action: DlgCollation
14:17:28 [DlgCollation]
14:17:28 Result = 1
14:17:28 collation_name = SQL_Latin1_General_CP1_CI_AS
14:17:28 ShowDlgCollation returned: 1
14:17:28 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid = 0x0,SortId = 0,dwCompFlags = 0x0
14:17:28 End Action DlgCollation
14:17:28 begin ShowDialogsUpdateMask
14:17:28 nFullMask = 0x1bfc013f, nCurrent = 0x1000000, nDirection = 1
14:17:28 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:28 Dialog 0x1000000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:17:28 Begin Action ShowDialogsHlpr: 0x2000000
14:17:28 Begin Action: DlgNetwork
14:17:28 Result = 1
14:17:28 [DlgServerNetwork]
14:17:28 NetworkLibs = 255
14:17:28 TCPPort =1433
14:17:28 TCPPrxy =
14:17:28 NMPPipeName =\\.\pipe\sql\query
14:17:28 ShowDlgNetwork returned: 1
14:17:28 [DlgServerNetwork]
14:17:28 NetworkLibs = 255
14:17:28 TCPPort = 1433
14:17:28 TCPPrxy = Default
14:17:28 NMPPipeName = \\.\pipe\sql\query
14:17:28 Result = 1
14:17:28 End Action DlgNetwork
14:17:28 begin ShowDialogsUpdateMask
14:17:28 nFullMask = 0x1bfc013f, nCurrent = 0x2000000, nDirection = 1
14:17:28 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:28 Dialog 0x2000000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:17:28 Begin Action ShowDialogsHlpr: 0x8000000
14:17:28 Begin Action: DialogShowSdStartCopy
14:17:28 End Action DialogShowSdStartCopy
14:17:28 begin ShowDialogsUpdateMask
14:17:28 nFullMask = 0x1bfc013f, nCurrent = 0x8000000, nDirection = 1
14:17:28 Updated Dialog Mask: 0x1bfc013f, Disable Back = 0x1
14:17:28 Dialog 0x8000000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
14:17:28 Begin Action ShowDialogsHlpr: 0x10000000
14:17:28 Begin Action: DialogShowSdLicenseMode
14:17:28 LicenseMode as read from ISS file : PERDEVICE
14:17:28 LicenseLimit as read from ISS file : 1595
14:17:28 ShowDlgLicense returned: 1
14:17:28 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 1595
14:17:28 End Action DialogShowSdLicenseMode
14:17:28 Dialog 0x10000000 returned: 1
14:17:28 End Action ShowDialogsHlpr
14:17:28 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:17:28 End Action ShowDialogs
14:17:28 Begin Action ProcessBeforeDataMove:
14:17:28 DeinstallStart returned (C:\Program Files\Microsoft SQL Server\MSSQL): 0
14:17:28 End Action ProcessBeforeDataMove:
14:17:28 Begin Action SetToolsComponentSelection:
14:17:28 End Action SetToolsComponentSelection:
14:17:28 Begin Action ProcessComponentSelection:
14:17:28 End Action ProcessComponentSelection
14:17:28 Begin Action LogSelectedComponents:
14:17:28 SQLProg
14:17:28 SQLProg\SQLServr
14:17:28 SQLProg\SQLServr\Help
14:17:28 SQLProg\SQLServr\SCMDev
14:17:28 SQLProg\SQLServr\SCMDev\SCMh
14:17:28 SQLProg\SQLServr\SCMDev\SCMX86Lb
14:17:28 SQLProg\SQLServr\SCMDev\SCMALb
14:17:28 SQLProg\SQLServr\Rs1033
14:17:28 SQLProg\SQLServr\RsIntl
14:17:28 SQLProg\SQLServr\ActiveX
14:17:28 SQLProg\SQLServr\System
14:17:28 SQLProg\UpgTools
14:17:28 SQLProg\UpgTools\UpgSys
14:17:28 SQLProg\UpgTools\ActiveX
14:17:28 SQLProg\UpgTools\Res1033
14:17:28 SQLProg\UpgTools\ResOther
14:17:28 SQLProg\UpgTools\Resld
14:17:28 SQLProg\ReplSupp
14:17:28 SQLProg\ReplSupp\ReplDat
14:17:28 SQLProg\ReplSupp\RepComm
14:17:28 SQLProg\ReplSupp\RepNoDk
14:17:28 SQLProg\ReplSupp\ActiveX
14:17:28 SQLProg\Install
14:17:28 SQLProg\System
14:17:28 SQLProg\SvrExt
14:17:28 SQLProg\SvrExt\Help
14:17:28 SQLProg\SvrExt\SvrExtRs
14:17:28 SQLProg\SvrExt\ResIntl
14:17:28 SQLProg\Dat
14:17:28 SQLProg\DatSmpl
14:17:28 SQLProg\BaseSys
14:17:28 SQLProg\BaseBinn
14:17:28 SQLProg\BaseInst
14:17:28 SQLProg\Symbols
14:17:28 SQLProg\Symbols\EXE
14:17:28 SQLProg\Symbols\DLL
14:17:28 SQLProg\Perfmon
14:17:28 SQLProg\Perfmon\System
14:17:28 SQLProg\Root
14:17:28 MgtTool
14:17:28 MgtTool\SEM
14:17:28 MgtTool\SEM\HTML
14:17:28 MgtTool\SEM\MSD98
14:17:28 MgtTool\SEM\MSD98SYS
14:17:28 MgtTool\SEM\MSD98Res
14:17:28 MgtTool\SEM\MSD98Hlp
14:17:28 MgtTool\SEM\Help
14:17:28 MgtTool\SEM\Res1033
14:17:28 MgtTool\SEM\ResIntl
14:17:28 MgtTool\SEM\MSD98RsI
14:17:28 MgtTool\SEM\ActiveX
14:17:28 MgtTool\SEM\ActiveX\Res1033
14:17:28 MgtTool\SEM\ActiveX\ResIntl
14:17:28 MgtTool\SEM\Scripts
14:17:28 MgtTool\SEM\OLEDB
14:17:28 MgtTool\SEM\OLEDB\Res1033
14:17:28 MgtTool\SEM\OLEDB\ResIntl
14:17:28 MgtTool\Profiler
14:17:28 MgtTool\Profiler\Help
14:17:28 MgtTool\Profiler\Res1033
14:17:28 MgtTool\Profiler\ResIntl
14:17:28 MgtTool\Qryanlz
14:17:28 MgtTool\Qryanlz\Help
14:17:28 MgtTool\Qryanlz\Res1033
14:17:28 MgtTool\Qryanlz\ResIntl
14:17:28 MgtTool\DTCCLi
14:17:28 MgtTool\Wzcnflct
14:17:28 MgtTool\Wzcnflct\WzcnHlp
14:17:28 MgtTool\Wzcnflct\Wzcn1033
14:17:28 MgtTool\Wzcnflct\WzcnOthr
14:17:28 MgtTool\Wzcnflct\WzcnCmn
14:17:28 MgtTool\UtilSys
14:17:28 MgtTool\UtilBinn
14:17:28 Connect
14:17:28 Connect\ConnSys
14:17:28 Books
14:17:28 Books\Bookso
14:17:28 Books\Bookso\Utils
14:17:28 DevTools
14:17:28 DevTools\Dbg Int
14:17:28 DevTools\Dbg Int\Dbg Int Common
14:17:28 DevTools\Dbg Int\EXE
14:17:28 CoreRepl
14:17:28 CoreRepl\Res1033
14:17:28 CoreRepl\ResIntl
14:17:28 Core
14:17:28 Core\Res1033
14:17:28 Core\ResOther
14:17:28 Repostry
14:17:28 Repostry\RepstSys
14:17:28 Repostry\Res1033
14:17:28 Repostry\ResIntl
14:17:28 CoreMisc
14:17:28 CoreMisc\ActiveX
14:17:28 CoreMisc\ActiveX\Res1033
14:17:28 CoreMisc\ActiveX\ResIntl
14:17:28 CoreMisc\Res1033
14:17:28 Monarch
14:17:28 Monarch\Monr1033
14:17:28 Monarch\MonrIntl
14:17:28 Jet
14:17:28 CoreInst
14:17:28 CoreCOM
14:17:28 CoreCOM\Res1033
14:17:28 CoreCOM\ResIntl
14:17:28 CoreTool
14:17:28 CoreTool\Res1033
14:17:28 CoreTool\ResOther
14:17:28 DBLibCli
14:17:28 SFExt
14:17:28 SFExt\ActiveX
14:17:28 SFExt\ActiveX\Res1033
14:17:28 SFExt\ActiveX\ResIntl
14:17:28 SFExt\Res1033
14:17:28 SFExt\ResIntl
14:17:28 Trace
14:17:28 Trace\Res1033
14:17:28 Trace\ResOther
14:17:28 MiscCore
14:17:28 MC
14:17:28 MC\MC1033
14:17:28 MC\MCIntl
14:17:28 MC\Help
14:17:28 SQLMgr
14:17:28 SQLMgr\Res1033
14:17:28 SQLMgr\ResIntl
14:17:28 SvrTool
14:17:28 SvrTool\Res1033
14:17:28 SvrTool\ResIntl
14:17:28 DTSUI
14:17:28 DTSUI\Res1033
14:17:28 DTSUI\ResIntl
14:17:28 MSOlap
14:17:28 MSOlap\Res1033
14:17:28 MSOlap\ResIntl
14:17:28 ATL
14:17:28 ATL\winnt
14:17:28 ATL\win9x
14:17:28 MFC42U
14:17:28 VC
14:17:28 VB
14:17:28 OCX1
14:17:28 SQLAdHlp
14:17:28 SQLAdHlp\Res1033
14:17:28 SQLAdHlp\ResOther
14:17:28 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:17:28 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:17:28 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:17:28 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:17:28 End Action LogSelectedComponents
14:17:28 SQL program folder: C:\Program Files\Microsoft SQL Server\MSSQL
14:17:28 SQL data folder: E:\MSSQL
14:17:28 Windows system folder: C:\WINDOWS\system32\
14:17:28 Prog req: 38073, Data req: 34432, Sys req: 96636
14:17:28 Prog avail: 7260083, Data avail: 50645036, Sys avail: 7260083
14:17:28 Prog req vs. avail, 134709, 7260083
14:17:28 Data req vs. avail, 34432, 50645036
14:17:28 Sys req vs. avail, 96636, 7260083
14:17:28 DisplaySystemPreReq
14:17:28 Begin Action InstallPkgs:
14:17:28 Begin Action: Locked Connectivity Files Check
14:17:29 ConnectivityLocked returned: 0
14:17:29 The operation completed successfully.

14:17:29 End Action: Locked Connectivity Files Check
14:17:29 Setup is installing Microsoft Data Access Components (MDAC) ...
14:17:29 C:\Software\SQL2000SP4\SQL2000STD\x86\Other\sqlredis.exe /q:a
14:17:35 ExitCode: 0
14:17:35 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
14:17:35 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\cldtcstp.exe -SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin" -DTCPkg "C:\Software\SQL2000SP4\SQL2000STD\x86\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log" -Silent 1
14:17:35 Process Exit Code: (0)
14:17:35 /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ixp001.tmp
14:17:35 Setup is installing HTML Help ...
14:17:35 HTML Help installer exit code: 0
14:17:49 End Action InstallPkgs
14:17:49 Begin Action MoveFileData:
14:17:49 Enabled SELFREGISTERBATCH
14:17:49 Enabled CORECOMPONENTHANDLING
14:18:31 Begin Action: MoveFileDataSpecial
14:18:32 End Action: MoveFileDataSpecial
14:18:32 End Action MoveFileData
14:18:32 Begin Action ProcessAfterDataMove:
14:18:32 C:\Software\SQL200~1\SQL200~1\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL Server\80\Tools\Books
14:18:33 End Action ProcessAfterDataMove
14:18:33 Begin Action BuildServer:
14:18:33 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
14:18:33 Process Exit Code: (0)
14:18:33 Begin Action: CreateRegistrySetSQL
14:18:33 End Action: CreateRegistrySetSQL
14:18:33 Begin Action: RegWriteSetupEntry
14:18:33 End Action: RegWriteSetupEntry
14:18:33 Begin Action: CreateSer
14:18:33 End Action: CreateSer
14:18:33 Begin Action: SkuIt
14:18:33 End Action: SkuIt
14:18:33 SetFileSecuritySQLAndAdmin for E:\MSSQL returned: 0, 0
14:18:34 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
14:18:34 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
14:18:34 Begin Action: UpdateSystemPath
14:18:34 Path successfully updated.
14:18:34 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
14:18:34 End Action: UpdateSystemPath
14:18:34 Grant Right for MUTUAL\SV-branchsql returned : 1, 0
14:18:34 Grant Right for MUTUAL\SV-branchsql returned : 1, 0
14:18:34 Grant Right for MUTUAL\SV-branchsql returned : 1, 0
14:18:34 Grant Right for MUTUAL\SV-branchsql returned : 1, 0
14:18:35 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 196814 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1053)

SQL Server configuration failed.

###############################################################################

14:23:31 Process Exit Code: (-1)
14:23:31 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
14:23:31 Action CleanUpInstall:
14:23:31 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
14:23:31 Process Exit Code: (1060) The specified service does not exist as an installed service.

14:23:31 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
14:23:51 Process Exit Code: (0)
14:23:51 StatsGenerate returned: 2
14:23:51 StatsGenerate (0x0,0x21,0xf00,0x100,1033,303,0x0,0x1,0,0,0
14:23:51 StatsGenerate -1,Administrator)
14:23:51 Installation Failed.

 

[SQLBill]

I could be wrong, but....

14:18:35 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 196814 -U sa -P

That line appears to show that the service is trying to start using the SA account with a blank password.

1. it's a bad thing to have a blank password for the SA account
2. the SA account shouldn't be used for the services

Again, I might not be reading that correctly.

-SQLBill

Posting advice: FAQ481-4875

 

[moonshadow]

You are correct. However, as I understand it, cnfgsvr.exe is starting SQL Server up for the first time, in order to change the password and configure it as per our requirements - this is part of the installation. We do not have a blank password for our SA accounts. In fact, once we've got all these servers built, I shall have a job that changes the SA password every week.

 

[mrdenny]

I have the exact line in my sqlstp.logs. That does appear to be when the SQL Server is comming up for the first time, hense the blank password.

Try to monitor the processes when doing the install. See if you can see the sqlservr.exe actually running. If should show up in task manager. Is the firewall started and blocking the processes from listening?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[moonshadow]

If it were a firewall problem, why would it work on the third set of identical disks?
Unfortunately, as the servers are being built remotely, I can't access the machine during the installation process.
We have built about 10 more servers without further problems. The only difference is that the engineers are plugging the machines into a 100MB switch as opposed to some old ropey 10MB hubs. I don't really understand why that would make a difference.

 

[gmmastros]

This may not be the problem, but it's easy to check.

Security Policies must allow unsigned driver installation.

In the Control Panel, open "Administrative Tools"
Open "Local Security Policies"
Expand "Local Policies"
Click on "Security Option"

On Windows 2000
Make sure "Unsigned non-driver installation behavior" is set to "Silently Succeed"

On Windows 2003 and Windows XP
Make sure "Devices: Unsigned driver installation behavior" is set to "Silently Succeed"


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom