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_USER > SOFTWARE > Microsoft > MSSQLServer', as
well as the corresponding entry under 'HKEY_LOCAL_MACHINE'. I've also
ensured that there is nothing left under
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Cur rentVersion\Setup\Exception
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\LOG\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\log\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
TransactionDispenserInterface: 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.sysdatabases.
2004-10-18 15:36:04.17 spid3 Non-clustered index restored for
master.sysobjects.
2004-10-18 15:36:04.23 spid3 Non-clustered index restored for
master.sysobjects.
2004-10-18 15:36:04.35 spid3 index restored for
master.syscolumns.
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.sysproperties.
2004-10-18 15:36:04.92 spid3 index restored for
master.sysfulltextcatalogs.
2004-10-18 15:36:05.10 spid3 index restored for
master.sysxlogins.
2004-10-18 15:36:05.25 spid3 index restored for
master.sysdevices.
2004-10-18 15:36:05.45 spid3 index restored for
master.sysservers.
2004-10-18 15:36:05.56 spid3 index restored for
master.syslanguages.
2004-10-18 15:36:05.65 spid3 index restored for
master.syscharsets.
2004-10-18 15:36:05.69 spid3 index restored for
master.sysfilegroups.
2004-10-18 15:36:06.89 spid3 index restored for
master.spt_values.
2004-10-18 15:36:06.91 spid3 index restored for
master.spt_datatype_info_ext.
2004-10-18 15:36:06.92 spid3 index restored for
master.MSreplication_options.
2004-10-18 15:36:06.93 spid3 index restored for
master.spt_datatype_info.
2004-10-18 15:36:07.05 spid3 Non-clustered index restored for
tempdb.sysobjects.
2004-10-18 15:36:07.05 spid3 Non-clustered index restored for
tempdb.sysobjects.
2004-10-18 15:36:07.06 spid3 index restored for
tempdb.syscolumns.
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.sysproperties.
2004-10-18 15:36:07.14 spid3 index restored for
tempdb.sysfulltextcatalogs.
2004-10-18 15:36:07.14 spid3 index restored for
tempdb.sysfilegroups.
2004-10-18 15:36:07.32 spid3 Non-clustered index restored for
model.sysobjects.
2004-10-18 15:36:07.32 spid3 Non-clustered index restored for
model.sysobjects.
2004-10-18 15:36:07.41 spid3 index restored for model.syscolumns.
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.sysproperties.
2004-10-18 15:36:07.62 spid3 index restored for
model.sysfulltextcatalogs.
2004-10-18 15:36:07.63 spid3 index restored for
model.sysfilegroups.
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.sysproperties.
2004-10-18 15:36:09.60 spid3 index restored for
msdb.sysfulltextcatalogs.
2004-10-18 15:36:09.63 spid3 index restored for
msdb.sysfilegroups.
2004-10-18 15:36:09.66 spid3 index restored for
msdb.sysjobschedules.
2004-10-18 15:36:09.69 spid3 index restored for
msdb.syscategories.
2004-10-18 15:36:09.74 spid3 index restored for
msdb.systargetservers.
2004-10-18 15:36:09.74 spid3 index restored for
msdb.systargetservergroups.
2004-10-18 15:36:09.76 spid3 index restored for
msdb.RTblDatabaseVersion.
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.sysoperators.
2004-10-18 15:36:09.87 spid3 index restored for
msdb.syscachedcredentials.
2004-10-18 15:36:09.93 spid3 index restored for
msdb.logmarkhistory.
2004-10-18 15:36:10.17 spid3 index restored for
msdb.RTblNamedObj.
2004-10-18 15:36:10.28 spid3 index restored for
msdb.sysdtscategories.
2004-10-18 15:36:10.28 spid3 index restored for
msdb.sysdbmaintplan_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.RTblRelshipProps.
2004-10-18 15:36:10.41 spid3 index restored for
msdb.sysdownloadlist.
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.sysjobsteps.
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.sysproperties.
2004-10-18 15:36:10.91 spid3 index restored for
pubs.sysfulltextcatalogs.
2004-10-18 15:36:10.91 spid3 index restored for
pubs.sysfilegroups.
2004-10-18 15:36:11.07 spid3 index restored for pubs.titleauthor.
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.sysobjects.
2004-10-18 15:36:12.07 spid3 Non-clustered index restored for
Northwind.sysobjects.
2004-10-18 15:36:12.26 spid3 index restored for
Northwind.syscolumns.
2004-10-18 15:36:12.30 spid3 index restored for
Northwind.systypes.
2004-10-18 15:36:12.30 spid3 index restored for
Northwind.sysusers.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.sysproperties.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.sysfulltextcatalogs.
2004-10-18 15:36:12.31 spid3 index restored for
Northwind.sysfilegroups.
2004-10-18 15:36:12.49 spid3 index restored for Northwind.Orders.
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.Products.
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.CustomerCustomerDemo.
2004-10-18 15:36:12.59 spid3 index restored for
Northwind.CustomerDemographics.
2004-10-18 15:36:12.61 spid3 index restored for
Northwind.Territories.
2004-10-18 15:36:12.65 spid3 index restored for
Northwind.EmployeeTerritories.
2004-10-18 15:36:12.68 spid3 index restored for
Northwind.Employees.
2004-10-18 15:36:12.70 spid3 index restored for
Northwind.Categories.
2004-10-18 15:36:12.76 spid3 index restored for
Northwind.Customers.
2004-10-18 15:36:12.84 spid3 index restored for
Northwind.Suppliers.
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.
