> I'm tring to set up my new dev machine, and I've got the same > SQLServer2000 setup I've used for years. I've set up > datasources ok using the control panel ODBC Administrator. > > But when I try to set up ColdFusion datasources, nothing I've > tried in the past is working. I keep getting this error: > > [quote] > The root cause was that: java.sql.SQLException: > [Macromedia][SQLServer JDBC Driver]Error establishing socket. > Unknown host: > [/quote] > > With my other pcs in the past, if I can't connect one way > I'll try another and it's always worked. I've tried (local), > 127.0.0.1, Notebook (thats my computer's name) for the server > names and none of them works. Always the same result as above. > Anyone got any other ideas?
Is SQL Server listening on TCP/IP? By default, it listens on Named Pipes (NetBIOS over TCP/IP), but you often have to configure the SQL Server network listener to also listen on TCP/1433. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204243 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
