We are having a problem in installing SQL Server 2000 (Enterprise
Edition) on a Windows 2003 Server Standard edition. When we try and
install SQL Server 2000 everything seems to be
going fine except towards the end we get an error message saying :
"Setup failed to configure the server. Refer to the server logs and
C:\Documents and Settings\Administrator\Windows\sqlstp.log for more
information.". 

1. We can confirm that the Windows 2003 server is a standard edition
and NOT web edition.

2. We have found the following MSDN article but it has not helped us
fix the problem http://support.microsoft.com/default.aspx?scid=kb;en-us;816499.

3. We are installing it under a user called root (which is the orignal
administrator account) and can confirm that root is a memeber of the
administrator.

4. It does not matter if we select SQL security as Windows or Mixed Mode.


5. The following shows the part of the log which has the
failure statment. See log entry made at 09:54:17.

09:52:57 End Action: Locked Connectivity Files Check
09:52:57 Setup is installing Microsoft Data Access Components (MDAC) ...
09:52:57 C:\APPS\ENT\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
09:53:10 ExitCode: 0
09:53:10 Setup is installing Microsoft Distributed Transaction
Coordinator (MSDTC) ...
09:53:10  C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\SqlSetup\Bin\cldtcstp.exe
-SupportDir "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\SqlSetup\Bin"
-DTCPkg "C:\APPS\ENT\x86\Other\dtcsetup.exe" -LogFile "C:\Documents
and Settings\Administrator\WINDOWS\sqlstp.log"
09:53:10 Process Exit Code: (0) 
09:53:10 InstallMSSearch instance: MSSQLSERVER
09:53:10 Software\Microsoft\Search\Install:Version not present
09:53:10 MSSearch 2.0 or greater version check returned -1
09:53:10 Setup is installing the Microsoft Full-Text Search Engine ...
09:53:10  "C:\APPS\ENT\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer
09:53:24 Process Exit Code: (0) 
09:53:24  /Q:A /T:C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\ixp001.tmp
09:53:24 Setup is installing HTML Help ...
09:53:24 HTML Help installer exit code: 0
09:53:46 End Action InstallPkgs
09:53:46 Begin Action MoveFileData:
09:53:46 Enabled SELFREGISTERBATCH
09:53:46 Enabled CORECOMPONENTHANDLING
09:54:12 Begin Action:  MoveFileDataSpecial
09:54:13 End Action:  MoveFileDataSpecial
09:54:13 End Action   MoveFileData
09:54:13 Begin Action ProcessAfterDataMove:
09:54:13 C:\APPS\ENT\x86\Binn\hhcol.exe C:\Program Files\Microsoft SQL
Server\80\Tools\Books
09:54:15 End Action   ProcessAfterDataMove
09:54:15 Begin Action BuildServer:
09:54:15 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe 
-Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL
Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
09:54:16 Process Exit Code: (0) 
09:54:16 Begin Action: CreateRegistrySetSQL
09:54:16 End Action: CreateRegistrySetSQL
09:54:16 Begin Action: RegWriteSetupEntry
09:54:16 End Action: RegWriteSetupEntry
09:54:16 Begin Action: CreateSer
09:54:16 End Action: CreateSer
09:54:16 Begin Action: SkuIt
09:54:16 End Action: SkuIt
09:54:16 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
09:54:16 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
09:54:16 Begin Action: UpdateSystemPath
09:54:16 Path successfully updated.
09:54:16 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN
09:54:16 End Action: UpdateSystemPath
09:54:17 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe  -F "C:\Documents and
Settings\Administrator\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 262308 -U sa -P
09:54:17 Process Exit Code: (193) 
09:54:23 Setup failed to configure the server.   Refer to the server
error logs and C:\Documents and
Settings\Administrator\WINDOWS\sqlstp.log for more information.
09:54:23 Action CleanUpInstall:
09:54:23 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe 
-Silent 1 -Action 4 -Service SQLSERVERAGENT
09:54:23 Process Exit Code: (1060) The specified service does not
exist as an installed service.


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