各位大虾,你们好。我的情况是这样的:一开始是成功安装了MSDE,本机可以成功启动服务,数据库也可以正常访问,但是其他电脑连接不上本机的数据库,网络是通的,也没有防火墙,我telnet 127.0.0.1 1433端口是失败的,也用netstat查过确实本机是没有开放1433端口。后来在网上查询过,有人说是因为版本的原因,我这个版本是8.00.194.0的,要升级到SP3或者SP4,我去打补丁时系统又提示“指定的实例名称无效”,装不了SP4。
最后没办法了,我就卸载掉MSDE,再把注册表里的mssql server和microsoft sql server 等相关的删掉,然后安装8.00.2039版本的MSDE,可是每次安装到最后一秒时,都是提示“setup failed to configure the server.Refer to the server error logs and setup error logs for more information.”,点确定后进度条就自动退回去了。
我把日志文件的内容也附上:
2008-02-27 01:10:49.54 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)2008-02-27 01:10:49.56 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-02-27 01:10:49.56 server All rights reserved.
2008-02-27 01:10:49.56 server Server Process ID is 3080.
2008-02-27 01:10:49.56 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2008-02-27 01:10:49.59 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-02-27 01:10:49.71 server SQL Server configured for thread mode processing.
2008-02-27 01:10:49.74 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2008-02-27 01:10:49.93 spid3 Warning ******************
2008-02-27 01:10:49.93 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2008-02-27 01:10:49.93 spid3 Starting up database 'master'.
2008-02-27 01:10:50.24 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-02-27 01:10:50.24 spid5 Starting up database 'model'.
2008-02-27 01:10:50.26 spid3 Server name is '01HOST'.
2008-02-27 01:10:50.26 spid3 Skipping startup of clean database id 5
2008-02-27 01:10:50.28 spid3 Skipping startup of clean database id 6
2008-02-27 01:10:50.28 spid3 Starting up database 'msdb'.
2008-02-27 01:10:50.65 server SQL server listening on Shared Memory.
2008-02-27 01:10:50.65 server SQL Server is ready for client connections
2008-02-27 01:10:50.68 spid5 Clearing tempdb database.
2008-02-27 01:10:51.21 spid5 Starting up database 'tempdb'.
2008-02-27 01:10:51.31 spid3 Warning ******************
2008-02-27 01:10:51.31 spid3 Attempting to change default collation to Chinese_PRC_CI_AS.
2008-02-27 01:10:54.21 spid3 Clustered index restored for master.sysdatabases.
2008-02-27 01:10:54.26 spid3 Non-clustered index restored for master.sysobjects.
2008-02-27 01:10:54.28 spid3 Non-clustered index restored for master.sysobjects.
2008-02-27 01:10:54.31 spid3 index restored for master.syscolumns.
2008-02-27 01:10:54.34 spid3 index restored for master.systypes.
2008-02-27 01:10:54.34 spid3 index restored for master.sysusers.
2008-02-27 01:10:54.53 spid3 index restored for master.sysproperties.
2008-02-27 01:10:54.56 spid3 index restored for master.sysfulltextcatalogs.
2008-02-27 01:10:54.67 spid3 index restored for master.sysxlogins.
2008-02-27 01:10:54.68 spid3 index restored for master.sysdevices.
2008-02-27 01:10:54.75 spid3 index restored for master.sysservers.
2008-02-27 01:10:54.76 spid3 index restored for master.syslanguages.
2008-02-27 01:10:55.99 spid3 index restored for master.syscharsets.
2008-02-27 01:10:56.01 spid3 index restored for master.sysfilegroups.
2008-02-27 01:10:56.29 spid3 index restored for master.spt_values.
2008-02-27 01:10:56.45 spid3 index restored for master.MSreplication_options.
2008-02-27 01:10:56.53 spid3 index restored for master.spt_datatype_info_ext.
2008-02-27 01:10:56.56 spid3 index restored for master.spt_datatype_info.
2008-02-27 01:10:56.81 spid3 Non-clustered index restored for tempdb.sysobjects.
2008-02-27 01:10:56.82 spid3 Non-clustered index restored for tempdb.sysobjects.
2008-02-27 01:10:56.84 spid3 index restored for tempdb.syscolumns.
2008-02-27 01:10:56.85 spid3 index restored for tempdb.systypes.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysusers.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysproperties.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysfulltextcatalogs.
2008-02-27 01:10:56.98 spid3 index restored for tempdb.sysfilegroups.
2008-02-27 01:10:57.03 spid3 Non-clustered index restored for model.sysobjects.
2008-02-27 01:10:57.04 spid3 Non-clustered index restored for model.sysobjects.
2008-02-27 01:10:57.07 spid3 index restored for model.syscolumns.
2008-02-27 01:10:57.09 spid3 index restored for model.systypes.
2008-02-27 01:10:57.14 spid3 index restored for model.sysusers.
2008-02-27 01:10:57.14 spid3 index restored for model.sysproperties.
2008-02-27 01:10:57.15 spid3 index restored for model.sysfulltextcatalogs.
2008-02-27 01:10:57.15 spid3 index restored for model.sysfilegroups.
2008-02-27 01:10:57.31 spid3 Non-clustered index restored for msdb.sysobjects.
2008-02-27 01:10:57.31 spid3 Non-clustered index restored for msdb.sysobjects.
2008-02-27 01:10:57.32 spid3 index restored for msdb.syscolumns.
2008-02-27 01:10:57.32 spid3 index restored for msdb.systypes.
2008-02-27 01:10:57.32 spid3 index restored for msdb.sysusers.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysproperties.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysfulltextcatalogs.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysfilegroups.
2008-02-27 01:10:57.35 spid3 index restored for msdb.sysjobschedules.
2008-02-27 01:10:57.40 spid3 index restored for msdb.syscategories.
2008-02-27 01:10:57.40 spid3 index restored for msdb.systargetservers.
2008-02-27 01:10:57.40 spid3 index restored for msdb.systargetservergroups.
2008-02-27 01:10:58.48 spid3 index restored for msdb.sysalerts.
2008-02-27 01:10:58.48 spid3 index restored for msdb.sysoperators.
2008-02-27 01:10:58.48 spid3 index restored for msdb.syscachedcredentials.
2008-02-27 01:10:58.51 spid3 index restored for msdb.loghistory.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdtscategories.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdbmaintplan_databases.
2008-02-27 01:10:58.53 spid3 index restored for msdb.mswebtasks.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdownloadlist.
2008-02-27 01:10:58.54 spid3 index restored for msdb.sysjobs.
2008-02-27 01:10:58.54 spid3 index restored for msdb.sysjobsteps.
2008-02-27 01:10:59.87 spid3 Default collation successfully changed.
2008-02-27 01:10:59.90 spid3 Recovery complete.
2008-02-27 01:10:59.90 spid3 SQL global counter collection task is created.
2008-02-27 01:10:59.93 spid3 Warning: override, autoexec procedures skipped.
2008-02-27 01:12:54.68 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.请各位帮我想想解决方法是怎样的,万分感谢!!
最后没办法了,我就卸载掉MSDE,再把注册表里的mssql server和microsoft sql server 等相关的删掉,然后安装8.00.2039版本的MSDE,可是每次安装到最后一秒时,都是提示“setup failed to configure the server.Refer to the server error logs and setup error logs for more information.”,点确定后进度条就自动退回去了。
我把日志文件的内容也附上:
2008-02-27 01:10:49.54 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)2008-02-27 01:10:49.56 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-02-27 01:10:49.56 server All rights reserved.
2008-02-27 01:10:49.56 server Server Process ID is 3080.
2008-02-27 01:10:49.56 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2008-02-27 01:10:49.59 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-02-27 01:10:49.71 server SQL Server configured for thread mode processing.
2008-02-27 01:10:49.74 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2008-02-27 01:10:49.93 spid3 Warning ******************
2008-02-27 01:10:49.93 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2008-02-27 01:10:49.93 spid3 Starting up database 'master'.
2008-02-27 01:10:50.24 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-02-27 01:10:50.24 spid5 Starting up database 'model'.
2008-02-27 01:10:50.26 spid3 Server name is '01HOST'.
2008-02-27 01:10:50.26 spid3 Skipping startup of clean database id 5
2008-02-27 01:10:50.28 spid3 Skipping startup of clean database id 6
2008-02-27 01:10:50.28 spid3 Starting up database 'msdb'.
2008-02-27 01:10:50.65 server SQL server listening on Shared Memory.
2008-02-27 01:10:50.65 server SQL Server is ready for client connections
2008-02-27 01:10:50.68 spid5 Clearing tempdb database.
2008-02-27 01:10:51.21 spid5 Starting up database 'tempdb'.
2008-02-27 01:10:51.31 spid3 Warning ******************
2008-02-27 01:10:51.31 spid3 Attempting to change default collation to Chinese_PRC_CI_AS.
2008-02-27 01:10:54.21 spid3 Clustered index restored for master.sysdatabases.
2008-02-27 01:10:54.26 spid3 Non-clustered index restored for master.sysobjects.
2008-02-27 01:10:54.28 spid3 Non-clustered index restored for master.sysobjects.
2008-02-27 01:10:54.31 spid3 index restored for master.syscolumns.
2008-02-27 01:10:54.34 spid3 index restored for master.systypes.
2008-02-27 01:10:54.34 spid3 index restored for master.sysusers.
2008-02-27 01:10:54.53 spid3 index restored for master.sysproperties.
2008-02-27 01:10:54.56 spid3 index restored for master.sysfulltextcatalogs.
2008-02-27 01:10:54.67 spid3 index restored for master.sysxlogins.
2008-02-27 01:10:54.68 spid3 index restored for master.sysdevices.
2008-02-27 01:10:54.75 spid3 index restored for master.sysservers.
2008-02-27 01:10:54.76 spid3 index restored for master.syslanguages.
2008-02-27 01:10:55.99 spid3 index restored for master.syscharsets.
2008-02-27 01:10:56.01 spid3 index restored for master.sysfilegroups.
2008-02-27 01:10:56.29 spid3 index restored for master.spt_values.
2008-02-27 01:10:56.45 spid3 index restored for master.MSreplication_options.
2008-02-27 01:10:56.53 spid3 index restored for master.spt_datatype_info_ext.
2008-02-27 01:10:56.56 spid3 index restored for master.spt_datatype_info.
2008-02-27 01:10:56.81 spid3 Non-clustered index restored for tempdb.sysobjects.
2008-02-27 01:10:56.82 spid3 Non-clustered index restored for tempdb.sysobjects.
2008-02-27 01:10:56.84 spid3 index restored for tempdb.syscolumns.
2008-02-27 01:10:56.85 spid3 index restored for tempdb.systypes.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysusers.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysproperties.
2008-02-27 01:10:56.89 spid3 index restored for tempdb.sysfulltextcatalogs.
2008-02-27 01:10:56.98 spid3 index restored for tempdb.sysfilegroups.
2008-02-27 01:10:57.03 spid3 Non-clustered index restored for model.sysobjects.
2008-02-27 01:10:57.04 spid3 Non-clustered index restored for model.sysobjects.
2008-02-27 01:10:57.07 spid3 index restored for model.syscolumns.
2008-02-27 01:10:57.09 spid3 index restored for model.systypes.
2008-02-27 01:10:57.14 spid3 index restored for model.sysusers.
2008-02-27 01:10:57.14 spid3 index restored for model.sysproperties.
2008-02-27 01:10:57.15 spid3 index restored for model.sysfulltextcatalogs.
2008-02-27 01:10:57.15 spid3 index restored for model.sysfilegroups.
2008-02-27 01:10:57.31 spid3 Non-clustered index restored for msdb.sysobjects.
2008-02-27 01:10:57.31 spid3 Non-clustered index restored for msdb.sysobjects.
2008-02-27 01:10:57.32 spid3 index restored for msdb.syscolumns.
2008-02-27 01:10:57.32 spid3 index restored for msdb.systypes.
2008-02-27 01:10:57.32 spid3 index restored for msdb.sysusers.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysproperties.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysfulltextcatalogs.
2008-02-27 01:10:57.34 spid3 index restored for msdb.sysfilegroups.
2008-02-27 01:10:57.35 spid3 index restored for msdb.sysjobschedules.
2008-02-27 01:10:57.40 spid3 index restored for msdb.syscategories.
2008-02-27 01:10:57.40 spid3 index restored for msdb.systargetservers.
2008-02-27 01:10:57.40 spid3 index restored for msdb.systargetservergroups.
2008-02-27 01:10:58.48 spid3 index restored for msdb.sysalerts.
2008-02-27 01:10:58.48 spid3 index restored for msdb.sysoperators.
2008-02-27 01:10:58.48 spid3 index restored for msdb.syscachedcredentials.
2008-02-27 01:10:58.51 spid3 index restored for msdb.loghistory.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdtscategories.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdbmaintplan_databases.
2008-02-27 01:10:58.53 spid3 index restored for msdb.mswebtasks.
2008-02-27 01:10:58.53 spid3 index restored for msdb.sysdownloadlist.
2008-02-27 01:10:58.54 spid3 index restored for msdb.sysjobs.
2008-02-27 01:10:58.54 spid3 index restored for msdb.sysjobsteps.
2008-02-27 01:10:59.87 spid3 Default collation successfully changed.
2008-02-27 01:10:59.90 spid3 Recovery complete.
2008-02-27 01:10:59.90 spid3 SQL global counter collection task is created.
2008-02-27 01:10:59.93 spid3 Warning: override, autoexec procedures skipped.
2008-02-27 01:12:54.68 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.请各位帮我想想解决方法是怎样的,万分感谢!!
很难很复杂.又改我的?NND.
[Options]
DISABLENETWORKPROTOCOLS=02、默认实例名(同机器名)不可用,可能与上次安装后卸载不完整有关。比较简单的处理方法是在setup.ini中另指定一个实例名,只要和机器名不一样就行
[Options]
INSTANCENAME=server123