Did you check to make sure TCP/IP is enabled for your SQL server? On 10/24/05, Christophe Maso <[EMAIL PROTECTED]> wrote: > > 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. > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222114 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
