VMware Communities > VMTN > Desktop Products > VMware Fusion > Discussions
Up to Discussions in VMware Fusion

This Question is Not Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
3 Replies Last post: Oct 9, 2007 7:07 PM by cebdev
Reply

macbook pro running osx coldfusion trying to connect vmware vista ms-sql

Oct 3, 2007 4:35 PM

Click to view cebdev's profile Lurker cebdev 2 posts since
Oct 3, 2007
I'm running coldfusion and my-sql on my macbook pro. I have a project that requires ms-sql as the database. I have vmware with a vista installation running fine with the ms-sql database.

My question: What do I put as the server name in the coldfusion administrator to connect to the vista image ms-sql database? Up to this point the server has always been localhost or localhost:8500, etc. How do find out how to referenc the vmware vista machine and access its running ms-sql database?

Thanks for listening.

Craig
Tags: vmware_fusion, mac, ms-sql
Reply Re: macbook pro running osx coldfusion trying to connect vmware vista ms-sql Oct 3, 2007 5:52 PM
Click to view rcardona2k's profile Champion rcardona2k 4,903 posts since
Oct 20, 2005
First check the networking for your VM. You should use Bridged networking to make this easier. Next check the IP address of your Vista box, you can run Start > cmd > ipconfig to get the address. Then in OS X you should be to change "localhost" to the numeric IP, e.g. 192.168.0.3 or whatever.

SQL Server (not Express) can be configured to listen on localhost so you should look at the Surface Area Configuration Manager (SQL 2005) to make sure it allows connections from remote hosts.

Oh and of course you'll have to configure the Vista firewall to allow your SQL connections too.
Reply Re: macbook pro running osx coldfusion trying to connect vmware vista ms-sql Oct 3, 2007 7:22 PM
in response to: rcardona2k
Click to view BP9906's profile Expert BP9906 362 posts since
Jun 15, 2007

mySQL can be configured to listen on your mySQL port like SQL Server. It might be easier for you to put your Vista VM in bridged mode, then you can just use your IP specified in Vista. If you use the NAT option, you can use the IP listed in Vista, just be aware that it uses an interface specific to VMware on OSX.

Hope this helps.

Reply Re: macbook pro running osx coldfusion trying to connect vmware vista ms-sql Oct 9, 2007 7:07 PM
in response to: rcardona2k
Click to view cebdev's profile Lurker cebdev 2 posts since
Oct 3, 2007

I changed to "bridged" and checked the IP (which appears to be 10.0.1.194) I put this in as my coldfusion server name. It's trying to use port 1433 to access MS-SQL. Are you suggesting that the VISTA firewall needs to expressly leave this port open?

Thanks,

Craig

Actions
Up to Discussions in VMware Fusion