[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1171
  • 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
 
John HurstBusiness 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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