SQL7.0安装过程中的超时错误
SQL7.0安装过程中出现提示信息:
Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information
并且在\winnt\sqlstp.log中出现这样的信息:
C:\MSSQL7\binn\cnfgsvr.exe -Silent 2 -NoSampleDB 0 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 199 -LCIDCompStyle "2052-196609" -HWND 786844 -User sa -Pwd
01:59:41 Process Exit Code: (1460) 由于超时时间已过,该操作返回。
Error Log如下:
2003-07-01 01:57:11.89 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
2003-07-01 01:57:11.90 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2003-07-01 01:57:11.90 kernel All rights reserved.
2003-07-01 01:57:11.92 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2003-07-01 01:57:12.00 kernel initconfig: Number of user connections limited to 32767.
2003-07-01 01:57:12.00 kernel SQL Server is starting at priority class 'normal'(2 CPUs detected).
2003-07-01 01:57:12.06 kernel User Mode Scheduler configured for thread processing
2003-07-01 01:57:14.26 server Directory Size: 10807
2003-07-01 01:57:14.31 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2003-07-01 01:57:14.31 kernel Attempting to initialize Distributed Transaction Coordinator.
2003-07-01 01:57:16.64 spid1 Warning ******************
2003-07-01 01:57:16.64 spid1 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-07-01 01:57:16.64 spid1 Warning ******************
2003-07-01 01:57:16.64 spid1 Starting up database 'master'.
2003-07-01 01:57:16.64 spid1 Opening file C:\MSSQL7\data\master.mdf.
2003-07-01 01:57:16.67 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2003-07-01 01:57:16.76 spid1 Loading SQL Server's Unicode collation.
2003-07-01 01:57:16.78 spid1 Loading SQL Server's non-Unicode sort order and character set.
2003-07-01 01:57:16.90 spid1 4 transactions rolled forward in database 'master' (1).
2003-07-01 01:57:16.92 spid1 0 transactions rolled back in database 'master' (1).
2003-07-01 01:57:17.03 spid1 Starting up database 'model'.
2003-07-01 01:57:17.03 spid1 Opening file C:\MSSQL7\DATA\model.mdf.
2003-07-01 01:57:17.07 spid1 Opening file c:\mssql7\data\modellog.ldf.
2003-07-01 01:57:17.17 spid1 Clearing tempdb database.
2003-07-01 01:57:17.20 spid1 Creating file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-07-01 01:57:17.39 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-07-01 01:57:17.42 spid1 Creating file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-07-01 01:57:17.54 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-07-01 01:57:17.62 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-07-01 01:57:17.64 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-07-01 01:57:18.18 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-07-01 01:57:18.20 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-07-01 01:57:18.21 spid1 Starting up database 'tempdb'.
2003-07-01 01:57:18.21 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-07-01 01:57:18.25 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-07-01 01:57:18.43 spid1 Server is unnamed.
2003-07-01 01:57:18.45 kernel Using 'SQLEVN70.DLL' version '7.00.623'.
2003-07-01 01:57:18.45 kernel Using 'OPENDS60.DLL' version '7.00.00.0623'.
2003-07-01 01:57:18.45 ods Using 'SSNMPN70.DLL' version '7.0.623' to listen on '\\.\pipe\sql\query'.
2003-07-01 01:57:18.45 ods Using 'SSMSSO70.DLL' version '7.0.623' to listen on '1433'.
2003-07-01 01:57:19.03 ods Using 'SSMSRP70.DLL' version '7.0.623' to listen on 'SERVER'.
2003-07-01 01:57:19.18 spid5 Starting up database 'msdb'.
2003-07-01 01:57:19.18 spid6 Starting up database 'pubs'.
2003-07-01 01:57:19.18 spid5 Opening file C:\MSSQL7\DATA\msdbdata.mdf.
2003-07-01 01:57:19.18 spid6 Opening file C:\MSSQL7\DATA\pubs.mdf.
2003-07-01 01:57:19.18 spid7 Starting up database 'Northwind'.
2003-07-01 01:57:19.18 spid7 Opening file C:\MSSQL7\DATA\northwnd.mdf.
2003-07-01 01:57:19.26 spid5 Opening file c:\mssql7\DATA\msdblog.ldf.
2003-07-01 01:57:19.28 spid6 Opening file c:\mssql7\DATA\pubs_log.ldf.
2003-07-01 01:57:19.29 spid7 Opening file C:\MSSQL7\DATA\northwnd.ldf.
2003-07-01 01:57:19.71 spid1 Recovery complete.
2003-07-01 01:57:19.71 spid1 SQL Server's Unicode collation is:
2003-07-01 01:57:19.73 spid1 'English' (ID = 1033).
2003-07-01 01:57:19.73 spid1 comparison style = 196609.
2003-07-01 01:57:19.73 spid1 SQL Server's non-Unicode sort order is:
2003-07-01 01:57:19.73 spid1 'nocase_iso' (ID = 52).
2003-07-01 01:57:19.73 spid1 SQL Server's non-Unicode character set is:
2003-07-01 01:57:19.73 spid1 'iso_1' (ID = 1).
2003-07-01 01:57:19.73 kernel Warning: override, autoexec procedures skipped.
2003-07-01 01:59:26.29 spid1 Closing file C:\MSSQL7\DATA\northwnd.mdf.
2003-07-01 01:59:26.32 spid1 Closing file C:\MSSQL7\DATA\northwnd.ldf.
2003-07-01 01:59:26.39 spid1 Closing file C:\MSSQL7\DATA\pubs.mdf.
2003-07-01 01:59:26.40 spid1 Closing file c:\mssql7\DATA\pubs_log.ldf.
2003-07-01 01:59:26.46 spid1 Closing file C:\MSSQL7\DATA\msdbdata.mdf.
2003-07-01 01:59:26.50 spid1 Closing file c:\mssql7\DATA\msdblog.ldf.
2003-07-01 01:59:26.53 spid1 Closing file C:\MSSQL7\DATA\model.mdf.
2003-07-01 01:59:26.54 spid1 Closing file c:\mssql7\data\modellog.ldf.
2003-07-01 01:59:26.57 kernel SQL Server is terminating due to 'stop' request from Service Control Manager.