用友通客户端连接不上服务器解决方案

用友通客户端连接不上服务器解决方案 用友通客户端连接不上服务器 用友通客户端登录时要进行注册连接操作，连接过程可能由于各种原因导致连接失败，如下几种典型连接失败的原因 和解决方案。 问:用友通客户端双击后提示:不能登录到服务器[UFIDA]:failed:不能得到服务器。或者选择服务器后提示:不能连接到 服务器，可能是:没有安装用友产品或数据服务没有启动。 图:双击客户端 图:选择服务器 分析:导致此问题现象原因比较复杂，需要逐步分析问题原因，先分析服务器环境是否正常，然后再分析客户端环境，各 分析操作详见一下说明，可以根据实际情况选择相应的解决方案。 服务器环境分析流程如下: 1. 系统管理能否打开 2. 服务能否正常运行 3. 用友通能不能正常注册登录 客户端环境分析流程如下: 1. 网络连接是否正常 2. 计算机名称及注册表配置是否正确 3. 服务器防火墙或端口设置 4. HOSTS文件设置 5. ODBC数据源连接测试 6. 操作系统和数据库补丁以及产品补丁 服务器环境分析流程如下: 1、系统管理能否打开 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 情况一: 问题现象: 登陆系统管理时提示AUTOMATION错误 需要重新注册windows系统文件的msadox.dll，Msador15.dll，msadomd.dll的文件。 解决方案: 文件路径:c:\windows\servicepackfiles\i386\msadox.dll) 注册命令: regsvr32 c:\windows\servicepackfiles\i386\msadox.dll 情况二: 问题现象: 双击企业门户,报错:登录失败进系统管理报错:运行时错误:53.文件未找到:client.dll. 解决方案: 系统丢失client.dll文件，修复安装软件解决。 2、服务能否正常运行 在服务器端检查服务是否启动。步骤为:控制面板——管理工具——服务，找到用友通和sql的服务，如果服务没有启动，手工启动即可。如果不能正常启动服务，可以用下面的方案解决: 用友通服务无法启动，提示:本地计算机 上的 用友通 服务启动后又停止了。一些服务自动停止，如果它们没问题现象: 有什么可做的，例如“性能日志和警报”服务。 分析:查看system32\uf2000.log,查看最后几行，如下各情况包含关键字有 情况1、 UFSystem 原因:系统管理没正常运行，数据库缺少UFSystem库 我们可以进入注册表HKEY_LOCAL_MACHINE\SOFTWARE\UFSOFT\UF2000\2.0\Setup，把这项删除，然后再运行 系统管理 情况2、口令 原因:设置了SQL口令，进企业管理器或注册表中直接修改SA口令 解决方案: 或者注册组件msadox.dll和msado15.dll 情况3、端口 原因:1433或4630端口被另的软件占用或被防火墙等禁用，在DOS下，用netstat -a -n 命令查看端口 开发情况，用telnet IP 端口号 命令查看端口连接情况 情况4、ADO 原因:安装ADO2.7版本，通网站下载 如果还是不能解决的话建议重新安装软件。 3、用友通能不能正常注册登录 如果服务器端的用友通也打不开，可以尝试通过配置服务器来解决，具体步骤如下: 开始——程序——用友通系列管理软件——用友通——服务器设置，在“当前”后面的文本框里输入服务器的IP地址或者127.0.0.1，点击“选择”即可。如图所示: and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 客户端环境分析流程如下: 1、检查网络连接是否正常 在开始运行里输入cmd，回车后进入dos窗口，再输入命令“ping IP”地址(IP代表服务器端的IP地址)，检查客户端 能否ping通服务器。 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 2、计算机名称及注册表配置是否正确 用友通系列产品对计算机名称有一定要求，要求不能带特殊字符，其中特殊字符包括:‘-’、‘，’、‘中文’等字符，建议计算机名改为只有英文字母的组合，如果有数字，数字不能开头。检查计算机名称是否有特殊字符，如果有特殊字符，修改即可，并检查注册表HKEY_LOCAL_MACHINE\SOFTWARE\UFSOFT\UF2000\2.0\Login下的各键值的server数据值是否为服务器的计算机名称。 如何进注册表:开始——运行，输入regedit进入注册表 3、服务器防火墙或端口设置 目前XP2操作系统自带个人防火墙，默认状态为启用，当防火墙启用时用友通客户端就会连接失败，原因是防火墙截止了用友通的端口连接，常见解决方法有: 方法1、关闭防火墙:开始->设置->控件面板->Windows防火墙->关闭 方法2、手工配置防火墙端口:控件面板->Windows防火墙->例外->添加端口，如下图所示: 另外还有杀毒软件也会导致客户端连接不上服务器，也同样可以通过关闭杀毒软件或者开通端口来解决。具体步骤如下(以瑞星杀毒软件为例，其他杀毒软件可以参考其说明): 方法一、设置瑞星个人防火墙的安全级别为低，如图: and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 方法二、设置瑞星个人防火墙的IP规则，步骤如下: (第1步) and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation (第2步) (第3步) 注:用友通的端口为4630，SQL数据库的默认端口为1433 在dos窗口下，可以使用netstat -a -n 命令查看端口开放情况，状态listening表示开放 用telnet IP 端口号 命令查看端口连接情况 4、HOSTS文件设置 hosts文件位于C:\Widows\System32\Drvers\Etc中，也可以用windows自带的查找功能搜索找到hosts文件，Hosts文件文一般有如下面的基本 # Copyright (c) 1993-1999 Microsoft Corp. „„ # 38.25.63.10 x.acme.com # x client host 127.0.0.1 localhost and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 我们在这后面再增加一行形如IP Host name(主机名)即可，注意:IP地址要放在每段的最前面，映射的Host name(主机 名)在IP后面，中间用空格分隔。 5、ODBC数据源连接测试 ? 开始——设置——控制面板——管理工具——数据源(ODBC); ? 点击“添加”，选择SQL，输入名称(任意)和服务器地址(客户端测试则输入服务器的IP地址); and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation ? 选择“使用用户输入登陆ID和密码的SQL Server验证”; ? 点击“下一步”，直到完成即可。 ? 测试数据源; ? 测试成功。 若测试不成功，请检查:a 检查服务器地址;b 检查防火墙设置(打开4630和1433端口);c 手动配置网络IP。 6、操作系统和数据库补丁以及产品补丁 操作系统:如果为xp，要打上sp2补丁; 数据库:数据库如果是msde，要安装msde的关键更新，如果是sql2000，要打上sp4补丁; 产品补丁:检查产品的补丁是否为对应版本。 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 常见问题分析 【问】不能登录服务器[计算机名]FAILED不能发送请求 【答】(1)登陆系统管理，检查服务器的名称是否是当前的计算机名称或ip地址。 (2)若服务器位置是空白的，那么请点击后面的按钮进行服务器配置 (3)若是之前因为更改计算机名称而导致不能链接服务器的情况，请进行注册表的修改。 (4)检查防火墙，若启动了防火墙，添加用有通的端口即可。 【问】不能登录服务器[计算机名]FAILED不能发送请求，可能是用友服务无法启动或没有安装用友产品。 【答】请检查用友通的服务是否启动(我的电脑右键----管理-----服务)若没有启动，手工启动即可。 【问】当试图打开财务报表模块时,弹出登录信息对话框,不能登录到服务器[ms102557],请检查服务器配置:failed:不能发送服务器请求可是登录到别的模块没有问题,检查服务器接口也没有问题,在注册表中也配置正确。 【答】因为别的模块会直接连接到登陆时选择的服务器。而财务报表会连接到本机，或者以前进入报表连接的服务器。所以如果是在客户端使用财务报表，或者本机如果时服务器，而又连接过别的电脑时，必须进行服务器配置。另外可以检查注册表中login下mr的server值是不是该服务器。 【问】用友通服务无法启动，提示:本地计算机 上的 用友通 服务启动后又停止了。一些服务自动停止，如果它们没有什么可做的，例如“性能日志和警报”服务。 uf2000.log,查看最后几行，如下各情况包含关键字有 【答】分析:查看system32\ 情况1、 UFSystem 原因:系统管理没正常运行，数据库缺少UFSystem库 我们可以进入注册表HKEY_LOCAL_MACHINE\SOFTWARE\UFSOFT\UF2000\ 2.0\Setup，把这项删除，然后再运行系统管理 情况2、口令 原因:设置了SQL口令，进企业管理器或注册表中直接修改SA口令 或者注册组件msadox.dll和msado15.dll 情况3、端口 原因:1433或4630端口被另的软件占用或被防火墙等禁用，在DOS下，用netstat -a -n 命令查看端口开发情况，用telnet IP 端口号 命令查看端口连接情况 情况4、ADO 原因:安装ADO2.7版本，通网站下载 【问】打开系统管理点注册后显示乱码或报错，提示:不能登录到服务器:UF200502319 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 选择服务器后报错，提示:运行时错误 '53':文件未找到: Client.DLL 选择确定后提示:运行时错误 '440':Automation 错误 【答】Client.DLL文件存放在将WINNT或Windows目录的System32目录，将此文件剪切到WINNT或Windows目录下，然后注册，注册时报错，如下图，但不影响操作 【问】打开系统管理点注册后提示:不能登录到服务器:用友通-UFIDAfailed:不能发送请求。 【答】情况1:用友通服务未正常启动; 情况2:参考客户端连接的相关解决方案。 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation 【问】软件正常安装完成后,提示ServerNT.exe遇到问题后需要关闭.重启计算机后,又提示ServerNT.exe遇到问题后需要 关闭.软件登录不上,用友通服务无法启动。 【答】方案一:重新注册sqldmo.dll文件 方案二:操作系统问题，可以使用其他计算机上的ServerNT.exe覆盖一下这个计算机上的这个文件，最好重新安装一下操 作系统。 and other bad habits. Implementation to grab at the front, the maximum possible for jobs initiative to achieve efficient service. To carry forward the meticulous, detailed style. In the Office is no small matter. Business services a small mistake, it is possible to order at its meetings disrupted the entire, feedback on the content and timing a bit negligent, it could work in a passive position, slightly poor reception, may affect the image of a place and unit. Therefore, the Office staff with a high degree of professionalism and responsibility, serious and responsible, meticulous, careful to do everything to ensure that globalSmoothly. To carry forward the hard work, honest style. Adhere to the "Ning public and poverty, is not private and rich" old adage, bearing in mind the purpose of serving, consciously resist the erosion of various corruption and self-discipline, integrity, do not take leadership on behalf of the Office for personal affairs, not banner of leading organs of self-serving, and always maintain and carry forward the fine style of hard work, thrift and career, be honest and upright. Comrades, Government Office work task is glorious, a great responsibility. Hope the city's system of Government Office around the overall situation, pay attention to implementation of work in the purpose, give full play to staff aides, integrated and coordinated implementation, supervision, service functions, close contact, strengthen coordination, collaboration, efforts for grass-roots leadership services, service, quality and level of services for the masses to push to a new level. 2003 annual summary meeting of the Office of the municipal government reports on innovation