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:247723 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
