Tunnel from VMWare Player running XP to MSSQL Server on Host

Posted on 2011-05-04
Last Modified: 2012-05-11
 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?
Question by:RobRud
    LVL 89

    Expert Comment

    by:John Hurst
    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
    LVL 28

    Accepted Solution

    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
    LVL 28

    Assisted Solution

    Note that you may need to make a firewall rule on the Windows 7 host to allow the traffic...
    LVL 116

    Assisted Solution

    by:Andrew Hancock (VMware vExpert / EE MVE)
    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

    Author Comment

    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
    LVL 116

    Assisted Solution

    by:Andrew Hancock (VMware vExpert / EE MVE)
    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.

    Author Closing Comment


    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.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
    Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now