| 远程数据库连接失败 [message #202436] |
Di, 16 Mai 2006 11:07 |
|
我的服务器2000 SERVER ,远程客户机通过MODEM向我的服务器上报数据， 应用程序是SQL SERVER
数据库技术开发的，客户机和服务器可以互联 ，但是上报数据时失败，显示“远程数据库连 接失败，请与系统管理员联系”；客户机和服 务器互联时，用 PING
172.16.35.1（服务器的ip地址), 结果正常。重装了应用程序也不能解决问题。 请高人指点。
--
初学者,请多此教!
|
|
|
| RE: 远程数据库连接失败 [message #206534 ] |
Mi, 24 Mai 2006 03:32 |
|
|
两端的防火墙都要关了。看双方ping对方是否 能ping通。
|
|
|
| RE: 远程数据库连接失败 [message #206540 ] |
Do, 25 Mai 2006 05:25 |
|
能通，但在服务器计算机上：
C:\>telnet lchglj
正在连接到lchglj...无法打开到主机的连接: 连接失败
C:\>ping lchglj
Pinging lchglj.lch [172.16.35.1] with 32 bytes of data:
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Ping statistics for 172.16.35.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\>ping 172.16.35.1
Pinging 172.16.35.1 with 32 bytes of data:
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Reply from 172.16.35.1: bytes=32 time<10ms TTL=128
Ping statistics for 172.16.35.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\>ipconfig /all
Windows 2000 IP Configuration
Host Name . . . . . . . . . . . . : lchglj
Primary DNS Suffix . . . . . . . : lch
Node Type . . . . . . . . . . . . : Broadcast
IP Routing Enabled. . . . . . . . : Yes
WINS Proxy Enabled. . . . . . . . : No
Ethernet adapter 本地连接:
Media State . . . . . . . . . . . : Cable Disconnected
Description . . . . . . . . . . . : Intel(R) PRO/100 VE Network
Connecti
on
Physical Address. . . . . . . . . : 00-D0-B7-C6-C7-C9
C:\>ping 127.0.0.1
Pinging 127.0.0.1 with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\>netstat -a显示所有连接
Active Connections
Proto Local Address Foreign Address State
TCP lchglj:smtp lchglj.lch:0 LISTENING
TCP lchglj:http lchglj.lch:0 LISTENING
TCP lchglj:kerberos lchglj.lch:0 LISTENING
TCP lchglj:epmap lchglj.lch:0 LISTENING
TCP lchglj:ldap lchglj.lch:0 LISTENING
TCP lchglj:https lchglj.lch:0 LISTENING
TCP lchglj:microsoft-ds lchglj.lch:0 LISTENING
TCP lchglj:kpasswd lchglj.lch:0 LISTENING
TCP lchglj:593 lchglj.lch:0 LISTENING
TCP lchglj:ldaps lchglj.lch:0 LISTENING
TCP lchglj:1026 lchglj.lch:0 LISTENING
TCP lchglj:1029 lchglj.lch:0 LISTENING
TCP lchglj:1032 lchglj.lch:0 LISTENING
TCP lchglj:1039 lchglj.lch:0 LISTENING
TCP lchglj:1045 lchglj.lch:0 LISTENING
TCP lchglj:1046 lchglj.lch:0 LISTENING
TCP lchglj:1048 lchglj.lch:0 LISTENING
TCP lchglj:1053 lchglj.lch:0 LISTENING
TCP lchglj:1057 lchglj.lch:0 LISTENING
TCP lchglj:1063 lchglj.lch:0 LISTENING
TCP lchglj:1070 lchglj.lch:0 LISTENING
TCP lchglj:1102 lchglj.lch:0 LISTENING
TCP lchglj:1108 lchglj.lch:0 LISTENING
TCP lchglj:pptp lchglj.lch:0 LISTENING
TCP lchglj:2908 lchglj.lch:0 LISTENING
TCP lchglj:2909 lchglj.lch:0 LISTENING
TCP lchglj:2912 lchglj.lch:0 LISTENING
TCP lchglj:2919 lchglj.lch:0 LISTENING
TCP lchglj:2920 lchglj.lch:0 LISTENING
TCP lchglj:3268 lchglj.lch:0 LISTENING
TCP lchglj:3269 lchglj.lch:0 LISTENING
TCP lchglj:3372 lchglj.lch:0 LISTENING
TCP lchglj:7599 lchglj.lch:0 LISTENING
TCP lchglj:ldap lchglj.lch:2908 ESTABLISHED
TCP lchglj:ldap lchglj.lch:2909 ESTABLISHED
TCP lchglj:ldap lchglj.lch:2912 ESTABLISHED
TCP lchglj:1039 lchglj.lch:ldap CLOSE_WAIT
TCP lchglj:ms-sql-s lchglj.lch:0 LISTENING
TCP lchglj:2908 lchglj.lch:ldap ESTABLISHED
TCP lchglj:2909 lchglj.lch:ldap ESTABLISHED
TCP lchglj:2912 lchglj.lch:ldap ESTABLISHED
TCP lchglj:netbios-ssn lchglj.lch:0 LISTENING
TCP lchglj:ldap lchglj.lch:2920 ESTABLISHED
TCP lchglj:ldap lchglj.lch:3073 TIME_WAIT
TCP lchglj:ldap lchglj.lch:3074 TIME_WAIT
TCP lchglj:ldap lchglj.lch:3075 TIME_WAIT
TCP lchglj:1026 lchglj.lch:1063 ESTABLISHED
TCP lchglj:1026 lchglj.lch:1108 ESTABLISHED
TCP lchglj:1063 lchglj.lch:1026 ESTABLISHED
TCP lchglj:1102 lchglj.lch:ldap CLOSE_WAIT
TCP lchglj:1108 lchglj.lch:1026 ESTABLISHED
TCP lchglj:ms-sql-s lchglj.lch:0 LISTENING
TCP lchglj:2919 lchglj.lch:ldap CLOSE_WAIT
TCP lchglj:2920 lchglj.lch:ldap ESTABLISHED
UDP lchglj:epmap *:*
UDP lchglj:microsoft-ds *:*
UDP lchglj:1028 *:*
UDP lchglj:1035 *:*
UDP lchglj:1038 *:*
UDP lchglj:1042 *:*
UDP lchglj:1049 *:*
UDP lchglj:1060 *:*
UDP lchglj:1067 *:*
UDP lchglj:1073 *:*
UDP lchglj:1101 *:*
UDP lchglj:1111 *:*
UDP lchglj:1270 *:*
UDP lchglj:ms-sql-m *:*
UDP lchglj:1645 *:*
UDP lchglj:1646 *:*
UDP lchglj:l2tp *:*
UDP lchglj:radius *:*
UDP lchglj:radacct *:*
UDP lchglj:3456 *:*
UDP lchglj:1076 *:*
UDP lchglj:1077 *:*
UDP lchglj:kerberos *:*
UDP lchglj:ntp *:*
UDP lchglj:netbios-ns *:*
UDP lchglj:netbios-dgm *:*
UDP lchglj:389 *:*
UDP lchglj:kpasswd *:*
UDP lchglj:isakmp *:*
C:\>netstat -an (netstat -n，则不能将地址和端口号转换成名称)
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:88 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:464 0.0.0.0:0 LISTENING
TCP 0.0.0.0:593 0.0.0.0:0 LISTENING
TCP 0.0.0.0:636 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1029 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1032 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1039 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1045 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1046 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1048 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1053 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1057 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1063 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1070 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1102 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1108 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1723 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2908 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2909 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2912 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2919 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2920 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3268 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3269 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3372 0.0.0.0:0 LISTENING
TCP 0.0.0.0:7599 0.0.0.0:0 LISTENING
TCP 127.0.0.1:389 127.0.0.1:2908 ESTABLISHED
TCP 127.0.0.1:389 127.0.0.1:2909 ESTABLISHED
TCP 127.0.0.1:389 127.0.0.1:2912 ESTABLISHED
TCP 127.0.0.1:1039 127.0.0.1:389 CLOSE_WAIT
TCP 127.0.0.1:1433 0.0.0.0:0 LISTENING
TCP 127.0.0.1:2908 127.0.0.1:389 ESTABLISHED
TCP 127.0.0.1:2909 127.0.0.1:389 ESTABLISHED
TCP 127.0.0.1:2912 127.0.0.1:389 ESTABLISHED
TCP 172.16.35.1:139 0.0.0.0:0 LISTENING
TCP 172.16.35.1:389 172.16.35.1:2920 ESTABLISHED
TCP 172.16.35.1:389 172.16.35.1:3085 TIME_WAIT
TCP 172.16.35.1:389 172.16.35.1:3086 TIME_WAIT
TCP 172.16.35.1:1026 172.16.35.1:1063 ESTABLISHED
TCP 172.16.35.1:1026 172.16.35.1:1108 ESTABLISHED
TCP 172.16.35.1:1063 172.16.35.1:1026 ESTABLISHED
TCP 172.16.35.1:1102 172.16.35.1:389 CLOSE_WAIT
TCP 172.16.35.1:1108 172.16.35.1:1026 ESTABLISHED
TCP 172.16.35.1:1433 0.0.0.0:0 LISTENING
TCP 172.16.35.1:2919 172.16.35.1:389 CLOSE_WAIT
TCP 172.16.35.1:2920 172.16.35.1:389 ESTABLISHED
TCP 172.16.35.1:3083 172.16.35.1:135 TIME_WAIT
TCP 172.16.35.1:3084 172.16.35.1:1026 TIME_WAIT
UDP 0.0.0.0:135 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:1028 *:*
UDP 0.0.0.0:1035 *:*
UDP 0.0.0.0:1038 *:*
UDP 0.0.0.0:1042 *:*
UDP 0.0.0.0:1049 *:*
UDP 0.0.0.0:1060 *:*
UDP 0.0.0.0:1067 *:*
UDP 0.0.0.0:1073 *:*
UDP 0.0.0.0:1101 *:*
UDP 0.0.0.0:1111 *:*
UDP 0.0.0.0:1270 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:1645 *:*
UDP 0.0.0.0:1646 *:*
UDP 0.0.0.0:1701 *:*
UDP 0.0.0.0:1812 *:*
UDP 0.0.0.0:1813 *:*
UDP 0.0.0.0:3456 *:*
UDP 127.0.0.1:1076 *:*
UDP 127.0.0.1:1077 *:*
UDP 172.16.35.1:88 *:*
UDP 172.16.35.1:123 *:*
UDP 172.16.35.1:137 *:*
UDP 172.16.35.1:138 *:*
UDP 172.16.35.1:389 *:*
UDP 172.16.35.1:464 *:*
UDP 172.16.35.1:500 *:*
C:\>netstat -r显示路由表和活动连接
Route Table
============================================================ ===============
Interface List
0x1 ........................... MS TCP Loopback interface
0x1000003 ...00 d0 b7 c6 c7 c9 ...... Intel(R) PRO Adapter
============================================================ ===============
============================================================ ===============
Active Routes:
Network Destination Netmask Gateway Interface Metric
0.0.0.0 0.0.0.0 172.16.35.1 172.16.35.1 1
127.0.0.0 255.0.0.0 127.0.0.1 127.0.0.1 1
172.16.35.0 255.255.255.0 172.16.35.1 172.16.35.1 1
172.16.35.1 255.255.255.255 127.0.0.1 127.0.0.1 1
172.16.255.255 255.255.255.255 172.16.35.1 172.16.35.1 1
224.0.0.0 224.0.0.0 172.16.35.1 172.16.35.1 1
255.255.255.255 255.255.255.255 172.16.35.1 172.16.35.1 1
Default Gateway: 172.16.35.1
============================================================ ===============
Persistent Routes:
None
C:\>netstat -e显示 Ethernet 统计信息
Interface Statistics
Received Sent
Bytes 62295 67251
Unicast packets 0 0
Non-unicast packets 354 354
Discards 0 0
Errors 0 0
Unknown protocols 0
C:\>netstat -s显示每个协议的统计信息。
IP Statistics
Packets Received = 46079
Received Header Errors = 0
Received Address Errors = 1
Datagrams Forwarded = 0
Unknown Protocols Received = 0
Received Packets Discarded = 0
Received Packets Delivered = 46079
Output Requests = 46079
Routing Discards = 0
Discarded Output Packets = 0
Output Packet No Route = 0
Reassembly Required = 0
Reassembly Successful = 0
Reassembly Failures = 0
Datagrams Successfully Fragmented = 0
Datagrams Failing Fragmentation = 0
Fragments Created = 0
ICMP Statistics
Received Sent
Messages 8944 8944
Errors 0 0
Destination Unreachable 2 2
Time Exceeded 0 0
Parameter Problems 0 0
Source Quenches 0 0
Redirects 0 0
Echos 4471 4471
Echo Replies 4471 4471
Timestamps 0 0
Timestamp Replies 0 0
Address Masks 0 0
Address Mask Replies 0 0
TCP Statistics
Active Opens = 1589
Passive Opens = 1587
Failed Connection Attempts = 2
Reset Connections = 15
Current Connections = 15
Segments Received = 36738
Segments Sent = 36658
Segments Retransmitted = 80
UDP Statistics
Datagrams Received = 395
No Ports = 4475
Receive Errors = 0
Datagrams Sent = 396
Tracert
C:\>Tracert 172.16.35.1 trace root路由跟踪实用程序
Tracing route to lchglj.lch [172.16.35.1]
over a maximum of 30 hops:
1 <10 ms <10 ms <10 ms lchglj.lch [172.16.35.1]
Trace complete.
C:\>Tracert lchglj
Tracing route to lchglj.lch [172.16.35.1]
over a maximum of 30 hops:
1 <10 ms <10 ms <10 ms lchglj.lch [172.16.35.1]
Trace complete.
--
初学者,请多此教!
“zzl”编写：
>
> 两端的防火墙都要关了。看双方ping对方是否 能ping通。
>
|
|
|
