Thanks Dave and Mark, Yes I did know these things, and had checked them. I've also double checked them since you mentioned them. I've set up my new SQLServer exactly the same as my others, which all work, and this one doesn't.
I'm suspecting now it's a firewall issue rather than a problem with the setup of SQLServer or CFMX. I can set up datasources on external servers so I am certain CFMX is set up correctly. It's not a biggie, because I can run using the ODBC driver, and since I'm the only one going to be using this server (it's the dev server on my notebook) I dont have to worry about performance issues. It's only used so I can look at my own site's pages on my own dev machine. I'll find the answer one day, but I'm not going to worry about it any more for now. I was just wondering if we ever found out what Robert's solution was. Thanks for your thoughts though, Dave and Mark. 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 On 5/2/05, Mark A Kruger <[EMAIL PROTECTED]> wrote: > 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 > > ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205205 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
