Spend a few hours so far trying to figure this one out. Trying to connect MX7
on one box to a SQL SERVER 2005 on a different box.

Here's the issue, if I connect both boxes to a router that serves up IP's and
both boxes are setup to automatically obtain IPs then the connection works
perfectly fine and I am able to query the db through the CF site. However, I
need to have the two boxes connected together directly via network cards. I
made sure I'm using a cross-over cable. The connection seems to work fine. Can
do file transfers, etc. But I can't get ColdFusion to work with that type of
connection.

The only difference in the Admin setup, as I understand, is in the "Server"
field. Instead of having simply "servername" I have "\\machinename\servername".
I also tried many variations of it like using the IP address instead of the
name. Nothing works. Keep getting "unknown host" socket error.

Anyone can figure this out?