[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

windows 7 discovery of different networks

Posted on 2013-05-24
4
Medium Priority
?
338 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
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…

613 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