Friday, August 03, 2012 6:09 PM
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.
IP address=IP of my local computer,
TCP dynamic Ports=0,
IPAll: TCP Dynamic Ports=blank, TCP Port=59956.
It appears that pinging the computer IP and port is not working locally:
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?
- Edited by RLuther Friday, August 03, 2012 6:10 PM
Friday, August 03, 2012 6:16 PMAnswerer
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
- Proposed As Answer by Hasham NiazEditor Friday, August 03, 2012 6:20 PM
- Edited by Olaf HelperMicrosoft Community Contributor, Editor Saturday, August 04, 2012 10:16 AM
Sunday, August 05, 2012 5:47 AMWhat 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
- Marked As Answer by RLuther Tuesday, August 07, 2012 6:10 PM
Monday, August 06, 2012 8:48 PM
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".