壹佰网|ERP100 - 企业信息化知识门户

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 2330|回复: 11

[天心ERP] 客户端设置---连接SQL问题

  [复制链接]
发表于 2008/12/13 14:54:58 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622  。

您需要 登录 才可以下载或查看,没有帐号?注册

x
< class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">下面讨论是从ERP群内整理出的,附在这里与大家共同讨论。</SPAN></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">这里只能贴10000个字节,没有办法同志们,贴不上的只能以附件上传了。喜欢的就下下来看吧。</SPAN></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">孤独</SPAN><FONT face="Times New Roman">-</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">济南</SPAN><FONT face="Times New Roman">(70196858) 10:14:44 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comffice:office" /><o:p></o:p></FONT></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">要在</SPAN><FONT face="Times New Roman"> Windows Server 2003 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中运行</SPAN><FONT face="Times New Roman"> SQL Server</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">,您必须安装</SPAN><FONT face="Times New Roman"> SQL Server 2000 Service Pack 3 (SP3)</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。</SPAN><FONT face="Times New Roman">Windows Server 2003 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">会阻止未运行</SPAN><FONT face="Times New Roman"> SQL Server 2000 SP3 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">或更高版本的命名实例访问</SPAN><FONT face="Times New Roman"> TCP/IP </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">功能。在</SPAN><FONT face="Times New Roman"> SQL Server 2000 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">虚拟服务器安装期间,</SPAN><FONT face="Times New Roman">SQL Server </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">资源被创建并联机。要使资源联机,需要使用</SPAN><FONT face="Times New Roman"> SQL Server </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">资源</SPAN><FONT face="Times New Roman"> DLL</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><FONT face="Times New Roman">Sqsrvres.dll </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">或</SPAN><FONT face="Times New Roman"> Sqagtres.dll</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)与运行</SPAN><FONT face="Times New Roman"> SQL Server </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的计算机建立轻量连接。由于</SPAN><FONT face="Times New Roman"> TCP/IP </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">功能被阻止而使连接请求失败,从而导致安装程序停止响应。</SPAN><FONT face="Times New Roman"><SPAN lang=ZH-CN> </SPAN><o:p></o:p></FONT></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">使用客户端网络实用工具创建一个命名管道别名</SPAN><FONT face="Times New Roman"><SPAN lang=ZH-CN> </SPAN><o:p></o:p></FONT></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在安装</SPAN><FONT face="Times New Roman"> SQL Server 2000 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">虚拟服务器的命名实例之前,使用客户端网络实用工具</SPAN><FONT face="Times New Roman"> (CNU) </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">创建一个服务器别名,以便在(安装期间)创建</SPAN><FONT face="Times New Roman"> SQL Server </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">资源并使其联机的同时通过命名管道建立连接。对每一个命名实例安装重复此步骤。</SPAN><FONT face="Times New Roman"> 1. </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">从您打算在其中运行安装程序的节点上,为客户端连接创建一个服务器别名:</SPAN><FONT face="Times New Roman"> a. </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在将要运行安装程序的群集节点上运行</SPAN><FONT face="Times New Roman"> Cliconfg.exe</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。</SPAN><FONT face="Times New Roman"><SPAN lang=ZH-CN> </SPAN></FONT></FONT></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">注意:如果计算机上未安装</SPAN><FONT face="Times New Roman"> Cliconfg.exe</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">,请通过从</SPAN><FONT face="Times New Roman"> SQL Server 2000 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">安装文件运行</SPAN><FONT face="Times New Roman"> Sqlredis.exe </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">来安装它。为此,请在命令提示符处键入以下信息:</SPAN><FONT face="Times New Roman">\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS</FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。如果</SPAN><FONT face="Times New Roman"> Cliconfg.exe </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">没有立即可用,您可能必须重新启动计算机。</SPAN><SPAN lang=ZH-CN><FONT face="Times New Roman"> </FONT></SPAN><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">有关</SPAN><FONT face="Times New Roman"> SQL Server 2000 </FONT><SPAN lang=ZH-CN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">安装的其他信息,</SPAN></FONT></FONT></P>

客户端与SQL设置讨论.doc

29.5 KB, 下载次数: 68, 下载积分: 努力值 -5 点

发表于 2008/12/15 09:53:49 | 显示全部楼层
:lol
发表于 2008/12/16 23:44:28 | 显示全部楼层
学习了,谢谢.
发表于 2009/2/23 11:24:37 | 显示全部楼层
學習了,謝謝
发表于 2009/2/23 11:25:28 | 显示全部楼层
要下載,需要努力呀
发表于 2009/3/25 14:47:20 | 显示全部楼层
这应该是配置文件吧!
发表于 2009/3/27 11:58:41 | 显示全部楼层
发表于 2010/4/20 09:32:14 | 显示全部楼层
连接不上!服务器可以连接,客户端连不上SQL
发表于 2010/4/22 17:59:36 | 显示全部楼层
这应该是配置文件吧!
发表于 2010/4/23 00:07:30 | 显示全部楼层
我要看一下 我的怎么连接不了
发表于 2010/6/18 19:34:10 | 显示全部楼层
下载,学习,
发表于 2010/8/27 11:54:51 | 显示全部楼层
没有可能,没有突出
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|小黑屋|手机版|壹佰网 ERP100 ( 京ICP备19053597号-2 )

Copyright © 2005-2012 北京海之大网络技术有限责任公司 服务器托管由互联互通
手机:13911575376
网站技术点击发送消息给对方83569622   广告&合作 点击发送消息给对方27675401   点击发送消息给对方634043306   咨询及人才点击发送消息给对方138011526

GMT+8, 2025/11/30 02:36 , Processed in 0.023479 second(s), 17 queries , File On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表