Hi
I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP.
I continually get the error 'cannot configure server' just at the end
of the installation. I've tried the following:
- Removing SQL server from 'Program Files' folder following an
unsuccessful attempt to re-install, and entirely removing the registry
entry 'HKEY_CURRENT_U SER > SOFTWARE > Microsoft > MSSQLServer', as
well as the corresponding entry under 'HKEY_LOCAL_MAC HINE'. I've also
ensured that there is nothing left under
'HKEY_LOCAL_MAC HINE\SOFTWARE\M icrosoft\Window s\CurrentVersio n\Setup\Excepti on
Components'.
- Creating a different named instance of SQL server during re-install
(as opposed to the default)
- Have ensured that I have not installed Certificate Server (I know
that this can cause problems with SQL 2000 installation)
- Have tried installing MDAC components 2.6 SP2 and 2.8 (2.8 didn't
work at all, as I'm running XP. I did manage to install MDAC 2.6 SP2
but it didn't help)
- Have tried altering the desired SQL server authentication method
during install (i.e. altering between Windows authentication and SQL
authentication)
- Have tried installing SQL 2000 SP3 prior to installing SQL itself
Help! Here is the log file for the failed install (C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG)
2004-10-18 15:35:52.18 server Microsoft SQL Server 2000 - 8.00.194
(Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-10-18 15:35:52.18 server Copyright (C) 1988-2000 Microsoft
Corporation.
2004-10-18 15:35:52.18 server All rights reserved.
2004-10-18 15:35:52.18 server Server Process ID is 3624.
2004-10-18 15:35:52.18 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\lo g\ERRORLOG'.
2004-10-18 15:35:52.20 server SQL Server is starting at priority
class 'normal'(1 CPU detected).
2004-10-18 15:35:52.24 server SQL Server configured for thread mode
processing.
2004-10-18 15:35:52.25 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2004-10-18 15:35:52.26 server Attempting to initialize Distributed
Transaction Coordinator.
2004-10-18 15:35:52.51 server Failed to obtain
TransactionDisp enserInterface: Result Code = 0x8004d01b
2004-10-18 15:35:52.51 spid3 Warning *************** ***
2004-10-18 15:35:52.51 spid3 SQL Server started in single user
mode. Updates allowed to system catalogs.
2004-10-18 15:35:52.51 spid3 Starting up database 'master'.
2004-10-18 15:35:53.06 spid3 Server name is 'CHRISHALCROW'.
2004-10-18 15:35:53.06 server Using 'SSNETLIB.DLL' version
'8.0.194'.
2004-10-18 15:35:53.06 spid5 Starting up database 'model'.
2004-10-18 15:35:53.17 spid7 Starting up database 'msdb'.
2004-10-18 15:35:53.29 spid8 Starting up database 'pubs'.
2004-10-18 15:35:53.39 spid9 Starting up database 'Northwind'.
2004-10-18 15:35:54.49 server SQL server listening on Shared
Memory, Named Pipes.
2004-10-18 15:35:54.49 server SQL Server is ready for client
connections
2004-10-18 15:35:54.59 spid5 Clearing tempdb database.
2004-10-18 15:35:56.76 spid5 Starting up database 'tempdb'.
2004-10-18 15:35:57.00 spid3 Warning *************** ***
2004-10-18 15:35:57.00 spid3 Attempting to change default
collation to Latin1_General_ CI_AS.
2004-10-18 15:36:03.95 spid3 Clustered index restored for
master.sysdatab ases.
2004-10-18 15:36:04.17 spid3 Non-clustered index restored for
master.sysobjec ts.
2004-10-18 15:36:04.23 spid3 Non-clustered index restored for
master.sysobjec ts.
2004-10-18 15:36:04.35 spid3 index restored for
master.syscolum ns.
2004-10-18 15:36:04.35 spid3 index restored for master.systypes .
2004-10-18 15:36:04.36 spid3 index restored for master.sysusers .
2004-10-18 15:36:04.90 spid3 index restored for
master.sysprope rties.
2004-10-18 15:36:04.92 spid3 index restored for
master.sysfullt extcatalogs.
2004-10-18 15:36:05.10 spid3 index restored for
master.sysxlogi ns.
2004-10-18 15:36:05.25 spid3 index restored for
master.sysdevic es.
2004-10-18 15:36:05.45 spid3 index restored for
master.sysserve rs.
2004-10-18 15:36:05.56 spid3 index restored for
master.syslangu ages.
2004-10-18 15:36:05.65 spid3 index restored for
master.syschars ets.
2004-10-18 15:36:05.69 spid3 index restored for
master.sysfileg roups.
2004-10-18 15:36:06.89 spid3 index restored for
master.spt_valu es.
2004-10-18 15:36:06.91 spid3 index restored for
master.spt_data type_info_ext.
2004-10-18 15:36:06.92 spid3 index restored for
master.MSreplic ation_options.
2004-10-18 15:36:06.93 spid3 index restored for
master.spt_data type_info.
2004-10-18 15:36:07.05 spid3 Non-clustered index restored for
tempdb.sysobjec ts.
2004-10-18 15:36:07.05 spid3 Non-clustered index restored for
tempdb.sysobjec ts.
2004-10-18 15:36:07.06 spid3 index restored for
tempdb.syscolum ns.
2004-10-18 15:36:07.06 spid3 index restored for tempdb.systypes .
2004-10-18 15:36:07.06 spid3 index restored for tempdb.sysusers .
2004-10-18 15:36:07.14 spid3 index restored for
tempdb.sysprope rties.
2004-10-18 15:36:07.14 spid3 index restored for
tempdb.sysfullt extcatalogs.
2004-10-18 15:36:07.14 spid3 index restored for
tempdb.sysfileg roups.
2004-10-18 15:36:07.32 spid3 Non-clustered index restored for
model.sysobject s.
2004-10-18 15:36:07.32 spid3 Non-clustered index restored for
model.sysobject s.
2004-10-18 15:36:07.41 spid3 index restored for model.syscolumn s.
2004-10-18 15:36:07.48 spid3 index restored for model.systypes.
2004-10-18 15:36:07.52 spid3 index restored for model.sysusers.
2004-10-18 15:36:07.62 spid3 index restored for
model.sysproper ties.
2004-10-18 15:36:07.62 spid3 index restored for
model.sysfullte xtcatalogs.
2004-10-18 15:36:07.63 spid3 index restored for
model.sysfilegr oups.
2004-10-18 15:36:08.84 spid3 Non-clustered index restored for
msdb.sysobjects .
2004-10-18 15:36:09.07 spid3 Non-clustered index restored for
msdb.sysobjects .
2004-10-18 15:36:09.34 spid3 index restored for msdb.syscolumns .
2004-10-18 15:36:09.39 spid3 index restored for msdb.systypes.
2004-10-18 15:36:09.47 spid3 index restored for msdb.sysusers.
2004-10-18 15:36:09.58 spid3 index restored for
msdb.syspropert ies.
2004-10-18 15:36:09.60 spid3 index restored for
msdb.sysfulltex tcatalogs.
2004-10-18 15:36:09.63 spid3 index restored for
msdb.sysfilegro ups.
2004-10-18 15:36:09.66 spid3 index restored for
msdb.sysjobsche dules.
2004-10-18 15:36:09.69 spid3 index restored for
msdb.syscategor ies.
2004-10-18 15:36:09.74 spid3 index restored for
msdb.systargets ervers.
2004-10-18 15:36:09.74 spid3 index restored for
msdb.systargets ervergroups.
2004-10-18 15:36:09.76 spid3 index restored for
msdb.RTblDataba seVersion.
2004-10-18 15:36:09.86 spid3 index restored for msdb.sysalerts.
2004-10-18 15:36:09.87 spid3 index restored for
msdb.sysoperato rs.
2004-10-18 15:36:09.87 spid3 index restored for
msdb.syscachedc redentials.
2004-10-18 15:36:09.93 spid3 index restored for
msdb.logmarkhis tory.
2004-10-18 15:36:10.17 spid3 index restored for
msdb.RTblNamedO bj.
2004-10-18 15:36:10.28 spid3 index restored for
msdb.sysdtscate gories.
2004-10-18 15:36:10.28 spid3 index restored for
msdb.sysdbmaint plan_databases.
2004-10-18 15:36:10.28 spid3 index restored for msdb.mswebtasks .
2004-10-18 15:36:10.34 spid3 index restored for msdb.RTblProps.
2004-10-18 15:36:10.41 spid3 index restored for
msdb.RTblRelshi pProps.
2004-10-18 15:36:10.41 spid3 index restored for
msdb.sysdownloa dlist.
2004-10-18 15:36:10.42 spid3 index restored for msdb.sysjobs.
2004-10-18 15:36:10.43 spid3 index restored for msdb.sysjobstep s.
2004-10-18 15:36:10.69 spid3 Non-clustered index restored for
pubs.sysobjects .
2004-10-18 15:36:10.73 spid3 Non-clustered index restored for
pubs.sysobjects .
2004-10-18 15:36:10.84 spid3 index restored for pubs.syscolumns .
2004-10-18 15:36:10.90 spid3 index restored for pubs.systypes.
2004-10-18 15:36:10.91 spid3 index restored for pubs.sysusers.
2004-10-18 15:36:10.91 spid3 index restored for
pubs.syspropert ies.
2004-10-18 15:36:10.91 spid3 index restored for
pubs.sysfulltex tcatalogs.
2004-10-18 15:36:10.91 spid3 index restored for
pubs.sysfilegro ups.
2004-10-18 15:36:11.07 spid3 index restored for pubs.titleautho r.
2004-10-18 15:36:11.20 spid3 index restored for pubs.stores.
2004-10-18 15:36:11.21 spid3 index restored for pubs.sales.
2004-10-18 15:36:11.23 spid3 index restored for pubs.roysched.
2004-10-18 15:36:11.32 spid3 index restored for pubs.pub_info.
2004-10-18 15:36:11.44 spid3 index restored for pubs.employee.
2004-10-18 15:36:11.51 spid3 index restored for pubs.authors.
2004-10-18 15:36:11.66 spid3 index restored for pubs.publishers .
2004-10-18 15:36:11.76 spid3 index restored for pubs.titles.
2004-10-18 15:36:12.06 spid3 Non-clustered index restored for
Northwind.sysob jects.
2004-10-18 15:36:12.07 spid3 Non-clustered index restored for
Northwind.sysob jects.
2004-10-18 15:36:12.26 spid3 index restored for
Northwind.sysco lumns.
2004-10-18 15:36:12.30 spid3 index restored for
Northwind.systy pes.
2004-10-18 15:36:12.30 spid3 index restored for
Northwind.sysus ers.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.syspr operties.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.sysfu lltextcatalogs.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.sysfi legroups.
2004-10-18 15:36:12.49 spid3 index restored for Northwind.Order s.
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.Produ cts.
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.Custo merCustomerDemo .
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.Custo merDemographics .
2004-10-18 15:36:12.61 spid3 index restored for
Northwind.Terri tories.
2004-10-18 15:36:12.65 spid3 index restored for
Northwind.Emplo yeeTerritories.
2004-10-18 15:36:12.68 spid3 index restored for
Northwind.Emplo yees.
2004-10-18 15:36:12.70 spid3 index restored for
Northwind.Categ ories.
2004-10-18 15:36:12.76 spid3 index restored for
Northwind.Custo mers.
2004-10-18 15:36:12.84 spid3 index restored for
Northwind.Suppl iers.
2004-10-18 15:36:15.07 spid3 Default collation successfully
changed.
2004-10-18 15:36:15.36 spid3 Recovery complete.
2004-10-18 15:36:15.46 spid3 Warning: override, autoexec
procedures skipped.
2004-10-18 15:36:23.17 spid3 SQL Server is terminating due to
'stop' request from Service Control Manager.