Getting MS SQL 2005 running on OS X
Posted At : December 22, 2006 9:42 AM
| Posted By : Mark Drew
Related Categories:
microsoft,
apple
Ok, the title is a bit misleading, but if you are using Parallels it isnt. I come across a problem of connecting ColdFusion server (running under OS X) to a newly installed version of Microsoft SQL Server 2005 running under Parallels. After I installed SQL Server, I was able to ping the machine but not connect to it and was getting "Connection Refused" errors in the Datasource setup under CFAdmin. To start off with, I went to check if the service was running. Since it was, 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
Thanks for addressing this. I followed your instructions and still ran into the same problems. After that I went into the SQL Server Configuration tool and enabled my local IP addresses. That seemed to do the trick. Thanks for this resource. It was super helpful.
My situation is that I had my SQL Server running fine under parallels until I upgraded to 3.0. Suddenly I can't connect to it anymore. I have checked all the settings per the original post and they appear fine.
Thanks for your help.