Wow, I posted this like a week ago! I figured it out... it had to do with SQL Express running on a random port rather than the standard 1433.
Rick Steve Brownlee wrote: > Rick: > > Check out > http://www.orbwave.com/cfjboss/2006/04/connecting-coldfusion-to-sql-server.h > tml > > Walks you through step-by-step > > - Steve > >> -----Original Message----- >> From: Rick Root [mailto:[EMAIL PROTECTED] >> Sent: Monday, July 17, 2006 7:54 AM >> To: CF-Talk >> Subject: Problem with SQL Express datasource on CFMX 7 >> >> I'm running CFMX 7 Development edition on my local windows XP >> box with SQL Server 2005 Express Edition installed. >> >> I have enabled TCP/IP connectivity and mixed-mode >> authentication, but I can't seem to get a datasource set up. >> >> I've tried various versions of the "Server" in the DSN setup.. >> >> My computer's hostname is "RICK200607" >> >> using "RICK200607\SQLEXPRESS" causes: >> >> Connection verification failed for data source: cfmbb_mssql >> java.sql.SQLException: [Macromedia][SQLServer JDBC >> Driver][Macromedia][SQLServer JDBC Driver]The requested >> instance is either invalid or not running. >> The root cause was that: java.sql.SQLException: >> [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer >> JDBC Driver]The requested instance is either invalid or not running >> >> Using just "RICK200607" causes: >> >> Connection verification failed for data source: cfmbb_mssql >> java.sql.SQLException: [Macromedia][SQLServer JDBC >> Driver]Error establishing socket. Connection refused: connect >> The root cause was that: java.sql.SQLException: >> [Macromedia][SQLServer JDBC Driver]Error establishing socket. >> Connection refused: connect >> >> >> What's going on here? What am I doing wrong? >> >> Thanks! >> >> Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247725 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
