I am trying to install MSDE 2000 Release A on a windows XP Pro that has service pack 1 and all patches already installed. No previous SQL installations exist and no SQL related folders are under program files. I have review registry and did not find any information on previous installations (and I am pretty good at registry). I a using setup sapwd=mypassword, installtion proceeds OK and towards the ending part of it, i get this message. "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
If I review the system before clicking OK, I find that MSSQL has been installed and services named MSSQLSERVER, MSSQLServerADHelper and SQLSERVERAGENT are there in the services under computer management. When I click to to the error box, SQL installation seems to rollback, both services except MSSQLServerADHelper are removed automatically. Contents of error log that I see under SQL Log folder are appended below.
One thing more that before installing MSDE I am setting security option (Devices: Unsigned driver installation behavior) to "Silently succedd" which was recommended by a Microsoft KB article. However installation failure I see that this option is automatically set to value "Warn but allow installation".
I have gone through this drill tons of times but to no avail. I do feel that this quation deserves more than 500 points. Please help!!
2004-08-16 00:31:16.64 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2004-08-16 00:31:16.65 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-08-16 00:31:16.65 server All rights reserved.
2004-08-16 00:31:16.65 server Server Process ID is 1876.
2004-08-16 00:31:16.65 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2004-08-16 00:31:16.67 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-08-16 00:31:16.87 server SQL Server configured for thread mode processing.
2004-08-16 00:31:16.87 server Using dynamic lock allocation.  Lock Blocks,  Lock Owner Blocks.
2004-08-16 00:31:17.03 spid4 Warning ******************
2004-08-16 00:31:17.03 spid4 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-08-16 00:31:17.07 spid4 Starting up database 'master'.
2004-08-16 00:31:17.93 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-08-16 00:31:17.93 spid5 Starting up database 'model'.
2004-08-16 00:31:18.06 spid4 Server name is 'RAUF'.
2004-08-16 00:31:18.06 spid4 Skipping startup of clean database id 5
2004-08-16 00:31:18.10 spid4 Skipping startup of clean database id 6
2004-08-16 00:31:18.10 spid4 Starting up database 'msdb'.
2004-08-16 00:31:18.28 server SQL server listening on Shared Memory.
2004-08-16 00:31:18.28 server SQL Server is ready for client connections
2004-08-16 00:31:18.46 spid5 Clearing tempdb database.
2004-08-16 00:31:19.09 spid5 Starting up database 'tempdb'.
2004-08-16 00:31:19.25 spid4 Recovery complete.
2004-08-16 00:31:19.25 spid4 SQL global counter collection task is created.
2004-08-16 00:31:19.29 spid4 Warning: override, autoexec procedures skipped.
2004-08-16 00:33:21.73 spid4 SQL Server is terminating due to 'stop' request from Service Control Manager.