各位大虾,你们好。我的情况是这样的:一开始是成功安装了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.请各位帮我想想解决方法是怎样的,万分感谢!!

解决方案 »

  1.   


    很难很复杂.又改我的?NND.
      

  2.   

    1、MSDE的默认安装未加载TCPIP,要的话需要写一下setup.ini,加上下条
    [Options]
    DISABLENETWORKPROTOCOLS=02、默认实例名(同机器名)不可用,可能与上次安装后卸载不完整有关。比较简单的处理方法是在setup.ini中另指定一个实例名,只要和机器名不一样就行
    [Options]
    INSTANCENAME=server123
      

  3.   

    sziss ,谢谢你的回复,不过我按你说的操作了,还是一样的问题哦,安装不了
      

  4.   

    将 MSDE 的安装目录清空,如果还不行,重做系统,记得清空安装目录,呵呵!