How to ping local instance of sqlexpress

Question

I am trying to troubleshoot connectivity between two computers, such that one can access sqlexpress on the other. I cannot determine the correct syntax to try to ping sqlexpress. Here is what I have setup locally and my ping effort.

local sqlexpress settings: share memory: enabled, named pipes, enabled, tcp/ip: enabled.

TCP/IP settings:
IP2:
IP address=IP of my local computer,
TCP dynamic Ports=0,
TCP Port=blank.

IPAll: TCP Dynamic Ports=blank, TCP Port=59956.

It appears that pinging the computer IP and port is not working locally:

ping 10.1.103.93:59956

ping 10.1.103.93\sqlexpress

ping 10.1.103.93:59956\sqlexpress

ERROR: Ping request could not find host.

ping 10.1.103.93 works fine.

How do I try to test tcp/ip connection to sqlexpress?

Answer 1

I cannot determine the correct syntax to try to ping sqlexpress.

You can't ping a tcp port of a machine, only the machine itself.

If you want to determine which ports are use then use then

netstat -a

command instead.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

What about trying a Telnet session such as : telnet <server_name> <port_number>     . This gives you a good indication the port is available.      Check with administrator first , to ensure they haven't blocked  Telnet usage

---

Jack Vamvas sqlserver-dba.com

Answer 3

Ok, I was able to telnet locally. Then, telnet from the other machine.  Knowing that it was not a connection issue, I was able to use SSMS to determine that I can access the database. The syntax was: server name = "mycomputer,59956\sqlexpress".

thanks.