Linux – How to connect VMware Workstation on local network to access a database server

databaselinuxlinux-networkingvmware-workstation

Environment

Host OS: Win7 x64
VMware Workstation: SUSE Linux Enterprise Server 11 running a Teradata database server.

Details

I've mounted a demo Teradata Express for VMware database server on my local machine and am trying to connect to the Teradata database server on the VM image.

The VM:

  • Can connect to the internet.
  • Is network connected via a Bridged network.

The Host:

  • Can see the VMware Network Adapter (using an ipconfig /all)

From here, how can I connect to the VM from my local machine (host) to the VM's Teradata database server to query for data? I'm not asking what to use for a connection string; rather, what else would I need to make the connection work?

Best Answer

Is your Host system able to connect to the DB server? The VM system should be seamless on the network if you configured your VM adapter to use NAT. If you chooses Bridge Network type then there are other things to check.

If you are using NAT, make sure from your VM you can ping your Win System. If that works, then there should not be any reason you can't connect. Because that is as if you are connecting from your Win System.

If you are using Bridge, That means your VM system has a unique IP on the same network as your Win system. The DB server will treat it as a new system, then you need to look at the configuration on the BD server as well, some DB server may exclude on IP addresses.