SQL Server port 1433 access

[diek]

SQL Client PC attached to LAN port of 1721 router at remote T1 site unable to access port 1433 on SQL Server on LAN port of a 1721 on the local site.

NETSTAT showed the Local Address port 1042 accessing

SQL Server port 1433 State of TIME_WAIT.

Same PC can ping and access files on the SQL Server.

Moved PC to local site with SQL server and it worked with no problems.

There is no firewall being used.

What could cause the 1721 router to block access to a SQL Server port 1433.

Thanks, Ken

[smif101]

What is the delay and bandwidth between the two sites, if they delay is to high then that might be the problem. Try pinging the SQL server with 1500 byte packets and see if you start dropping packets.

[diek]

Thanks for the replay.

I pinged from the pc to the server for 3 min with 1500 byte packets in a time of 170ms with no dropped packets.

Ken

[diek]

Thanks for the replay.

I pinged from the pc to the server for 3 min with 1500 byte packets in a time of 170ms with no dropped packets.

Ken

[diek]

I found my human error to this problem.

I misspelled the domain name in the dns configuration

on the remote windows 98 pc.

Thanks for your time and thoughts.

Ken