> Some time ago, Robert Everland had a problem with creating > ColdFusion datasources for SQLServer, getting an error > "Connection refused". There were lots of suggestions but > the archives dont seem to say what was the actual solution. > Does anyone know what the solution was? I've been through > the sugestions given at the time and anything else I can > think of and the problem persists. > > Specifically, the error message says: > > [quote] > Connection verification failed for data source: afpwebworks > 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 [/quote] > > I've reinstalled SQLServer and CFMX7, I've tried using > (local) as the server name, also 127.0.0.1 also localhost > also WDEV01 (the computer's > name and the instance name of SQLServer) and none work. In fact > using (local) as the servername, gives a different error, the > problem then is "unknown host: (local) > > To create a datasource, I have to create it in the control > panel, then use the ODBC driver. It works ok , and its fast > enough for a dev machine - it will only have one user at a > time in any case - but i'd like to know what's wrong with the > setup of SQLServer or CFMX if i can find it out. > > I tried writing to Robert, but his email address at the time > is no longer working. > > Anyone know what's wrong here?
It could be a lot of things, which is probably why you couldn't find a specific solution in the archives. My initial guess is that your database server is not configured to listen for requests directly from TCP/IP, but instead is just using the default Named Pipes listener which won't work with CFMX. You will need to run the Server Network Utility to ensure that your SQL Server is configured to listen to TCP/IP requests. You can't use "(local)" or anything else other than a properly resolving IP address or DNS name from CFMX. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205201 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
