VMware Communities: Message List - macbook pro running osx coldfusion trying to connect vmware vista ms-sql

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

cebdev — Wed, 10 Oct 2007 02:07:23 GMT

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

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

BP9906 — Thu, 04 Oct 2007 02:22:17 GMT

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.

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

rcardona2k — Thu, 04 Oct 2007 00:40:51 GMT

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.

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

cebdev — Wed, 03 Oct 2007 23:35:48 GMT

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