CF on Mac, MSSQL on Parallels - More Gotchas

Here are full instructions for all the problems I came across and what I had to do to get it working. Please let me know if anyone has any other problems I missed!

Firstly you need MSSQL 2005 running under Parallels and to make sure you *have* Parallels running (duh!). Then try to connect using the IP you use to access Parallels (for me it is 192.168.2.5 using host only networking and sharing my Mac network connection with my PC - by far the best setup if you connect to lots of different networks as I do and also need to be able to code and run Parallels and Mac while on subway, etc.). Make sure you have a valid user account for the db with the proper credentials and password.

You'll probably get a "connection refused", so just to copy from Marks post:

I opened up Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager. In the manager open the "SQL Native Client Configuration" then "Client Protocols" and double click on "TCP/IP" you should get a window with: Default Port: 1433 Enabled:No Change the Enabled setting to yes. Then, open up Start -> Control Panel -> Windows Firewall and click on the "Exceptions" tab. "Click Add Port...", enter MS SQL as the name and add the port 1433. You should now be able to connect to the MS SQL server from ColdFusion on OS X

I *still* got connection refused. Firstly I had to go into the Protocols for SQL Express, TCP/IP and in the IP tab, scrolled down to the bottom and under IPAll set the port to 1433.

This got me in contact but I was getting the following error: "The user is not associated with a trusted SQL Server connection". Account was valid, but it seems I had MSSQL running in Windows Authentication mode which wasn't going to fly. I basically followed the following instructions of which the only part I needed to do was:

Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Microsoft SQL Server Management Studio”

Log in to SQL Server 2005 with windows authentication or sa user;

Highlight the server and right click “Properties”;

Highlight “Security” -> Under “Server authentication”, choose “SQL Server and Windows authentication mode”;

Highlight “Connections” -> Under “Remote server connections”, choose “Allow remote connections to this server”;

Click OK to save the settings.

Then I restarted MSSQL using Control Panel - Administrator Tools - Services and was up and running and able to access SQL from both my Win and Mac CF installs.

Phew!