I had this same problem. Make sure you are using MS-SQL Service Pack 3 or better
-----Original Message----- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 3:05 PM To: CF-Talk Subject: Trouble connection to local database I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: "Connection verification failed for data source: Localdb []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" Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is "sa", and pw has been entered correctly. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222112 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
