WinSQL » Knowledge base
|Subject:||Testing network connectivity from one machine to another|
|Creation date:||6/3/10 11:26 AM|
|Last modified on:||6/3/10 12:47 PM|
Testing for network connectivity
first step in solving any connectivity problem is to see if you can see
the server from a client machine. Here are a few tips that help you
accomplish this task.
purposes, we have made the following assumptions:
machine's IP address is 192.168.1.10
and its host name is clientOne
- Server machine's IP address is 192.168.1.20
and its host name is serverOne.
Besides, the server machine can also be reached by its fully qualified
domain name (FQDN), which is serverOne.CompanyOne.com
- Server machine is running a database, which is listening on TCP/IP
This first step is to ping the server machine from the client. Use the
following steps to perform this test.
- Click on the start
button, select Run and type cmd . On
Windows Vista and Windows 7, you don't have the Run item. Instead, just
type cmd in
the search bar and hit ENTER.
- This will open up the
Console window (DOS). Type the following command
should see a reply back that looks like:
you get a reply back with an error, it can mean any of the following:
typed the host name incorrectly
- Host name cannot be resolved to
an IP address
- The server machine cannot be reached on the
- Try solving this problem before proceeding to the next step
If this ping test passes, it means that your client machine can see the
server machine. This does NOT mean you can connect to the server machine.
Using Telnet to test connectivity
Once the ping test passes, you can use Telnet to test if your client machine can connect to the server machine. Use the following steps to perform this test
- Type the following in the Console (DOS) Window
telnet serverOne 1433
IMPORTANT: On Windows Vista and Windows 7, Microsoft does not install the Telnet client by default. You will have to install this manually from Add Remove Windows Component.
- You should either see a blank screen or something garbled representing some binary data. This means you can connect to the server.
- If you get a message like:
Could not open connection to the host, on port 1433: Connection failed
It means you cannot connect and there is a network problem.
Following is a list of reason why you cannot connect.
- Most of the time a firewall is blocking the traffic. This firewall can either be on your local machine or on the server. Check both ends for a firewall. If the actual server is on a different network, for example across the Internet, there could be other firewalls in the middle.
- The server process is NOT running. Ensure the server is running
- Ensure the TCP/IP port number is correct. In the above example, I used 1433
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.