Solved

windows 7 discovery of different networks

Posted on 2013-05-24
4
308 Views
Last Modified: 2013-06-04
I have 2 windows 7 pro workstations in 2 different geographical locations.  These locations are connected using 2 sonicwall vpns.

One is on a 192.168.2 network and the other is on a 192.168.20 network.  Both are joined to the same domain using the same DNS server.  Both are registered correctly within my DNS and Active Directory.

They discovery other devices on their local networks but none on any other subnets or networks.

I can ping, and remote desktop to each one from the other, but I cannot see either one through network discovery.

I need them to be able to discover each other so they can share a mySQL database.  The vendor setting up the database connection says if they can't see each other through network discovery the connection between the mySQL databases can't work.

Anyone have any idea as to why the discovery isn't working?
0
Comment
Question by:a245439
  • 2
4 Comments
 
LVL 4

Expert Comment

by:EddyvanOpdorp
ID: 39195706
Is the sql-agent service running ?
0
 
LVL 31

Accepted Solution

by:
Frosty555 earned 500 total points
ID: 39195848
"Network Discovery" uses the Link-Layer Topology Discovery protocol:

http://en.wikipedia.org/wiki/Link_Layer_Topology_Discovery

It is a Layer-2 service, it cannot cross a router, or a VPN. It is limited to a single local network segment only.

That being said, it is also completely unnecessary for a MySQL connection. MySQL listens on TCP port 3306. The client only needs to know the IP address of the MySQL server (or a hostname which your DNS server will resolve). Provided you can configure the client with the appropriate hostname of the server it will connect regardless of whether the server is on the local network, across a VPN, or across the Internet.

Network discovery is not a prerequisite for MySQL connections.  If your vendor says otherwise... I would be very concerned with their product.
0
 

Author Comment

by:a245439
ID: 39197095
Frosty555, thank you very much for the informative and detailed answer.  That is exactly what I was looking for.

I will get my firewall vendor to setup a NAT policy for port 3306 and the 2 IP addresses and see if that resolves my problem.

I will let you know how it turns out.
0
 

Author Closing Comment

by:a245439
ID: 39220297
As it turns out, all we had to do was create a mapped drive between the 2 workstations on different networks and then my vendor was able to connect the remote client to the mySQL database
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now