SQL Server 2000 - Remote Connection ODBC

Question

I have four machines:

• XP with SQL 2000 (Machine A, the one I'm having problem with)
  • firewall:off
  • port:1433
• XP with SQL 2000 (Machine B)
  • firewall:off
  • port:1433
• XP (Machine C)
• XP (Machine D)

Note:

• All machines are in one workgroup
• All have dynamic IP addresses

Tests Done:

Machine A:

• ping Machine B - OK
• ping Machine C - OK
• ping Machine D - OK
• telnet B on port 1433, error
• connect to local SQL - OK
• connect to Machine B's SQL - ERROR

Machine B:

• ping Machine A - OK
• ping Machine C - OK
• ping Machine D - OK
• telnet A on port 1433, error
• connect to local SQL - OK
• connect to Machine A's SQL - ERROR

Machine C:

• ping Machine A - OK
• ping Machine B - OK
• ping Machine D - OK
• telnet A on port 1433, error
• telnet B on port 1433, error
• connect to Machine A's SQL - ERROR
• connect to Machine B's SQL - OK

Machine D:

• ping Machine A - OK
• ping Machine B - OK
• ping Machine C - OK
• telnet A on port 1433, error
• telnet B on port 1433, error
• connect to Machine A's SQL - ERROR
• connect to Machine B's SQL - OK

I can't connect to Machine A's SQL Server. A and B have the same configurations, they have no network problems, but why A is not working? How to troubleshoot this? Please I've read enough articles from Microsoft. Anybody encountered the same problem before? Is there any chance that a pc can be pinged but has a problem in physical network?

Answer 1

Are you sure A's SQL service is listening on 1433? Also, are there any firewalls preventing A from connecting on its SQL port?