Solved

Test IP connectivity between two DB hosts from a workstation

Posted on 2015-01-20
3
123 Views
Last Modified: 2015-01-20
Is there a easy way to test IP connectivity between two Windows SQL Server 2012 DB hosts from my Windows 7 workstation? I know the host names and IP addresses of both hosts and I can ping both hosts from my workstation OK, but I want to check that there is connectivity at the IP level between the hosts. Thanks for any help you can give.
0
Comment
Question by:FyllSee
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
Julia Smathers earned 500 total points
ID: 40560715
Install this on your Windows 7 station;
https://technet.microsoft.com/en-us/sysinternals/bb897553.aspx

After installation, open up a command prompt and type
psexec \\dbservername cmd
(Installation is copying the psexec file to your executable folder.)

This will connect you to the command prompt on the remote server.
From here you can do any command line tasks, such as ping.
0
 

Author Comment

by:FyllSee
ID: 40560875
Yes that looks exactly like what I need. It worked as expected and I was able to run paping to determine if a specific port was open. Heaps of thanks on you!
0
 

Author Closing Comment

by:FyllSee
ID: 40560876
Solved all my problems
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question