Quote:
Originally Posted by evo2
You said in post #5 that some windows clients can connect to the server ok, but your centos client can not. Ie the windows clients must see port 1433 as open, but the centos client sees it as closed. So, I was wondering what is different (if anything) about the network(s) that the windows clients are on compared to the centos client. Is the sql server behind a firewall that only opens 1433 for certain client IPs or networks?
Evo2.
|
i type command in command line : -anop TCP // and result is like this(port 1433 is not shown)
Active Connections
Proto Local Address Foreign Address State PID
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING 232
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING 1560
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING 4
TCP 0.0.0.0:912 0.0.0.0:0 LISTENING 1892
TCP 0.0.0.0:2508 0.0.0.0:0 LISTENING 376
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING 1512
TCP 127.0.0.1:1664 0.0.0.0:0 LISTENING 3748
TCP 192.168.179.100:139 0.0.0.0:0 LISTENING 4
TCP 192.168.179.100:139 192.168.179.100:3366 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3371 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3378 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3388 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3394 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3399 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3406 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3411 TIME_WAIT 0
TCP 192.168.179.100:139 192.168.179.100:3419 TIME_WAIT 0
TCP 192.168.179.100:445 192.168.77.114:4570 ESTABLISHED 4
TCP 192.168.179.100:445 192.168.77.114:4576 ESTABLISHED 4
TCP 192.168.179.100:445 192.168.179.84:3946 ESTABLISHED 4
TCP 192.168.179.100:1051 94.100.181.58:2041 ESTABLISHED 3620
TCP 192.168.179.100:1270 192.168.179.104:22 ESTABLISHED 3132
TCP 192.168.179.100:1489 192.168.179.104:22 ESTABLISHED 3924
TCP 192.168.179.100:1490 192.168.179.104:22 ESTABLISHED 3732
TCP 192.168.179.100:2730 209.85.137.125:5222 ESTABLISHED 1456
TCP 192.168.179.100:2981 64.12.25.191:443 ESTABLISHED 1456
TCP 192.168.179.100:3004 64.12.165.95:443 ESTABLISHED 1456
TCP 192.168.179.100:3007 64.12.26.225:443 ESTABLISHED 1456
TCP 192.168.179.100:3365 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3366 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3367 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3370 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3371 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3372 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3377 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3378 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3379 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3382 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3387 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3388 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3390 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3393 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3394 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3395 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3398 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3399 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3400 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3405 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3406 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3407 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3410 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3411 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3412 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:3418 192.168.179.100:445 TIME_WAIT 0
TCP 192.168.179.100:3419 192.168.179.100:139 TIME_WAIT 0
TCP 192.168.179.100:4678 192.168.179.104:22 ESTABLISHED 2812
TCP 192.168.179.100:4932 192.168.179.84:80 CLOSE_WAIT 748
my Centos's ip is : 192.168.179.104.
hmm, i dont now how to connect another client to my database server ,by which port

. thank you for helps.