SQL Client PC attached to LAN port of cisco 1721 router at
remote T1 site unable to access port 1433 on SQL Server on
LAN port of a cisco 1721 router 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, KenYou'll need to make network traces at the client and server to determine
where the problem is.
You could also try telneting to the same port to verify that the traffic is
going thru.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks for your reply
I am able to telent into the SQL Server as you suggested.
I also did a ping with 1500 byte packet size for 3 min
and it ran 100% with average time of 170ms. I will see
about setting up a trace on both ends.
Any other thoughts since we know traffic is getting thru.
Thanks Ken
>--Original Message--
>You'll need to make network traces at the client and
server to determine
>where the problem is.
>You could also try telneting to the same port to verify
that the traffic is
>going thru.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||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
>--Original Message--
>You'll need to make network traces at the client and
server to determine
>where the problem is.
>You could also try telneting to the same port to verify
that the traffic is
>going thru.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||No problem.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment