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?
- 편집됨 RLuther 2012년 8월 3일 금요일 오후 6:10
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
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
- 답변으로 표시됨 RLuther 2012년 8월 7일 화요일 오후 6:10
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".