MSDE 2000 Release A不会说话 [英] MSDE 2000 Release A won't talk
问题描述
有人可以帮忙吗？
在安装时设置了DISABLENETWORKPROTOCOLS = 0.
安装日志显示安装成功..
控制面板> ;管理工具>服务部分显示SQL服务器实例
运行。
禁用防火墙无效。
SQL Server Manager（任务托盘右下角的图标 - 这个
启动/停止服务器实例），在与SQL Server相同的计算机上实现
实例，仅显示实例H这与电脑相同
名称。 （在安装新实例
之前，已卸载此实例。）将新实例名称（H\ABC和变体）键入
顶部组合框会产生错误消息例如名称格式错误，
未找到网络路径 RPC服务未运行。什么是
正确的计算机/名称格式？关键问题显然是服务
管理员无法与此本地MSDE实例通信。
已安装MS网站的所有Windows 2000更新。
目标是在计算机X上运行MS Access（也运行Win 2000
Pro），计算机H作为托管MSDE的对等体。
有没有其他人在Windows 2000 Pro系统上运行MSDE 2000 Release A？
---
Mark Ferguson
< no **** @ noname.com>在消息中写道
新闻：40 ************** @ nntp.flfrd.phub.net.cable.ro gers.com ...在Windows 2000专业版下安装的MSDE 2000 Release A不会与SQL Server Manager通信，也不会在对等计算机上与MS Access通信。
有人可以帮忙吗？
已设置DISABLENETWORKPROTOCOLS在安装时= 0。
安装日志显示安装成功..
控制面板>管理工具>服务部分显示SQL服务器实例正在运行。
禁用防火墙无效。
SQL Server Manager（任务栏右下角的图标 - 这个启动/停止服务器实例），在与SQL Server实例相同的计算机上，仅显示实例H。这与电脑的名称相同。 （在安装新实例之前已卸载此实例。）在
顶部组合框中键入新实例名称（H\ABC和变体）会产生错误消息，例如名称格式错误 ;，
未找到网络路径 RPC服务未运行。什么是正确的计算机/名称格式？关键问题显然是服务管理器无法与本地MSDE实例通信。
已经安装了MS网站的所有Windows 2000更新。
目标是在计算机X上运行MS Access（也运行Win 2000
Pro），计算机H作为托管MSDE的对等体。
还有其他人在Windows 2000上运行MSDE 2000 Release A Pro系统??
---
Mark Ferguson
我必须承认我不知道MSDE Release A和
MSDE SP3a。 MS站点上没有明确的信息（或者至少我没有找到它），但是下载大小不同，所以明显的
结论是他们是不同的版本。如果这个假设是正确的，那么你可能会看到这个问题：
http://support.microsoft.com/default...10&Product=sql
然而，我可能是错的，所以也许你可以检查更多的东西。您可以使用本地osql.exe命令实际连接到H上的实例吗
也可以在H上使用
如果您以管理员身份登录Windows，那么
就足够了：
osql -SH\ABC -E
如果有效，那么问题可能就是服务经理本身
（可能如上文所述）。如果你可以连接，你可以
然后用这个查询检查版本：
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或任何其他工具）进行连接，
存在许多可能的连接问题：
< a rel =nofollowhref =http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sqltarget =_ blank> http://support.microsoft .com / default ... 06& Product = sql
我想当你说同行时你的意思是PC在一个工作组中，而不是一个
域。如果是这种情况，那么可信连接可能很尴尬 - 上面的
文章有一个指向另一篇知识库文章的链接，该文章描述了可能的
解决方法。使用SQL登录的混合安全性应该可以正常工作，但除非没有其他选择，否则通常不建议使用
。
Simon
您好
您可以在microsoft.public.sqlserver.msde新闻组获得更多帮助。
John
< no **** @ noname.com>在消息中写道
新闻：40 ************** @ nntp.flfrd.phub.net.cable.ro gers.com ...在Windows 2000专业版下安装的MSDE 2000 Release A不会与SQL Server Manager通信，也不会在对等计算机上与MS Access通信。
有人可以帮忙吗？
已设置DISABLENETWORKPROTOCOLS在安装时= 0。
安装日志显示安装成功..
控制面板>管理工具>服务部分显示SQL服务器实例正在运行。
禁用防火墙无效。
SQL Server Manager（任务栏右下角的图标 - 这个启动/停止服务器实例），在与SQL Server实例相同的计算机上，仅显示实例H。这与电脑的名称相同。 （在安装新实例之前已卸载此实例。）在
顶部组合框中键入新实例名称（H\ABC和变体）会产生错误消息，例如名称格式错误 ;，
未找到网络路径 RPC服务未运行。什么是正确的计算机/名称格式？关键问题显然是服务管理器无法与本地MSDE实例通信。
已经安装了MS网站的所有Windows 2000更新。
目标是在计算机X上运行MS Access（也运行Win 2000
Pro），计算机H作为托管MSDE的对等体。
还有其他人在Windows 2000上运行MSDE 2000 Release A专业系统??
--- Mark Ferguson
" Simon Hayes" < sq*@hayes.ch>在留言中写道
新闻：40 ********** @ news.bluewin.ch ...
|
| <无**** @ noname.com>在消息中写道
|新闻：40 ************** @ nntp.flfrd.phub.net.cable.ro gers.com ...
| >在Windows 2000专业版下安装的MSDE 2000 Release A不会是
| >在对等计算机上与SQL Server Manager或MS Access进行通信。
| >有人可以帮忙吗？
| >
| >在安装时设置了DISABLENETWORKPROTOCOLS = 0.
| >
| >安装日志显示安装成功..
| >
| >控制面板>管理工具>服务部分显示SQL服务器实例
| >跑步。
| >
| >禁用防火墙无效。
| >
| > SQL Server Manager（任务栏右下角的图标 - 这个
| >实例，仅显示实例H。这与电脑相同
| >名称。 （在安装新实例
|>之前已卸载此实例。）将新实例名称（H\ABC和变体）键入
| >顶部组合框产生错误消息，例如名称格式错误，
| > 未找到网络路径 RPC服务未运行。什么是
| >正确的电脑/名称格式？关键问题显然是服务
| >管理员无法与此本地MSDE实例通信。
| >
| >已安装MS网站上的所有Windows 2000更新。
| >
| >目标是在计算机X上运行MS Access（也运行Win 2000
|> Pro），计算机H作为托管MSDE的对等体。
| >
| >有没有其他人在Windows 2000 Pro系统上运行MSDE 2000 Release A？
| > ---
| > Mark Ferguson
|
|我必须承认，我不知道MSDE Release A和
|之间的区别MSDE SP3a。 MS站点上没有明确的信息（或者至少我没有找到它），但是下载大小不同，所以很明显
|结论是它们是不同的版本。如果这个假设是
|没错，那么你可能会看到这个问题：
|
| http：// support。 microsoft.com/default...10&Product=sql
|
|但是，我可能是错的，所以也许你可以检查更多的东西。可以
|你实际上使用本地osql.exe命令连接到H上的实例
|还在H？如果您以管理员身份登录Windows，那么
|应该够了：
|
| osql -S H\ABC -E
|
|如果可行，那么问题就在于服务经理本身
| （可能如上文所述）。如果你可以连接，你可以
|然后用这个查询检查版本：
|
| 1 GT;选择@@版本
| 2 - ; go
|
|如果你没有看到版本8.00.760，那么你没有SP3a，所以我会
|完全删除MSDE，然后安装MSDE SP3a。请参阅删除所有已知
| SQL Server的实例在这篇文章中：
|
| http：// support。 microsoft.com/default...91&Product=sql
|
|如果你无法连接osql.exe，那么你得到什么错误信息？在
|但是，最后的分析，我建议服务器管理器是一个小的，
|不重要的组件，可能不值得担心。只要
| MSDE正在运行，你可以从没有
|的客户端应用程序连接问题，那我就不会花太多时间来努力工作。
|
|关于从不同的PC（使用Access或任何其他工具）进行连接，
|有许多可能的连接问题：
|
| http：// support。 microsoft.com/default...06&Product=sql
|
|我想当你说同行时你的意思是PC在工作组中，而不是
|域。如果是这种情况，那么可信连接可能很尴尬 -
|上面的文章有一个链接到另一个KB文章，其中描述了可能的
|解决方法。使用SQL登录的混合安全性应该可以正常工作，但不是
|一般建议除非没有其他选择。
|
| Simon
|
|
MSDE 2000 Release A是Microsoft SQL Server 2000的开发人员版本（SDK）
Desktop Engine SP3a。 SELECT @@ VERSION为两者返回相同的版本信息。
Microsoft SQL Server 2000桌面引擎（MSDE 2000）的简要描述
版本A被引用从下载页面 -
<
MSDE 2000 Release A在功能上等同于SQL Server 2000桌面
引擎SP3a除了以下内容：
新的许可协议
删除可用于嵌入MSDE 2000 Release A的合并模块
与应用程序
新的ReadMeMSDE2000A.htm，其中包含特定于此版本的信息。
这个新版本的MSDE包含所有包含的修复程序用SQL
Server 2000 SP3a版本的MSDE。
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 not
communicate 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 instance
running.
Disabling firewall has no effect.
SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format?? Key problem is clearly that Service
Manager 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 2000
Pro) 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
<no****@noname.com> wrote in message
news:40**************@nntp.flfrd.phub.net.cable.ro gers.com...MSDE 2000 Release A installed under windows 2000 pro will not
communicate 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 instance
running.
Disabling firewall has no effect.
SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format?? Key problem is clearly that Service
Manager 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 2000
Pro) 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 and
MSDE SP3a. There is no clear information on the MS site (or at least I
couldn''t find it), but the download sizes are different, so the obvious
conclusion is that they are different versions. If this assumption is
correct, then you might be seeing this issue:
http://support.microsoft.com/default...10&Product=sql
However, I could be wrong, so perhaps you can check some more things. Can
you actually connect to the instance on H using a local osql.exe command
also on H? If you''re logged on to Windows as an administrator, then this
should be enough:
osql -S H\ABC -E
If that works, then presumably the problem is the Service Manager itself
(possibly as described in the article above). If you can connect, you can
then check the version with this query:
1> select @@version
2> go
If you don''t see version 8.00.760, then you don''t have SP3a, so I would
completely remove MSDE and then install MSDE SP3a. See "Remove all known
instances of SQL Server" in this article:
http://support.microsoft.com/default...91&Product=sql
If you cannot connect with osql.exe, then what error message do you get? In
the final analysis, however, I would suggest that Server Manager is a small,
unimportant component which probably is not worth worrying about. As long as
MSDE is running and you can connect from client applications with no
problems, 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=sql
I guess when you say "peer" you mean that the PCs are in a workgroup, not a
domain. If this is the case, then trusted connections can be awkward - the
article above has a link to another KB article which describes a possible
workaround. Mixed security using SQL logins should work fine, but is not
generally recommended unless there is no other alternative.
Simon
Hi
You may get more help in the microsoft.public.sqlserver.msde newsgroup.
John
<no****@noname.com> wrote in message
news:40**************@nntp.flfrd.phub.net.cable.ro gers.com...MSDE 2000 Release A installed under windows 2000 pro will not
communicate 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 instance
running.
Disabling firewall has no effect.
SQL Server Manager (icon at bottom right in task tray - this
starts/stops Server instances), on same computer as SQL Server
instance, shows only instance "H" which is the same as the computer
name. (This instance was uninstalled before new instance was
installed.) Typing new instance name ("H\ABC" and variations) into
top combo box produces error messages such as "wrong format for name",
"Network path not found" "RPC service not running". What is the
correct computer/name format?? Key problem is clearly that Service
Manager 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 2000
Pro) 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
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:40**********@news.bluewin.ch...
|
| <no****@noname.com> wrote in message
| news:40**************@nntp.flfrd.phub.net.cable.ro gers.com...
| > MSDE 2000 Release A installed under windows 2000 pro will not
| > communicate 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 instance
| > running.
| >
| > Disabling firewall has no effect.
| >
| > SQL Server Manager (icon at bottom right in task tray - this
| > starts/stops Server instances), on same computer as SQL Server
| > instance, shows only instance "H" which is the same as the computer
| > name. (This instance was uninstalled before new instance was
| > installed.) Typing new instance name ("H\ABC" and variations) into
| > top combo box produces error messages such as "wrong format for name",
| > "Network path not found" "RPC service not running". What is the
| > correct computer/name format?? Key problem is clearly that Service
| > Manager 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 2000
| > Pro) 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 and
| MSDE SP3a. There is no clear information on the MS site (or at least I
| couldn''t find it), but the download sizes are different, so the obvious
| conclusion is that they are different versions. If this assumption is
| correct, then you might be seeing this issue:
|
| http://support.microsoft.com/default...10&Product=sql
|
| However, I could be wrong, so perhaps you can check some more things. Can
| you actually connect to the instance on H using a local osql.exe command
| also on H? If you''re logged on to Windows as an administrator, then this
| should be enough:
|
| osql -S H\ABC -E
|
| If that works, then presumably the problem is the Service Manager itself
| (possibly as described in the article above). If you can connect, you can
| then check the version with this query:
|
| 1> select @@version
| 2> go
|
| If you don''t see version 8.00.760, then you don''t have SP3a, so I would
| completely remove MSDE and then install MSDE SP3a. See "Remove all known
| instances of SQL Server" in this article:
|
| http://support.microsoft.com/default...91&Product=sql
|
| If you cannot connect with osql.exe, then what error message do you get? In
| the final analysis, however, I would suggest that Server Manager is a small,
| unimportant component which probably is not worth worrying about. As long as
| MSDE is running and you can connect from client applications with no
| problems, 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=sql
|
| I guess when you say "peer" you mean that the PCs are in a workgroup, not a
| domain. If this is the case, then trusted connections can be awkward - the
| article above has a link to another KB article which describes a possible
| workaround. Mixed security using SQL logins should work fine, but is not
| generally recommended unless there is no other alternative.
|
| Simon
|
|
MSDE 2000 Release A is a developer version (SDK) of Microsoft SQL Server 2000
Desktop Engine SP3a. SELECT @@VERSION returns the same version info for both.
This brief description of Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Release A is quoted from the download page -
<
MSDE 2000 Release A is functionally equivalent to SQL Server 2000 Desktop
Engine SP3a except for the following:
New licensing agreement
Removal of the merge modules that can be used to embed MSDE 2000 Release A
with applications
New ReadMeMSDE2000A.htm that contains information specific to this release.
This new version of MSDE contains all the fixes that are included with SQL
Server 2000 SP3a version of MSDE.
http://www.microsoft.com/downloads/d...DisplayLang=en
Additional information can be found in the Microsoft SQL Server 2000 Desktop
Engine
(MSDE 2000) Release A ReadMe
http://download.microsoft.com/downlo...eMSDE2000A.htm
Additions to the SQL Server 2000 Desktop Engine (MSDE) Release A
ReadmeMSDE2000A.htm File
http://support.microsoft.com/?kbid=829925
Dan
这篇关于MSDE 2000 Release A不会说话的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
