VMware

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  

macbook pro running osx coldfusion trying to connect vmware vista ms-sql posted: Oct 3, 2007 4:35 PM

Click to view cebdev's profile Lurker 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
Click to view rcardona2k's profile Champion 5,212 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.
Click to view BP9906's profile Expert 364 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.

VMware Developer

SDKs, APIs, Videos, Learn and much more in the Developer community.

Learn More

Developer Sample Code

Increase your developer productivity with VMware API sample code.

Learn More

VMworld Sessions & Labs

Online access to the latest VMworld Sessions & Labs and online services.

Learn more

Purchase PSO Credits Online

Purchase credits to redeem training and consulting services online.

Buy Now

Community Hardware Software

View reported configurations or report your own.

Learn More

VMware vSphere

Come witness the next giant leap in virtualization.

Register Today

Communities