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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Flash MX Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=57 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
