MSDE 2000 Release A不会说话

如果有效，那么问题可能就是服务经理本身 （可能如上文所述）。如果你可以连接，你可以 然后用这个查询检查版本： 1>选择@@版本 2> go 如果你没有看到版本8.00.760，那么你没有SP3a，所以我会 完全删除MSDE然后安装MSDE SP3a。请参阅删除所有已知的 SQL Server实例。在本文中： http://support.microsoft.com/default...91&Product=sql 如果无法连接osql.exe，然后你得到什么错误信息？然而，在最后的分析中，我建议服务器管理器是一个小的，不需要b $ b不重要的组件，可能不值得担心。只要 MSDE正在运行，你可以从没有 问题的客户端应用程序连接，那么我就不会花太多时间试图让它工作。 关于从不同的PC（使用Access或任何其他工具）进行连接， 存在许多可能的连接问题： http://support.microsoft .com / default ... 06& Product = sql 我想当你说同行时你的意思是PC在一个工作组中，而不是一个 域。如果是这种情况，那么可信连接可能很尴尬 - 上面的 文章有一个指向另一篇知识库文章的链接，该文章描述了可能的 解决方法。使用SQL登录的混合安全性应该可以正常工作，但除非没有其他选择，否则通常不建议使用。 Simon http://www.microsoft.com/downloa ds / d ... DisplayLang = zh 可以在Microsoft SQL Server 2000桌面上找到更多信息 引擎 （MSDE 2000）发布自述文件 http://download.microsoft.com/downlo...eMSDE2000A.htm SQL Server 2000桌面引擎的增加（MSDE）发布A ReadmeMSDE2000A.htm文件 http://support.microsoft.com/?kbid=829925 Dan MSDE 2000 Release A installed under windows 2000 pro will notcommunicate with SQL Server Manager nor MS Access on peer computer.Can someone help?Have set DISABLENETWORKPROTOCOLS=0 at install time.Install log shows installation successful..Control Panel> Admin Tools> Services section shows SQL server instancerunning.Disabling firewall has no effect.SQL Server Manager (icon at bottom right in task tray - thisstarts/stops Server instances), on same computer as SQL Serverinstance, shows only instance "H" which is the same as the computername. (This instance was uninstalled before new instance wasinstalled.) Typing new instance name ("H\ABC" and variations) intotop combo box produces error messages such as "wrong format for name","Network path not found" "RPC service not running". What is thecorrect computer/name format?? Key problem is clearly that ServiceManager can''t communicate with this local MSDE instance.All Windows 2000 updates from MS web site have been installed.Objective is to operate MS Access on computer X (also running Win 2000Pro) with computer H as a peer that hosts MSDE.Has anyone else run MSDE 2000 Release A on a Windows 2000 Pro system??---Mark Ferguson 解决方案I must admit that I don''t know the difference between MSDE Release A andMSDE SP3a. There is no clear information on the MS site (or at least Icouldn''t find it), but the download sizes are different, so the obviousconclusion is that they are different versions. If this assumption iscorrect, then you might be seeing this issue: http://support.microsoft.com/default...10&Product=sqlHowever, I could be wrong, so perhaps you can check some more things. Canyou actually connect to the instance on H using a local osql.exe commandalso on H? If you''re logged on to Windows as an administrator, then thisshould be enough:osql -S H\ABC -EIf that works, then presumably the problem is the Service Manager itself(possibly as described in the article above). If you can connect, you canthen check the version with this query:1> select @@version2> goIf you don''t see version 8.00.760, then you don''t have SP3a, so I wouldcompletely remove MSDE and then install MSDE SP3a. See "Remove all knowninstances of SQL Server" in this article: http://support.microsoft.com/default...91&Product=sqlIf you cannot connect with osql.exe, then what error message do you get? Inthe final analysis, however, I would suggest that Server Manager is a small,unimportant component which probably is not worth worrying about. As long asMSDE is running and you can connect from client applications with noproblems, then I would not spend too much time trying to make it work.Regarding connecting from a different PC (with Access or any other tool),there are a number of possible connection issues: http://support.microsoft.com/default...06&Product=sqlI guess when you say "peer" you mean that the PCs are in a workgroup, not adomain. If this is the case, then trusted connections can be awkward - thearticle above has a link to another KB article which describes a possibleworkaround. Mixed security using SQL logins should work fine, but is notgenerally recommended unless there is no other alternative.Simon http://www.microsoft.com/downloads/d...DisplayLang=enAdditional information can be found in the Microsoft SQL Server 2000 DesktopEngine(MSDE 2000) Release A ReadMe http://download.microsoft.com/downlo...eMSDE2000A.htmAdditions to the SQL Server 2000 Desktop Engine (MSDE) Release AReadmeMSDE2000A.htm File http://support.microsoft.com/?kbid=829925Dan 这篇关于MSDE 2000 Release A不会说话的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！