I'm not able to connect to sql server with anything but 127.0.0.1 on the server machine. If I try to connect via actual IP on the network it does not work locally or remotely.
The environment is SQL Server 2005 on Windows Server 2000. My goal is to connect to this SQL Server instance from a remote machine.
I've tried telneting to port 1433 using the actual IP and that fails. I've tried turning off Windows Firewall completely
Any ideas or help is greatly appreciated! Thanks