> Also, has anyone been successful in getting CF to > talk > to SQL Server 2005 Express?
I have this working on my workstation. The key things are: 1. Enable TCP/IP. Use the configuration manager, and under "network configuration" AND under "Client configuration" -> "Protocols", make sure TCP/IP is enabled. It's disabled by default. 2. Take note of the port number under "Network Configuration" -> "TCP/IP" -> (Double Click) "Properties" -> "IP Addresses" Tab -> "IP All" section -> "Dynamic Port Number" - I _think_ it's different per install, and you'll need to specify this in the DSN setup in CF. 3. You need to make sure SQL Server Authentication is enabled also, and use a SQL server login account to connect. Once all of these things are set/verified, you should connect with no problem. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
