Solved

windows 7 discovery of different networks

Posted on 2013-05-24
4
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Suggested Courses
Course of the Month10 days, 1 hour left to enroll

623 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