Microsoft SQL Server 2005 running on Mac OS X
I bought one of the new MacBook Pros last week. I absolutely love it. I have used a couple of different database engines on the Mac in the past such as MySQL, Sybase, Oracle and more recently Derby. Because the processors in my Mac where based on PowerPC processors, I was never able to run SQL Server with out some type of emulation. Anyone who ever ran Virtual PC on the Mac knows what I am talking about.
I installed boot camp on the Mac initially with Windows XP. I downloaded the trial of Parallels Desktop 3.0 for the Mac and and it will use the boot camp partition.
I then installed the developer edition of SQL Server 2005 on XP. I have the beta of ColdFusion 8 running on my Mac, and I wanted to be able to access the database I was running on Parallels. Initially I could not get this to work. The default setup of Parallels does not allow the Mac to access servers running on Parallels. I was able to get this to work by changing the networking on Parallels to "Bridged Ethernet". I can now access SQL Server through JDBC on my Mac through parallels.
I am getting ready to work on a project using Oracle 10g. I will most likely run it the same way I am running SQL Server, just with a different operation system.
Also, can you give a bit more detail on what the configuration settings were to connect to your local MS SQL DSN - specifically, what server path? Thanks for this post!
I would suggest not installing boot camp. Boot camp is still a beta product, and will not be built in to the Mac OS until Leopard.
I would install Parallels Desktop 3.0, then install WIndows XP and SQL Server 2005. I set up Parallels to use a "Bridged Ethernet" connection. Once you have SQL Server installed and tcp/ip networking enabled turned on in the SQL Client config you can set up the DSN.
I used the ColdFusion database settings to connect to SQL Server. This uses JDBC to establish the connection to SQL Server. Windows running in Parallels will have its own IP address that you can use for the address of the SQL Server in your settings. You can get this by going to the command line in Windows and typing "ipconfig". I believe you can also get this address by typing "ifconfig" in the Mac OS X terminal application and looking for a second address. It should be under en2 or en3 interfaces.
Good luck,
David.
What you mean that you could not get it to run? I am running Oracle 10g with Parallels since over a year with no problem.
I have just bought Vantage Point Software that runs on a PC. It tries to install SQL Server 2005 in the Virtual PC. WHICH fails because SQL Server 2005 needs a Pentium III & Virtual PC only emulates a Pentium II -
SO I am interested to read that you have succeded.
HOW can I do this?
Or (better still) can I run RealSQL on my apple & make it look like SQL 2005 to the Vantage Point S/W running in the Virtual PC?
Thanks in anticiaption - or am I asking the impossible?
Parallels will allow you to have two IP addresses, one for the Mac, and one for WIndows running at the same time. I simply pointed my JDBC connection to the IP address used by Parallels.
Hope that helps,
David.