> 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?
You need to specify an IP address or DNS name and a port. Each instance listens on a separate port, by default. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf_lists/message.cfm/forumid:4/messageid:246778 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4