What has probably happened is that SQL Server Express installed using some other port. Here is what you need to do in order to get SQL Server Express working with CF:
Open the SQL Server Configuration manager Go to SQL Server 2005 Network Configuration > Protocols for SQL Express Double-Click TPC/IP Scroll all the way down to the IPAll area and look at the TCP Dynamic Ports. That is the port that SQL Server is running on. HTH, Bruce On 8/13/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > > I have SQL Express installed and am having connection problesm when > verifying the datasource. The CF erro is "...failed for datasource...error > extablishing socket..." I found a KB (#400255) on Adobe 's site and went > through the steps, but have some questions. > > It reads to note the TCP port. Is that 1433? Also, it reads to "Configure > a SQL Server JDBC data source in the CF Admin to isten to the port number". > How is that done? > > Any help appreciated. > > Thanks. > > RO > HWW > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
