vmware - app on host, database on vm

[zambizzi]

I'm trying to do something a little out of the ordinary...only out of necessity.

I emerged vmware 5.0 (latest in portage as of today) and got it working great. I'm forced to use MS SQL Server 2000 at work to build applications on top of (Java).

I'd like to be able to develop (netbeans) on Linux and make my apps communicate w/ the sql server database on one of the vmware machines (windows 2000 server vm).

I'm using NAT as that's all I've gotten to work for networking on the VMs and also becasue I'm rather clueless when it comes to networking details.

I noticed my router is reporting *that* particular VM as a separate IP address (dhcp)....but I can't get the application to connect.

I'd rather not have to develop on the VM....I'd like to only have to use it for testing...how can I get this working?

Thanks!

-v

[dgaffuri]

I don't see any problem in doing this. Are you able to ping the windows vm? Are you running any firewall? You may want to post ifconfig and netstat -rn output, together with the IP address of the vm connection.
_________________
Adopt an unanswered post
If you feel that your problem has been solved please edit the top post and add [solved] to the subject

[zambizzi]

[dgaffuri]

If you're using NAT your vm shouldn't have an address from your router, but from vmware instead, using one of the vmnet subnets. Try to run ipconfig in windows to look at the assigned IP address.
_________________
Adopt an unanswered post
If you feel that your problem has been solved please edit the top post and add [solved] to the subject

[zambizzi]

OK, before we proceed w/ that, here's what I did.

I changed NAT to bridged networking...the vm then acquired its own IP address from my router. I ran nmap on that IP and found that 1433 was then open (after installing sp4 for sql server.)

So, I ran my app on the host (Gentoo) and it worked! It works great, too...the performance is (perceptably) about the same...so I'm pleased w/ that.

However, the vm is unable to get on the internet. I can't ping anything outside of my local network or get anything in a browser. ipconfig reveals that it has an IP on the network and should be fine. What's the deal there?

[dgaffuri]

Are you able to ping by address outside of the network? May you post ipconfig /all output from your vm?
_________________
Adopt an unanswered post
If you feel that your problem has been solved please edit the top post and add [solved] to the subject

[zambizzi]

No, I can't ping anything from the vm except the host PC...I can't ping the router or any other PC on the network and I cannot ping anything on the internet.

Here it is:

[brot]

I know that it is possible to do something like that. I ran a gameserver on my windows xp and connected via the wine emulated game. Sounds funny, but worked great

My vm has a bridged network, bridged to the card in the pc that is plugged in the switch. I gave a IP to the vm, and right after that, was able to ping my vm. So try it with a bridged nic, and a given ip adress (in the same subnet)...

[zambizzi]

Yeah, if you read above...I did do that and my app can now use the sql server on the vm as a backend just fine. However, w/ bridged networking (rather than NAT) - the vm can no longer hit the internet - even though it has its own IP.

It'd be nice to have my cake and eat it too - to have bridged allow the vm to talk to the 'net. It would be annoying to switch back-and-forth to NAT/bridged to have one or the other.

[brot]

Well, that is possible, too. Sorry, that i didnt point it out

Is the vmware interface bridged to the interface linux gets its net ?