Sorry if you have already answered this but.... Is your SQL set up as "mixed" security?
Are you using the "username/password" attributes of the cfquery tag? The error below does not occur when the IP or hostname is unresolved. It occurs when trying to build the socket to the datasource. Make sure you are specifying the port correctly as well (1433 usually) and that nothing is blocking the port. Also make sure that you disable Named Pipes on the web server as a connection method and use only TCP/IP. Sometimes SQL tries to service requests in "mixed mode" - where the request comes through as tcp/ip but some part is serviced over a pipe - in the MS world this is called "multi-protocol". I always disable everything but TCP/IP. You can do this by using the Server Network Utility on the SQL server. -Mark -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Sunday, May 01, 2005 3:23 AM To: CF-Talk Subject: SQLServer Connect problem - was it ever resolved? 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? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205203 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
