I have establlished a MSDE server.
I know how to check the TCP port at the server.

But, I also want to know if it is possible to check the
TCP port from other workstation?

Please advise.

hi,
[quoted text, click to view]

in order to check connectivity, you can perhaps ping the server, or telnet
it, like
c:\..\>telnet servername port_num ;
if the screen becomes black you are connected to the SQL Server instance
(type quit to exit)
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply