- 论坛徽章:
- 0
|
本帖最后由 silamuwang 于 2010-03-26 11:08 编辑
今天在win server2003 上装了12.5.1, 安装配置一切顺利,就是SYB_BACKUP服务配置遇到了极大地困难,执行dump是总报错 “can't open a connection to site 'syb_backup'. see the error log file in the sql server boot directory. ”
日志错误信息:
00:00000:00019:2010/03/25 17:54:27.98 kernel nl__connect: Could not connect to site 'backup', socket 14.
00:00000:00019:2010/03/25 17:54:27.98 kernel nl__connect: net_connect failed to connect to site 'backup'.
: 由于目标机器积极拒绝,无法连接。
.
00:00000:00019:2010/03/25 17:54:28.01 server Failed to connect to remote server backup tcp ether 192.168.0.200 5005 for site SYB_BACKUP. Trying the next query entry of this server, if any.
00:00000:00019:2010/03/25 17:54:28.01 server Error: 7235, Severity: 17, State: 0
00:00000:00019:2010/03/25 17:54:28.01 server No other query entry found for the remote server backup - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.
查看 sysservers 的记录 :
1> select srvname, srvnetname from sysservers where srvname='SYB_BACKUP'
2> go
srvname srvnetname
------------------------------ --------------------------------
SYB_BACKUP backup
(1 row affected)
对比/sybase/ini 目录下 的sql.ini文件 :
[ase2_MS]
master=TCP,192.168.0.200,5002
query=TCP,192.168.0.200,5002
[backup]
master=TCP,192.168.0.200,5005
query=TCP,192.168.0.200,5005
[ase2]
master=TCP,192.168.0.200,5000
query=TCP,192.168.0.200,5000
[ase2_XP]
master=TCP,192.168.0.200,5004
query=TCP,192.168.0.200,5004
sysservers 的记录 和 inerfaces 内容一致,
通过对backup服务的ping server还能ping通 ,请问高手这是为什么呢?? 谢谢啦。 |
|