• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1190
  • Last Modified:

Tunnel from VMWare Player running XP to MSSQL Server on Host

Hi.
 I have Windows XP running in a virtual machine (VMWare Player) on my Windows 7 PC (host).   I have MSSQL Server 2008 running on the host.

 I would like an application running in the virtual machine to access the MSSQL databases running outside the virtual machine. This would be through an ODBC connection on the XP virtual machine, referencing a SQL database outside the virtual machine.

I thought I read that there is a way to do this through "tunneling", and that there is some software available to simplify the tunneling.
Is this true?  Any suggestions regarding tunneling and MSSQL Server?
Thanks!
0
Rob Rudloff
Asked:
Rob Rudloff
  • 2
  • 2
  • 2
  • +1
4 Solutions
 
JohnBusiness Consultant (Owner)Commented:
Tunneling (as I know it) is just VPN software. I tried VPN software on an XP machine running in VMware on a Windows Vista then Windows 7 host and it did not work.

Is there something you absolutely need to do in XP? This kind of connection is best done natively on a host if you can do that.  ... Thinkpads_User
0
 
bgoeringCommented:
No tunneling would be required. The vm can talk to any application on the host. If you are using bridged networking just specify the LAN address of the host for the sql server. If you are using host-only specify the host's IP address for the Network adapter vmnet1, likewise if using NAT networking specify the IP address for the network adapter vmnet8.

You can find those by going into network properties on the host, select the adapter, then tcp/ip v4 properties.

Good Luck
0
 
bgoeringCommented:
Note that you may need to make a firewall rule on the Windows 7 host to allow the traffic...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Have a look a your network options in VMware Player, it would be easier if you selected Bridgded Networking. Maybe you are referring to NAT (tunnel!).

Check out this link for details of how to check and change your networking

http://www.vladan.fr/bridging-network-adapters-in-vmware-player-3-1/
0
 
Rob RudloffIT Development SpecialistAuthor Commented:
ah ha ... ok, it's the VM's current network settings that are getting in my way.  I'll create a new VM with bridging turned on and see if i can make that work.
--more later
-- thanks
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
NAT (advanced), Host only or Bridged should all work for you, but Bridged, as the VM, becomes part of your network and internal LAN. (via the host interface), so packets will leave the host interface and come back to the host interface (different IP addresses), if there is still issue, I would look at firewalls on VM and Host.
0
 
Rob RudloffIT Development SpecialistAuthor Commented:
Thanks.

bgoering solution filled the gap in my knowledge of how networking works with the VMWare.

Bridged networking is the way I went with this, and once I got through my various firewall issues with SQL Server, I was able to test an ODBC connection form the virtual machine to SQL Server on the host.

hanccocka had a good tip -- traffic on the bridged network from the virtual machine may leave the actual computer, go through the actual switch, and come back to the host on the same machine.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now